SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002428s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029741s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274694 LIMIT 5 [ RunTime:0.022086s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274694 ORDER BY `minOrder` ASC [ RunTime:0.005655s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274694 ORDER BY `unit` DESC [ RunTime:0.011107s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274694 LIMIT 2 [ RunTime:0.016462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274694 ORDER BY `minOrder` ASC [ RunTime:0.017235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388696 LIMIT 5 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388696 ORDER BY `minOrder` ASC [ RunTime:0.002733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388696 ORDER BY `unit` DESC [ RunTime:0.010752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388696 LIMIT 2 [ RunTime:0.024623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388696 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348980 LIMIT 5 [ RunTime:0.015838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348980 ORDER BY `minOrder` ASC [ RunTime:0.027915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348980 ORDER BY `unit` DESC [ RunTime:0.022376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348980 LIMIT 2 [ RunTime:0.030504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348980 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563184 LIMIT 5 [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563184 ORDER BY `minOrder` ASC [ RunTime:0.009371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12563184 ORDER BY `unit` DESC [ RunTime:0.011174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12563184 LIMIT 2 [ RunTime:0.009549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563184 ORDER BY `minOrder` ASC [ RunTime:0.004943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561797 LIMIT 5 [ RunTime:0.006912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561797 ORDER BY `minOrder` ASC [ RunTime:0.004929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561797 ORDER BY `unit` DESC [ RunTime:0.000863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561797 LIMIT 2 [ RunTime:0.009729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561797 ORDER BY `minOrder` ASC [ RunTime:0.004781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561775 LIMIT 5 [ RunTime:0.001058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561775 ORDER BY `minOrder` ASC [ RunTime:0.003672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561775 ORDER BY `unit` DESC [ RunTime:0.027098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561775 LIMIT 2 [ RunTime:0.002777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561775 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561770 LIMIT 5 [ RunTime:0.008453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561770 ORDER BY `minOrder` ASC [ RunTime:0.002287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561770 ORDER BY `unit` DESC [ RunTime:0.000515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561770 LIMIT 2 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561770 ORDER BY `minOrder` ASC [ RunTime:0.003085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561769 LIMIT 5 [ RunTime:0.003228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561769 ORDER BY `minOrder` ASC [ RunTime:0.004179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561769 ORDER BY `unit` DESC [ RunTime:0.002519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561769 LIMIT 2 [ RunTime:0.004873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561769 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561766 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561766 ORDER BY `minOrder` ASC [ RunTime:0.011244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561766 ORDER BY `unit` DESC [ RunTime:0.003184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561766 LIMIT 2 [ RunTime:0.011766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561766 ORDER BY `minOrder` ASC [ RunTime:0.002974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446345 LIMIT 5 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446345 ORDER BY `minOrder` ASC [ RunTime:0.005895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446345 ORDER BY `unit` DESC [ RunTime:0.003185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446345 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446345 ORDER BY `minOrder` ASC [ RunTime:0.004820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446329 LIMIT 5 [ RunTime:0.001372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446329 ORDER BY `minOrder` ASC [ RunTime:0.004665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446329 ORDER BY `unit` DESC [ RunTime:0.001429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446329 LIMIT 2 [ RunTime:0.007333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446329 ORDER BY `minOrder` ASC [ RunTime:0.008806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446327 LIMIT 5 [ RunTime:0.007956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446327 ORDER BY `minOrder` ASC [ RunTime:0.030739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446327 ORDER BY `unit` DESC [ RunTime:0.023987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446327 LIMIT 2 [ RunTime:0.015918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446327 ORDER BY `minOrder` ASC [ RunTime:0.001309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446326 LIMIT 5 [ RunTime:0.001785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446326 ORDER BY `minOrder` ASC [ RunTime:0.004697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446326 ORDER BY `unit` DESC [ RunTime:0.006994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446326 LIMIT 2 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446326 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446324 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446324 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446324 ORDER BY `unit` DESC [ RunTime:0.003222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446324 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446324 ORDER BY `minOrder` ASC [ RunTime:0.004139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561799 LIMIT 5 [ RunTime:0.002889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561799 ORDER BY `minOrder` ASC [ RunTime:0.006821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561799 ORDER BY `unit` DESC [ RunTime:0.000552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561799 LIMIT 2 [ RunTime:0.011265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561799 ORDER BY `minOrder` ASC [ RunTime:0.005383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561798 LIMIT 5 [ RunTime:0.002100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561798 ORDER BY `minOrder` ASC [ RunTime:0.004666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561798 ORDER BY `unit` DESC [ RunTime:0.008766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561798 LIMIT 2 [ RunTime:0.005039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561798 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19663868 LIMIT 5 [ RunTime:0.014910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663868 ORDER BY `minOrder` ASC [ RunTime:0.006965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19663868 ORDER BY `unit` DESC [ RunTime:0.005070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19663868 LIMIT 2 [ RunTime:0.005419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663868 ORDER BY `minOrder` ASC [ RunTime:0.004124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19663341 LIMIT 5 [ RunTime:0.004846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663341 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19663341 ORDER BY `unit` DESC [ RunTime:0.008290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19663341 LIMIT 2 [ RunTime:0.008795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663341 ORDER BY `minOrder` ASC [ RunTime:0.002474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19663340 LIMIT 5 [ RunTime:0.004436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663340 ORDER BY `minOrder` ASC [ RunTime:0.012061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19663340 ORDER BY `unit` DESC [ RunTime:0.007342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19663340 LIMIT 2 [ RunTime:0.007574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663340 ORDER BY `minOrder` ASC [ RunTime:0.010067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19663295 LIMIT 5 [ RunTime:0.004200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663295 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19663295 ORDER BY `unit` DESC [ RunTime:0.005845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19663295 LIMIT 2 [ RunTime:0.021568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663295 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001835s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104585 LIMIT 5 [ RunTime:0.009737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104585 ORDER BY `minOrder` ASC [ RunTime:0.004000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104585 ORDER BY `unit` DESC [ RunTime:0.002193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104585 LIMIT 2 [ RunTime:0.002103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104585 ORDER BY `minOrder` ASC [ RunTime:0.004374s ]
select * from pdf where partno='2898' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004113s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.005805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104643 LIMIT 5 [ RunTime:0.006501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104643 ORDER BY `minOrder` ASC [ RunTime:0.002867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104643 ORDER BY `unit` DESC [ RunTime:0.002764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104643 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104643 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='2898TR' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898TR' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001909s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104643 AND `partno` = '2898TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.004008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388696 [ RunTime:0.000646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469254 LIMIT 5 [ RunTime:0.005082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469254 ORDER BY `minOrder` ASC [ RunTime:0.002593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469254 ORDER BY `unit` DESC [ RunTime:0.002102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469254 LIMIT 2 [ RunTime:0.011135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469254 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
select * from pdf where partno='2898790000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898790000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003806s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469254 AND `partno` = '2898790000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561798 [ RunTime:0.005830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469255 LIMIT 5 [ RunTime:0.001067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469255 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469255 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469255 LIMIT 2 [ RunTime:0.002951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469255 ORDER BY `minOrder` ASC [ RunTime:0.007706s ]
select * from pdf where partno='2898810000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898810000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002170s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469255 AND `partno` = '2898810000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561799 [ RunTime:0.011710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469239 LIMIT 5 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469239 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469239 ORDER BY `unit` DESC [ RunTime:0.013822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469239 LIMIT 2 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469239 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='2898780000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898780000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002403s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469239 AND `partno` = '2898780000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563184 [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469227 LIMIT 5 [ RunTime:0.001919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469227 ORDER BY `minOrder` ASC [ RunTime:0.006246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469227 ORDER BY `unit` DESC [ RunTime:0.005862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469227 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469227 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='2898730000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898730000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006082s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469227 AND `partno` = '2898730000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446329 [ RunTime:0.006557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469225 LIMIT 5 [ RunTime:0.008642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469225 ORDER BY `minOrder` ASC [ RunTime:0.010067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469225 ORDER BY `unit` DESC [ RunTime:0.000993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469225 LIMIT 2 [ RunTime:0.010901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469225 ORDER BY `minOrder` ASC [ RunTime:0.006846s ]
select * from pdf where partno='2898740000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898740000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006268s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469225 AND `partno` = '2898740000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469224 LIMIT 5 [ RunTime:0.009589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469224 ORDER BY `minOrder` ASC [ RunTime:0.016657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469224 ORDER BY `unit` DESC [ RunTime:0.018605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469224 LIMIT 2 [ RunTime:0.031263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469224 ORDER BY `minOrder` ASC [ RunTime:0.014296s ]
select * from pdf where partno='2898750000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898750000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013942s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469224 AND `partno` = '2898750000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469221 LIMIT 5 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469221 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469221 ORDER BY `unit` DESC [ RunTime:0.005991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469221 LIMIT 2 [ RunTime:0.003371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469221 ORDER BY `minOrder` ASC [ RunTime:0.006366s ]
select * from pdf where partno='2898770000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898770000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007281s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469221 AND `partno` = '2898770000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446326 [ RunTime:0.008140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469218 LIMIT 5 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469218 ORDER BY `minOrder` ASC [ RunTime:0.006533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469218 ORDER BY `unit` DESC [ RunTime:0.008461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469218 LIMIT 2 [ RunTime:0.008570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469218 ORDER BY `minOrder` ASC [ RunTime:0.010561s ]
select * from pdf where partno='2898710000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898710000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001562s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469218 AND `partno` = '2898710000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446324 [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469217 LIMIT 5 [ RunTime:0.003213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469217 ORDER BY `minOrder` ASC [ RunTime:0.000910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469217 ORDER BY `unit` DESC [ RunTime:0.000560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469217 LIMIT 2 [ RunTime:0.002949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469217 ORDER BY `minOrder` ASC [ RunTime:0.006531s ]
select * from pdf where partno='2898700000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898700000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001526s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469217 AND `partno` = '2898700000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561775 [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469209 LIMIT 5 [ RunTime:0.005650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469209 ORDER BY `minOrder` ASC [ RunTime:0.001007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469209 ORDER BY `unit` DESC [ RunTime:0.003948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469209 LIMIT 2 [ RunTime:0.005616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469209 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='2898670000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898670000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001478s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469209 AND `partno` = '2898670000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561770 [ RunTime:0.005191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469228 LIMIT 5 [ RunTime:0.002917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469228 ORDER BY `minOrder` ASC [ RunTime:0.012284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469228 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469228 LIMIT 2 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469228 ORDER BY `minOrder` ASC [ RunTime:0.001118s ]
select * from pdf where partno='2898720000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898720000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009328s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469228 AND `partno` = '2898720000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469202 LIMIT 5 [ RunTime:0.007272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469202 ORDER BY `minOrder` ASC [ RunTime:0.004987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469202 ORDER BY `unit` DESC [ RunTime:0.002862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469202 LIMIT 2 [ RunTime:0.019556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469202 ORDER BY `minOrder` ASC [ RunTime:0.004012s ]
select * from pdf where partno='2898680000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898680000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.025769s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469202 AND `partno` = '2898680000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561766 [ RunTime:0.020734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469252 LIMIT 5 [ RunTime:0.029079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469252 ORDER BY `minOrder` ASC [ RunTime:0.019321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469252 ORDER BY `unit` DESC [ RunTime:0.011322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469252 LIMIT 2 [ RunTime:0.016609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469252 ORDER BY `minOrder` ASC [ RunTime:0.011079s ]
select * from pdf where partno='2898820000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898820000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014073s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469252 AND `partno` = '2898820000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446345 [ RunTime:0.015629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469253 LIMIT 5 [ RunTime:0.003813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469253 ORDER BY `minOrder` ASC [ RunTime:0.010345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469253 ORDER BY `unit` DESC [ RunTime:0.015397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469253 LIMIT 2 [ RunTime:0.013226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469253 ORDER BY `minOrder` ASC [ RunTime:0.007319s ]
select * from pdf where partno='2898800000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898800000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006907s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469253 AND `partno` = '2898800000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.022631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561797 [ RunTime:0.032732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469210 LIMIT 5 [ RunTime:0.018921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469210 ORDER BY `minOrder` ASC [ RunTime:0.025513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469210 ORDER BY `unit` DESC [ RunTime:0.010724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469210 LIMIT 2 [ RunTime:0.038308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469210 ORDER BY `minOrder` ASC [ RunTime:0.004856s ]
select * from pdf where partno='2898660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.027543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.050604s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469210 AND `partno` = '2898660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.056467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561769 [ RunTime:0.012768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469203 LIMIT 5 [ RunTime:0.008929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469203 ORDER BY `minOrder` ASC [ RunTime:0.029037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469203 ORDER BY `unit` DESC [ RunTime:0.016803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469203 LIMIT 2 [ RunTime:0.012790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469203 ORDER BY `minOrder` ASC [ RunTime:0.009094s ]
select * from pdf where partno='2898690000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898690000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031298s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469203 AND `partno` = '2898690000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.017119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469222 LIMIT 5 [ RunTime:0.031331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469222 ORDER BY `minOrder` ASC [ RunTime:0.051097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469222 ORDER BY `unit` DESC [ RunTime:0.006820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469222 LIMIT 2 [ RunTime:0.022857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469222 ORDER BY `minOrder` ASC [ RunTime:0.004900s ]
select * from pdf where partno='2898760000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898760000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.027970s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469222 AND `partno` = '2898760000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446327 [ RunTime:0.012663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386373 LIMIT 5 [ RunTime:0.005208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386373 ORDER BY `minOrder` ASC [ RunTime:0.014948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386373 ORDER BY `unit` DESC [ RunTime:0.012849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386373 LIMIT 2 [ RunTime:0.005527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386373 ORDER BY `minOrder` ASC [ RunTime:0.018415s ]
select * from pdf where partno='2898880000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2898880000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.020228s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386373 AND `partno` = '2898880000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013510s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015429s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015163s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009181s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014923s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014837s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006241s ]
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 '2898%' OR `brand` LIKE '2898%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017584s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2898%' OR `brand` LIKE '2898%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016355s ]