SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002179s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025007s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123479 LIMIT 5 [ RunTime:0.018890s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123479 ORDER BY `minOrder` ASC [ RunTime:0.016946s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20123479 ORDER BY `unit` DESC [ RunTime:0.017809s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20123479 LIMIT 2 [ RunTime:0.014323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123479 ORDER BY `minOrder` ASC [ RunTime:0.006323s ]
select * from pdf where partno='19440030801' and brandshort='HARTING' limit 1 [ RunTime:0.020091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606420 LIMIT 5 [ RunTime:0.015655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606420 ORDER BY `minOrder` ASC [ RunTime:0.019314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606420 ORDER BY `unit` DESC [ RunTime:0.014116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606420 LIMIT 2 [ RunTime:0.005666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606420 ORDER BY `minOrder` ASC [ RunTime:0.022106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651795 LIMIT 5 [ RunTime:0.018007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651795 ORDER BY `minOrder` ASC [ RunTime:0.021356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651795 ORDER BY `unit` DESC [ RunTime:0.042080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651795 LIMIT 2 [ RunTime:0.015596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651795 ORDER BY `minOrder` ASC [ RunTime:0.020362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13103625 LIMIT 5 [ RunTime:0.034387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13103625 ORDER BY `minOrder` ASC [ RunTime:0.041156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13103625 ORDER BY `unit` DESC [ RunTime:0.023640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13103625 LIMIT 2 [ RunTime:0.001962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13103625 ORDER BY `minOrder` ASC [ RunTime:0.026978s ]
select * from pdf where partno='19440035425' and brandshort='HARTING' limit 1 [ RunTime:0.045538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16380652 LIMIT 5 [ RunTime:0.071891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16380652 ORDER BY `minOrder` ASC [ RunTime:0.046852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16380652 ORDER BY `unit` DESC [ RunTime:0.050080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16380652 LIMIT 2 [ RunTime:0.021256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16380652 ORDER BY `minOrder` ASC [ RunTime:0.016063s ]
select * from pdf where partno='19440030306' and brandshort='HARTING' limit 1 [ RunTime:0.013878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104558 LIMIT 5 [ RunTime:0.056645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104558 ORDER BY `minOrder` ASC [ RunTime:0.056436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104558 ORDER BY `unit` DESC [ RunTime:0.003974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104558 LIMIT 2 [ RunTime:0.008529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104558 ORDER BY `minOrder` ASC [ RunTime:0.027794s ]
select * from pdf where partno='19440035426' and brandshort='HARTING' limit 1 [ RunTime:0.027749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13106886 LIMIT 5 [ RunTime:0.026616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13106886 ORDER BY `minOrder` ASC [ RunTime:0.032978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13106886 ORDER BY `unit` DESC [ RunTime:0.042351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13106886 LIMIT 2 [ RunTime:0.040775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13106886 ORDER BY `minOrder` ASC [ RunTime:0.018008s ]
select * from pdf where partno='19440031150' and brandshort='HARTING' limit 1 [ RunTime:0.004559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417910 LIMIT 5 [ RunTime:0.035855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417910 ORDER BY `minOrder` ASC [ RunTime:0.034740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417910 ORDER BY `unit` DESC [ RunTime:0.040150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417910 LIMIT 2 [ RunTime:0.011893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417910 ORDER BY `minOrder` ASC [ RunTime:0.020352s ]
select * from pdf where partno='19440005083' and brandshort='HARTING' limit 1 [ RunTime:0.042701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414675 LIMIT 5 [ RunTime:0.023888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414675 ORDER BY `minOrder` ASC [ RunTime:0.012603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414675 ORDER BY `unit` DESC [ RunTime:0.014203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414675 LIMIT 2 [ RunTime:0.037554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414675 ORDER BY `minOrder` ASC [ RunTime:0.042386s ]
select * from pdf where partno='19440005082' and brandshort='HARTING' limit 1 [ RunTime:0.022937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107342 LIMIT 5 [ RunTime:0.026220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107342 ORDER BY `minOrder` ASC [ RunTime:0.017287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107342 ORDER BY `unit` DESC [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107342 LIMIT 2 [ RunTime:0.007309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107342 ORDER BY `minOrder` ASC [ RunTime:0.008973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13106306 LIMIT 5 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13106306 ORDER BY `minOrder` ASC [ RunTime:0.033725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13106306 ORDER BY `unit` DESC [ RunTime:0.049418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13106306 LIMIT 2 [ RunTime:0.091147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13106306 ORDER BY `minOrder` ASC [ RunTime:0.021142s ]
select * from pdf where partno='19440031443' and brandshort='HARTING' limit 1 [ RunTime:0.047921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107676 LIMIT 5 [ RunTime:0.034219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107676 ORDER BY `minOrder` ASC [ RunTime:0.020014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107676 ORDER BY `unit` DESC [ RunTime:0.049562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107676 LIMIT 2 [ RunTime:0.081359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107676 ORDER BY `minOrder` ASC [ RunTime:0.031714s ]
select * from pdf where partno='19440031643' and brandshort='HARTING' limit 1 [ RunTime:0.008110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107796 LIMIT 5 [ RunTime:0.099189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107796 ORDER BY `minOrder` ASC [ RunTime:0.010685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107796 ORDER BY `unit` DESC [ RunTime:0.058459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107796 LIMIT 2 [ RunTime:0.050578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107796 ORDER BY `minOrder` ASC [ RunTime:0.044230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107795 LIMIT 5 [ RunTime:0.105209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107795 ORDER BY `minOrder` ASC [ RunTime:0.047577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107795 ORDER BY `unit` DESC [ RunTime:0.043698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107795 LIMIT 2 [ RunTime:0.059224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107795 ORDER BY `minOrder` ASC [ RunTime:0.046473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107350 LIMIT 5 [ RunTime:0.025037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107350 ORDER BY `minOrder` ASC [ RunTime:0.036115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107350 ORDER BY `unit` DESC [ RunTime:0.071557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107350 LIMIT 2 [ RunTime:0.037044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107350 ORDER BY `minOrder` ASC [ RunTime:0.006914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104569 LIMIT 5 [ RunTime:0.022902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104569 ORDER BY `minOrder` ASC [ RunTime:0.036910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104569 ORDER BY `unit` DESC [ RunTime:0.071463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104569 LIMIT 2 [ RunTime:0.062450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104569 ORDER BY `minOrder` ASC [ RunTime:0.005387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11853978 LIMIT 5 [ RunTime:0.024457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11853978 ORDER BY `minOrder` ASC [ RunTime:0.028915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11853978 ORDER BY `unit` DESC [ RunTime:0.049526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11853978 LIMIT 2 [ RunTime:0.013073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11853978 ORDER BY `minOrder` ASC [ RunTime:0.001104s ]
select * from pdf where partno='19440031640' and brandshort='HARTING' limit 1 [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107793 LIMIT 5 [ RunTime:0.011513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107793 ORDER BY `minOrder` ASC [ RunTime:0.035770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107793 ORDER BY `unit` DESC [ RunTime:0.024456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107793 LIMIT 2 [ RunTime:0.030663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107793 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104676 LIMIT 5 [ RunTime:0.016219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104676 ORDER BY `minOrder` ASC [ RunTime:0.036669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13104676 ORDER BY `unit` DESC [ RunTime:0.042670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13104676 LIMIT 2 [ RunTime:0.042019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13104676 ORDER BY `minOrder` ASC [ RunTime:0.001643s ]
select * from pdf where partno='19440009902' and brandshort='HARTING' limit 1 [ RunTime:0.014153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13103797 LIMIT 5 [ RunTime:0.007840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13103797 ORDER BY `minOrder` ASC [ RunTime:0.006624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13103797 ORDER BY `unit` DESC [ RunTime:0.009247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13103797 LIMIT 2 [ RunTime:0.007846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13103797 ORDER BY `minOrder` ASC [ RunTime:0.004639s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32178776 LIMIT 5 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32178776 ORDER BY `minOrder` ASC [ RunTime:0.031391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32178776 ORDER BY `unit` DESC [ RunTime:0.010597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32178776 LIMIT 2 [ RunTime:0.017720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32178776 ORDER BY `minOrder` ASC [ RunTime:0.044510s ]
select * from pdf where partno='19440030306' and brandshort='harting' limit 1 [ RunTime:0.041168s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440030306' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.099339s ]
SELECT `id` FROM `stock` WHERE `id` <> 32178776 AND `partno` = '19440030306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.048912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16380652 [ RunTime:0.030632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263264 LIMIT 5 [ RunTime:0.078753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263264 ORDER BY `minOrder` ASC [ RunTime:0.093321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263264 ORDER BY `unit` DESC [ RunTime:0.018099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263264 LIMIT 2 [ RunTime:0.064323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263264 ORDER BY `minOrder` ASC [ RunTime:0.023694s ]
select * from pdf where partno='19440030306' and brandshort='harting' limit 1 [ RunTime:0.011669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440030306' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.028853s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263264 AND `partno` = '19440030306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.056148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16380652 [ RunTime:0.013601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32262992 LIMIT 5 [ RunTime:0.003132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32262992 ORDER BY `minOrder` ASC [ RunTime:0.036739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32262992 ORDER BY `unit` DESC [ RunTime:0.022012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32262992 LIMIT 2 [ RunTime:0.110326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32262992 ORDER BY `minOrder` ASC [ RunTime:0.032963s ]
select * from pdf where partno='19440005085' and brandshort='harting' limit 1 [ RunTime:0.039469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440005085' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.030516s ]
SELECT `id` FROM `stock` WHERE `id` <> 32262992 AND `partno` = '19440005085' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.074576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428760 [ RunTime:0.034706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32178443 LIMIT 5 [ RunTime:0.096833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32178443 ORDER BY `minOrder` ASC [ RunTime:0.032336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32178443 ORDER BY `unit` DESC [ RunTime:0.018687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32178443 LIMIT 2 [ RunTime:0.011757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32178443 ORDER BY `minOrder` ASC [ RunTime:0.010530s ]
select * from pdf where partno='19440005085' and brandshort='harting' limit 1 [ RunTime:0.013464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440005085' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.020168s ]
SELECT `id` FROM `stock` WHERE `id` <> 32178443 AND `partno` = '19440005085' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.070645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428760 [ RunTime:0.060178s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60485463 LIMIT 5 [ RunTime:0.021888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60485463 ORDER BY `minOrder` ASC [ RunTime:0.018879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60485463 ORDER BY `unit` DESC [ RunTime:0.006467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60485463 LIMIT 2 [ RunTime:0.007335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60485463 ORDER BY `minOrder` ASC [ RunTime:0.004740s ]
select * from pdf where partno='1944090000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1944090000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.028216s ]
SELECT `id` FROM `stock` WHERE `id` <> 60485463 AND `partno` = '1944090000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651795 [ RunTime:0.001284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60398888 LIMIT 5 [ RunTime:0.007835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60398888 ORDER BY `minOrder` ASC [ RunTime:0.003366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60398888 ORDER BY `unit` DESC [ RunTime:0.006175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60398888 LIMIT 2 [ RunTime:0.017826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60398888 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
select * from pdf where partno='19440030801' and brandshort='HARTING' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440030801' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005785s ]
SELECT `id` FROM `stock` WHERE `id` <> 60398888 AND `partno` = '19440030801' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.016341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123479 [ RunTime:0.028968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60399986 LIMIT 5 [ RunTime:0.014127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399986 ORDER BY `minOrder` ASC [ RunTime:0.006982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60399986 ORDER BY `unit` DESC [ RunTime:0.018906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60399986 LIMIT 2 [ RunTime:0.007081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399986 ORDER BY `minOrder` ASC [ RunTime:0.016125s ]
select * from pdf where partno='19440031150' and brandshort='HARTING' limit 1 [ RunTime:0.000619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440031150' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001542s ]
SELECT `id` FROM `stock` WHERE `id` <> 60399986 AND `partno` = '19440031150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13106886 [ RunTime:0.001684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63137310 LIMIT 5 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137310 ORDER BY `minOrder` ASC [ RunTime:0.009846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63137310 ORDER BY `unit` DESC [ RunTime:0.002836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63137310 LIMIT 2 [ RunTime:0.003908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137310 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='19440005082' and brandshort='HARTING' limit 1 [ RunTime:0.006858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440005082' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007122s ]
SELECT `id` FROM `stock` WHERE `id` <> 63137310 AND `partno` = '19440005082' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414675 [ RunTime:0.009580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60399411 LIMIT 5 [ RunTime:0.005711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399411 ORDER BY `minOrder` ASC [ RunTime:0.001705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60399411 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60399411 LIMIT 2 [ RunTime:0.002918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399411 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
select * from pdf where partno='19440031440' and brandshort='HARTING' limit 1 [ RunTime:0.003959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440031440' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004205s ]
SELECT `id` FROM `stock` WHERE `id` <> 60399411 AND `partno` = '19440031440' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13106899 [ RunTime:0.001580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63137659 LIMIT 5 [ RunTime:0.010857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137659 ORDER BY `minOrder` ASC [ RunTime:0.009346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63137659 ORDER BY `unit` DESC [ RunTime:0.015648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63137659 LIMIT 2 [ RunTime:0.019143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137659 ORDER BY `minOrder` ASC [ RunTime:0.007775s ]
select * from pdf where partno='19440005083' and brandshort='HARTING' limit 1 [ RunTime:0.001653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440005083' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001752s ]
SELECT `id` FROM `stock` WHERE `id` <> 63137659 AND `partno` = '19440005083' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.026631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417910 [ RunTime:0.014222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60388092 LIMIT 5 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388092 ORDER BY `minOrder` ASC [ RunTime:0.006044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60388092 ORDER BY `unit` DESC [ RunTime:0.005992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60388092 LIMIT 2 [ RunTime:0.006839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388092 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='19440035426' and brandshort='HARTING' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440035426' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003604s ]
SELECT `id` FROM `stock` WHERE `id` <> 60388092 AND `partno` = '19440035426' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.003136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104558 [ RunTime:0.004017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60399962 LIMIT 5 [ RunTime:0.004039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399962 ORDER BY `minOrder` ASC [ RunTime:0.011317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60399962 ORDER BY `unit` DESC [ RunTime:0.000844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60399962 LIMIT 2 [ RunTime:0.005342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399962 ORDER BY `minOrder` ASC [ RunTime:0.005307s ]
select * from pdf where partno='19440031250' and brandshort='HARTING' limit 1 [ RunTime:0.006144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440031250' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007507s ]
SELECT `id` FROM `stock` WHERE `id` <> 60399962 AND `partno` = '19440031250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.015171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13108067 [ RunTime:0.012989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60388450 LIMIT 5 [ RunTime:0.001095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388450 ORDER BY `minOrder` ASC [ RunTime:0.015429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60388450 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60388450 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388450 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='19440009902' and brandshort='HARTING' limit 1 [ RunTime:0.000713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440009902' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002016s ]
SELECT `id` FROM `stock` WHERE `id` <> 60388450 AND `partno` = '19440009902' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.023694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13104676 [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400088 LIMIT 5 [ RunTime:0.001581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400088 ORDER BY `minOrder` ASC [ RunTime:0.039202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400088 ORDER BY `unit` DESC [ RunTime:0.018892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400088 LIMIT 2 [ RunTime:0.013973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400088 ORDER BY `minOrder` ASC [ RunTime:0.009294s ]
select * from pdf where partno='19440060301' and brandshort='HARTING' limit 1 [ RunTime:0.007961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440060301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005367s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400088 AND `partno` = '19440060301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400107 LIMIT 5 [ RunTime:0.013621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400107 ORDER BY `minOrder` ASC [ RunTime:0.027153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400107 ORDER BY `unit` DESC [ RunTime:0.007680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400107 LIMIT 2 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400107 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='19440240427' and brandshort='HARTING' limit 1 [ RunTime:0.004409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440240427' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010188s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400107 AND `partno` = '19440240427' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60387892 LIMIT 5 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60387892 ORDER BY `minOrder` ASC [ RunTime:0.003930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60387892 ORDER BY `unit` DESC [ RunTime:0.002430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60387892 LIMIT 2 [ RunTime:0.019383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60387892 ORDER BY `minOrder` ASC [ RunTime:0.002905s ]
select * from pdf where partno='19440035425' and brandshort='HARTING' limit 1 [ RunTime:0.011979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440035425' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.023669s ]
SELECT `id` FROM `stock` WHERE `id` <> 60387892 AND `partno` = '19440035425' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.028900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13103625 [ RunTime:0.005266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400097 LIMIT 5 [ RunTime:0.016667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400097 ORDER BY `minOrder` ASC [ RunTime:0.007064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400097 ORDER BY `unit` DESC [ RunTime:0.001231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400097 LIMIT 2 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400097 ORDER BY `minOrder` ASC [ RunTime:0.007016s ]
select * from pdf where partno='19440240301' and brandshort='HARTING' limit 1 [ RunTime:0.015366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440240301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005717s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400097 AND `partno` = '19440240301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107342 [ RunTime:0.004190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60388130 LIMIT 5 [ RunTime:0.002216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388130 ORDER BY `minOrder` ASC [ RunTime:0.002722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60388130 ORDER BY `unit` DESC [ RunTime:0.002156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60388130 LIMIT 2 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60388130 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='19440245402' and brandshort='HARTING' limit 1 [ RunTime:0.005674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440245402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003162s ]
SELECT `id` FROM `stock` WHERE `id` <> 60388130 AND `partno` = '19440245402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13103676 [ RunTime:0.001873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400105 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400105 ORDER BY `minOrder` ASC [ RunTime:0.005162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400105 ORDER BY `unit` DESC [ RunTime:0.003526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400105 LIMIT 2 [ RunTime:0.023114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400105 ORDER BY `minOrder` ASC [ RunTime:0.016463s ]
select * from pdf where partno='19440160527' and brandshort='HARTING' limit 1 [ RunTime:0.017162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440160527' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.013236s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400105 AND `partno` = '19440160527' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11855271 [ RunTime:0.016921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400095 LIMIT 5 [ RunTime:0.010763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400095 ORDER BY `minOrder` ASC [ RunTime:0.022640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400095 ORDER BY `unit` DESC [ RunTime:0.021941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400095 LIMIT 2 [ RunTime:0.010817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400095 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='19440160301' and brandshort='HARTING' limit 1 [ RunTime:0.004724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440160301' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.007459s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400095 AND `partno` = '19440160301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.012372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11855268 [ RunTime:0.001146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400046 LIMIT 5 [ RunTime:0.005033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400046 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400046 ORDER BY `unit` DESC [ RunTime:0.003662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400046 LIMIT 2 [ RunTime:0.009908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400046 ORDER BY `minOrder` ASC [ RunTime:0.009154s ]
select * from pdf where partno='19440031640' and brandshort='HARTING' limit 1 [ RunTime:0.004176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440031640' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017087s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400046 AND `partno` = '19440031640' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.003002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11853978 [ RunTime:0.005233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60399412 LIMIT 5 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399412 ORDER BY `minOrder` ASC [ RunTime:0.003354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60399412 ORDER BY `unit` DESC [ RunTime:0.004172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60399412 LIMIT 2 [ RunTime:0.003309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60399412 ORDER BY `minOrder` ASC [ RunTime:0.002670s ]
select * from pdf where partno='19440030306' and brandshort='HARTING' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440030306' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001826s ]
SELECT `id` FROM `stock` WHERE `id` <> 60399412 AND `partno` = '19440030306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16380652 [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63137662 LIMIT 5 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137662 ORDER BY `minOrder` ASC [ RunTime:0.009504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63137662 ORDER BY `unit` DESC [ RunTime:0.009300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63137662 LIMIT 2 [ RunTime:0.002087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137662 ORDER BY `minOrder` ASC [ RunTime:0.006288s ]
select * from pdf where partno='19440005084' and brandshort='HARTING' limit 1 [ RunTime:0.001275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440005084' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006055s ]
SELECT `id` FROM `stock` WHERE `id` <> 63137662 AND `partno` = '19440005084' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.011640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400461 LIMIT 5 [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400461 ORDER BY `minOrder` ASC [ RunTime:0.005056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400461 ORDER BY `unit` DESC [ RunTime:0.002114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400461 LIMIT 2 [ RunTime:0.001267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400461 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='19440240527' and brandshort='HARTING' limit 1 [ RunTime:0.001383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19440240527' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015841s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400461 AND `partno` = '19440240527' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.021825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107350 [ RunTime:0.008606s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001240s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001166s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003917s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000674s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013680s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010946s ]
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 '19440%' OR `brand` LIKE '19440%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008224s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19440%' OR `brand` LIKE '19440%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005922s ]