SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001588s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006957s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15453460 LIMIT 5 [ RunTime:0.016444s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453460 ORDER BY `minOrder` ASC [ RunTime:0.002288s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15453460 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15453460 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453460 ORDER BY `minOrder` ASC [ RunTime:0.003746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444879 LIMIT 5 [ RunTime:0.002899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444879 ORDER BY `minOrder` ASC [ RunTime:0.001226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11444879 ORDER BY `unit` DESC [ RunTime:0.002521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11444879 LIMIT 2 [ RunTime:0.004433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444879 ORDER BY `minOrder` ASC [ RunTime:0.005692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12408480 LIMIT 5 [ RunTime:0.043598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12408480 ORDER BY `minOrder` ASC [ RunTime:0.003346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12408480 ORDER BY `unit` DESC [ RunTime:0.009827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12408480 LIMIT 2 [ RunTime:0.007002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12408480 ORDER BY `minOrder` ASC [ RunTime:0.006833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19790653 LIMIT 5 [ RunTime:0.024286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19790653 ORDER BY `minOrder` ASC [ RunTime:0.021091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19790653 ORDER BY `unit` DESC [ RunTime:0.010637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19790653 LIMIT 2 [ RunTime:0.011267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19790653 ORDER BY `minOrder` ASC [ RunTime:0.014215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19658417 LIMIT 5 [ RunTime:0.021181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19658417 ORDER BY `minOrder` ASC [ RunTime:0.011834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19658417 ORDER BY `unit` DESC [ RunTime:0.004335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19658417 LIMIT 2 [ RunTime:0.013122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19658417 ORDER BY `minOrder` ASC [ RunTime:0.021266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652102 LIMIT 5 [ RunTime:0.012715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652102 ORDER BY `minOrder` ASC [ RunTime:0.016997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652102 ORDER BY `unit` DESC [ RunTime:0.005230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652102 LIMIT 2 [ RunTime:0.008291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652102 ORDER BY `minOrder` ASC [ RunTime:0.009639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651425 LIMIT 5 [ RunTime:0.006076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651425 ORDER BY `minOrder` ASC [ RunTime:0.009204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651425 ORDER BY `unit` DESC [ RunTime:0.010130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651425 LIMIT 2 [ RunTime:0.012863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651425 ORDER BY `minOrder` ASC [ RunTime:0.015164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649002 LIMIT 5 [ RunTime:0.002217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649002 ORDER BY `minOrder` ASC [ RunTime:0.003705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649002 ORDER BY `unit` DESC [ RunTime:0.017352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649002 LIMIT 2 [ RunTime:0.028161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649002 ORDER BY `minOrder` ASC [ RunTime:0.020604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643691 LIMIT 5 [ RunTime:0.006279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643691 ORDER BY `minOrder` ASC [ RunTime:0.013004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643691 ORDER BY `unit` DESC [ RunTime:0.012829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643691 LIMIT 2 [ RunTime:0.025798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643691 ORDER BY `minOrder` ASC [ RunTime:0.013832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643675 LIMIT 5 [ RunTime:0.014101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643675 ORDER BY `minOrder` ASC [ RunTime:0.023356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643675 ORDER BY `unit` DESC [ RunTime:0.020128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643675 LIMIT 2 [ RunTime:0.005098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643675 ORDER BY `minOrder` ASC [ RunTime:0.001779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636349 LIMIT 5 [ RunTime:0.004658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636349 ORDER BY `minOrder` ASC [ RunTime:0.007794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636349 ORDER BY `unit` DESC [ RunTime:0.004050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636349 LIMIT 2 [ RunTime:0.005790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636349 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15452454 LIMIT 5 [ RunTime:0.017932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15452454 ORDER BY `minOrder` ASC [ RunTime:0.035032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15452454 ORDER BY `unit` DESC [ RunTime:0.014256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15452454 LIMIT 2 [ RunTime:0.012453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15452454 ORDER BY `minOrder` ASC [ RunTime:0.007263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12033187 LIMIT 5 [ RunTime:0.006300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12033187 ORDER BY `minOrder` ASC [ RunTime:0.028575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12033187 ORDER BY `unit` DESC [ RunTime:0.034197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12033187 LIMIT 2 [ RunTime:0.032591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12033187 ORDER BY `minOrder` ASC [ RunTime:0.035754s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055048s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53664128 LIMIT 5 [ RunTime:0.009880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53664128 ORDER BY `minOrder` ASC [ RunTime:0.009321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53664128 ORDER BY `unit` DESC [ RunTime:0.025112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53664128 LIMIT 2 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53664128 ORDER BY `minOrder` ASC [ RunTime:0.004206s ]
select * from pdf where partno='1858918' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009090s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858918' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.017427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53669115 LIMIT 5 [ RunTime:0.037007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53669115 ORDER BY `minOrder` ASC [ RunTime:0.019888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53669115 ORDER BY `unit` DESC [ RunTime:0.018467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53669115 LIMIT 2 [ RunTime:0.002989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53669115 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
select * from pdf where partno='1858989' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858989' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50998393 LIMIT 5 [ RunTime:0.020244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50998393 ORDER BY `minOrder` ASC [ RunTime:0.014926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50998393 ORDER BY `unit` DESC [ RunTime:0.004888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50998393 LIMIT 2 [ RunTime:0.032933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50998393 ORDER BY `minOrder` ASC [ RunTime:0.017960s ]
select * from pdf where partno='18589' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.010279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '18589' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.028592s ]
SELECT `id` FROM `stock` WHERE `id` <> 50998393 AND `partno` = '18589' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.028217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12408480 [ RunTime:0.002320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53733606 LIMIT 5 [ RunTime:0.036819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53733606 ORDER BY `minOrder` ASC [ RunTime:0.034483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53733606 ORDER BY `unit` DESC [ RunTime:0.030522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53733606 LIMIT 2 [ RunTime:0.017923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53733606 ORDER BY `minOrder` ASC [ RunTime:0.044453s ]
select * from pdf where partno='1858976' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.047356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858976' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53731276 LIMIT 5 [ RunTime:0.036361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731276 ORDER BY `minOrder` ASC [ RunTime:0.076667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53731276 ORDER BY `unit` DESC [ RunTime:0.025854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53731276 LIMIT 2 [ RunTime:0.016996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731276 ORDER BY `minOrder` ASC [ RunTime:0.027405s ]
select * from pdf where partno='1858947' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858947' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53730525 LIMIT 5 [ RunTime:0.013364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53730525 ORDER BY `minOrder` ASC [ RunTime:0.029901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53730525 ORDER BY `unit` DESC [ RunTime:0.029359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53730525 LIMIT 2 [ RunTime:0.007598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53730525 ORDER BY `minOrder` ASC [ RunTime:0.003532s ]
select * from pdf where partno='1858934' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858934' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53727363 LIMIT 5 [ RunTime:0.043239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727363 ORDER BY `minOrder` ASC [ RunTime:0.035021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53727363 ORDER BY `unit` DESC [ RunTime:0.027072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53727363 LIMIT 2 [ RunTime:0.025460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727363 ORDER BY `minOrder` ASC [ RunTime:0.020420s ]
select * from pdf where partno='1858921' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858921' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53721851 LIMIT 5 [ RunTime:0.034690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53721851 ORDER BY `minOrder` ASC [ RunTime:0.044241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53721851 ORDER BY `unit` DESC [ RunTime:0.056967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53721851 LIMIT 2 [ RunTime:0.017365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53721851 ORDER BY `minOrder` ASC [ RunTime:0.033923s ]
select * from pdf where partno='1858905' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858905' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.045930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53717338 LIMIT 5 [ RunTime:0.058711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53717338 ORDER BY `minOrder` ASC [ RunTime:0.061925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53717338 ORDER BY `unit` DESC [ RunTime:0.061755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53717338 LIMIT 2 [ RunTime:0.042158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53717338 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
select * from pdf where partno='1858960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.058236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.041099s ]
SELECT `id` FROM `stock` WHERE `id` <> 53717338 AND `partno` = '1858960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.119847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643691 [ RunTime:0.060063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713636 LIMIT 5 [ RunTime:0.052143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713636 ORDER BY `minOrder` ASC [ RunTime:0.031551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713636 ORDER BY `unit` DESC [ RunTime:0.049849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713636 LIMIT 2 [ RunTime:0.018310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713636 ORDER BY `minOrder` ASC [ RunTime:0.021662s ]
select * from pdf where partno='1858992' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.041864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858992' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52807363 LIMIT 5 [ RunTime:0.019450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52807363 ORDER BY `minOrder` ASC [ RunTime:0.033019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52807363 ORDER BY `unit` DESC [ RunTime:0.047096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52807363 LIMIT 2 [ RunTime:0.016421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52807363 ORDER BY `minOrder` ASC [ RunTime:0.013476s ]
select * from pdf where partno='185890-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185890-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009248s ]
SELECT `id` FROM `stock` WHERE `id` <> 52807363 AND `partno` = '185890-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.055461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19790653 [ RunTime:0.018767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52799914 LIMIT 5 [ RunTime:0.030210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52799914 ORDER BY `minOrder` ASC [ RunTime:0.029951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52799914 ORDER BY `unit` DESC [ RunTime:0.006184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52799914 LIMIT 2 [ RunTime:0.018809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52799914 ORDER BY `minOrder` ASC [ RunTime:0.005583s ]
select * from pdf where partno='185890-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185890-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001991s ]
SELECT `id` FROM `stock` WHERE `id` <> 52799914 AND `partno` = '185890-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12033187 [ RunTime:0.015538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49716432 LIMIT 5 [ RunTime:0.011603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49716432 ORDER BY `minOrder` ASC [ RunTime:0.045335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49716432 ORDER BY `unit` DESC [ RunTime:0.004491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49716432 LIMIT 2 [ RunTime:0.015538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49716432 ORDER BY `minOrder` ASC [ RunTime:0.002325s ]
select * from pdf where partno='1858970000' and brandshort='Weidmüller' limit 1 [ RunTime:0.020488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858970000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.032724s ]
SELECT `id` FROM `stock` WHERE `id` <> 49716432 AND `partno` = '1858970000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.035603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19658417 [ RunTime:0.050923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36909604 LIMIT 5 [ RunTime:0.024162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36909604 ORDER BY `minOrder` ASC [ RunTime:0.011529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36909604 ORDER BY `unit` DESC [ RunTime:0.006681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36909604 LIMIT 2 [ RunTime:0.019468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36909604 ORDER BY `minOrder` ASC [ RunTime:0.028157s ]
select * from pdf where partno='1858970000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1858970000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000547s ]
SELECT `id` FROM `stock` WHERE `id` <> 36909604 AND `partno` = '1858970000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.019264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19658417 [ RunTime:0.014376s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019158s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014652s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043443s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038636s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022743s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.176547s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024443s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18589%' OR `brand` LIKE '18589%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.067449s ]