SELECT 
  *, 
  cscart_product_tabs.status as status, 
  cscart_product_tabs.block_id as block_id, 
  cscart_product_tabs.company_id as company_id, 
  cscart_product_tabs_descriptions.name as name 
FROM 
  cscart_product_tabs 
  LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id 
  LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id 
WHERE 
  cscart_product_tabs_descriptions.lang_code = 'en' 
  AND cscart_product_tabs.company_id = 1 
ORDER BY 
  position

Query time 0.00088

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_tabs ALL PRIMARY 75 Using where; Using filesort
1 SIMPLE cscart_product_tabs_descriptions eq_ref PRIMARY PRIMARY 9 mahm3t_cs443.cscart_product_tabs.tab_id,const 1 Using index condition
1 SIMPLE cscart_bm_blocks eq_ref PRIMARY PRIMARY 4 mahm3t_cs443.cscart_product_tabs.block_id 1 Using where

Result

tab_id tab_type block_id template addon position status is_primary product_ids company_id show_in_popup lang_code name type properties fpc_exclude_cache
68 T 0 blocks/product_tabs/description.tpl 0 A Y 1 N en Description
175 T 0 addons/image_gallery/blocks/product_tabs/image_gallery.tpl image_gallery 1 A Y 1 N en Images gallery
134 B 677 2 D N 1 N en Related products products a:4:{s:8:"template";s:41:"blocks/products/products_multicolumns.tpl";s:11:"item_number";s:1:"N";s:17:"number_of_columns";s:1:"2";s:23:"hide_add_to_cart_button";s:1:"N";} N
69 T 0 blocks/product_tabs/features.tpl 3 A Y 1 N en Features
84 B 278 4 D N 500,501,502,503,508,509,510,10113 1 N en Colors html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
142 B 694 5 D N 9513,10114,10115,10116,511,10111,10160,10192,10502 1 N en SAH colors html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
85 B 289 6 D N 493,494,497,498,499,500,501,502,503,504,505,508,509,510,512,513,570,571,572,573,574,575,576,577,578,593,594,600,669,670,671,672,673,674,1166,1167,1168,8346,8347,8348,8349,8350,8351,3245,579,580,581,582,583,584,585,587,592,3246,9861,10113,10176,10482,10501,10649 1 N en Products comparison html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
89 B 300 7 D N 1 N en How to video html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
90 B 302 8 D N 8272,8273,8274,8275,8276,8277,8281,8283,8284,8285,8286,8287,8288,8289,8290,8291,8299,8300,8301,8302,8303,8304,8305,8306,8361,8362,8363,8364,8365,8366,8367,8368,8369,8370,8371,8665,8666,8720,8728,8729,8730,8731,8732,8733,8734,8735,8856,9481,9482,9483,9484,9816,9817,9818,9819,9820,9866,9867,9868,9869,9874,9875,9876,9877,9878,9879,9880,9881,9882,9883,9885,9893,9894,9895,9896,9897,9898,9899,9900,9901,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10041,10042,10043,10044,10046,10047,10048,10049,10050,10051,10052,10053,10054,10055,10056,10057,10058,10059,10060,10061,10062,10143,10144,10145,10146,10147,10148,10149,10150,10151,10152,10153,10154,10155,10156,10166,10167,10168,10169,10170,10171,10176,10225,10226,10227,10228,10229,10230,10231,10413,10414,10419,10420,10421,10422,10423,10424,10425,10426,10427,10428,10429,10430,10431,10432,10433,10434,10435,10436,10437,10438,10439,10440,10441,10442,10444,10445,10446,10447,10448,10449,10450,10451,10452,10453,10454,10455,10456,10457,10458,10459,10460,10461,10462,10652,10653 1 N en How-to-video html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
80 B 284 9 D N 8860,8861,8862,8863,8864,8865,8866,8867,8868,8869,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8884,8885,8886,8887,8888,8889,8890,8891,8892,8893,8894,9870,10076,10077,10078,10079,10097,10098,10099,10100,10172,10173,10174,10202,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10213,10214,10215,10216,10217,10650,10703,10704,10714,10944,10945,10946 1 N en Flashing products a:4:{s:8:"template";s:28:"blocks/products/products.tpl";s:11:"item_number";s:1:"N";s:12:"hide_options";s:1:"N";s:23:"hide_add_to_cart_button";s:1:"N";} N
82 B 279 10 D N 387,388,389,390,391,392,393,395,396,397,398,399,400,401,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,2528,2529,394,9871,9872,9873,9887,9917,9918,9919,9925,10110,10123,10159,10163,10164,10165,10181,10182,10183,10184,10185,10188,10194,10201,10353,10354,10355,10712,10960,11485,11486 1 N en Flashing products a:4:{s:8:"template";s:28:"blocks/products/products.tpl";s:11:"item_number";s:1:"N";s:12:"hide_options";s:1:"N";s:23:"hide_add_to_cart_button";s:1:"N";} N
151 B 702 11 D N 402,404,4939,7351,7352,9930,9931,9933,10068,10104 1 N en Compatibility html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
155 B 706 12 D N 7353,10012,10013,405,406,407 1 N en Compatibility html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
128 B 625 13 A N 8312,430,414,426,428,431,434,435,436,437,438,439,443,504,527,617,651,717,750,1805,1806,3322,8281,8286,8303,8313,8314,8352,8364,8371,8665,9457,9463,9470,9818,9843,9845,9853,9865,9880,9938,10071,10157,10161,10195,10670,10699,10705,10707,429,478,480,494,514,533,598,659,670,1186,1804,3245,3318,3320,3321,3323,3325,4939,7353,8275,8288,8289,8295,8300,8304,8306,8361,8365,8367,8666,8721,8733,8856,9842,9851,9882,9883,9885,9963,10065,10070,10073,10074,10101,10104,10221,387,389,397,404,405,407,479,493,515,576,579,582,597,658,660,1187,3319,8274,8277,8299,8305,8362,8369,8373,8720,9485,9838,9848,9849,9868,9876,9877,9934,9935,9943,10063,10067,10103,10152,10167,10188,10201,10219,10353,390,393,401,402,406,520,526,534,551,616,662,706,1154,1645,1655,7351,7352,8273,8283,8285,8301,8363,8370,8682,8686,9481,9482,9819,9820,9839,9850,9864,9968,10105,10107,10148,10168,10177,10186,10191,10222,10355,388,395,398,495,505,524,574,575,599,672,704,1310,1648,3509,8287,8368,8730,8731,8735,9458,9483,9513,9815,9817,9855,9862,9863,9875,9879,9892,9900,9939,10110,10160,10162,10163,10220,10223,10423,10428,391,497,516,517,523,535,563,566,572,593,653,655,657,669,673,1155,1189,1311,1644,1777,8284,8291,8728,8729,8732,8734,9484,9866,9869,9874,9878,9898,9945,9947,9965,9966,10013,10068,10072,10145,10170,10430,392,446,522,528,561,577,578,603,606,609,622,625,654,674,675,721,1157,1161,1168,4115,8272,8276,9510,9854,9867,9893,9894,9897,9899,9912,9913,9931,9936,9937,9940,10012,10034,10114,10116,10124,10125,10147,10194,10218,10434,396,427,499,506,511,519,548,549,554,556,560,564,565,580,600,638,661,705,709,711,713,1166,1167,1787,2528,3246,3324,3520,8347,8683,9467,9810,9816,9825,9826,9840,9844,9861,9871,9873,9891,10033,10143,10146,10153,10159,10413,10426,521,536,559,583,594,608,619,620,627,685,689,707,710,718,720,1159,1162,1171,1172,1178,1181,1193,1196,1197,1628,1647,2529,3533,9841,9881,9944,9946,9957,9967,9972,9991,10000,10023,10027,10041,10144,10149,10150,10151,10187,10438,10441,394,399,501,507,525,552,553,656,686,719,1156,1160,1174,1190,1640,3507,3527,3530,3531,3532,8349,9859,9872,9911,9916,9973,9974,9975,9979,9990,9997,10020,10024,10035,10037,10038,10044,10060,10106,10123,10154,10156,10169,10182,10351,10440,10444,10671,400,423,529,555,567,601,623,714,715,1163,1180,1182,1801,3510,3521,3538,8290,8350,8684,9480,9887,9890,9941,9964,9970,9976,9977,9978,9995,10008,10014,10016,10019,10022,10025,10028,10029,10036,10047,10051,10052,10057,10059,10062,10111,10224,10225,10427,421,432,518,584,585,592,604,605,624,626,642,1183,1638,1651,1802,3508,3524,3528,8677,8685,9476,9858,9933,9949,9982,9987,9992,9998,10003,10010,10011,10021,10026,10048,10049,10050,10053,10054,10056,10058,10061,10117,10120,10171,10184,10419,10653,447,498,500,502,512,530,557,570,573,602,629,630,632,640,644,646,716,722,1158,1192,1639,1649,1796,1798,1799,1803,7354,9811,9846,9852,9857,9870,9889,9901,9950,9956,9969,9985,10031,10043,10064,10102,10113,10119,10121,10384,10459,10501,420,452,558,571,581,631,635,636,639,641,725,1016,1017,1184,1194,1654,1795,1797,1800,9468,9888,9930,9955,9960,9989,9994,10018,10030,10032,10040,10042,10081,10112,10118,10137,10164,10176,10226,10227,10232,10350,10363,10414,10483,10702,10967,424,508,568,569,607,1646,1650,1652,1653,2142,3326,3506,8346,8376,9948,9996,9999,10015,10017,10039,10069,10108,10109,10115,10165,10181,10183,10190,10231,10385,10405,10417,10418,10420,10425,10429,10431,10432,10435,10436,10445,10461,10462,10463,10465,10466,10502,11200,422,510,513,587,612,613,633,634,645,647,671,1641,9466,9847,9951,9953,9954,10131,10132,10166,10229,10354,10364,10367,10368,10369,10371,10373,10374,10376,10377,10379,10382,10383,10387,10388,10389,10439,10442,10460,10464,10480,10482,10678,10961,11204,11210,425,503,509,531,532,637,650,1185,1188,1191,1195,8302,8351,8719,9469,9942,9952,10122,10126,10127,10128,10129,10130,10133,10134,10135,10155,10180,10228,10230,10233,10372,10375,10378,10381,10386,10408,10649,10701,10711,10962,10966,11203,11206,11211,11214,11216,11217,11218,11222,737,8348,8366,9474,9475,9477,9498,9506,9507,9508,9509,9511,9828,9830,9833,9837,9856,9860,9895,9896,9961,10046,10055,10136,10158,10185,10234,10235,10236,10370,10421,10422,10433,10437,10500,10652,11205,11207,11208,11219,11220,11221,11223,11224,11225,9827,9829,9831,9832,9834,9835,9836,10192,10237,10238,10424,10446,10447,10448,10449,10450,10451,10452,10453,10454,10455,10456,10457,10458,10499,10669,10677,10680,10712,10959,10960,10965,11196,11199,11209,11215,11482,11485,11486 1 N en Glazing html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
70 T 0 blocks/product_tabs/files.tpl 14 A Y 1 N en Files
129 B 673 15 D N 1 N en Desing it yourself html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
137 B 689 16 D N 675,677,678,679,680,681,683,685,686,689,690,693,695,696,697,1171,1172,1173,1174,1175,1176,1177,1178,2523,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3537,3538,9499,9500,9501,9502,9504,9505,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981,9982,9983,9984,9985,9986,9987,9988,9989,9990,9991,9992,9993,9994,9995,9996,9997,9998,9999,10000,10001,10002,10003,10004,10005,10006,10007,10008,10009,10010,10365,10366,10367,10368,10369,10370,10371,10372,10373,10374,10375,10376,10377,10378,10379,10380,10381,10382,10383,10385,10386,10387,10388,10393,10394,10395,10396,10397,10398,10399,10400,10401,10402,10403,10404,10405,10406,10407,10408,10410,10411,10412,10415,10416,10417,10418,10463,10464,10465,10466,10467,10468,10469,10470,10471,10472,10473,10474,10475,10476,10477,10478,10479,10481,10696 1 N en Design It Yourself html_block a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} N
141 B 693 17 D N 1 N en Stegu Musterstücke
157 T 0 addons/attachments/blocks/product_tabs/attachments.tpl attachments 18 A Y 1 N en Attachments
160 T 0 addons/discussion/blocks/product_tabs/discussion.tpl discussion 19 A Y 1 N en Reviews
163 T 0 addons/sd_youtube/blocks/product_tabs/youtube_video.tpl sd_youtube 20 D Y 1 N en YouTube video
168 T 0 addons/1clue_product_inquiry/blocks/product_tabs/product_inquiry.tpl 1clue_product_inquiry 21 D Y 1 N en Product inquiry
170 B 711 21 A N 1 N en Versandkosten shipping_estimation a:1:{s:8:"template";s:60:"addons/sd_shipping_estimation/blocks/shipping_estimation.tpl";} N
171 T 0 addons/cp_size_charts/blocks/product_tabs/cp_size_charts.tpl cp_size_charts 22 A Y 1 N en Size charts
174 T 0 addons/image_gallery/blocks/product_tabs/gallery_images.tpl image_gallery 23 A Y 1 N en Gallery images