SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003451s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010576s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13669859 LIMIT 5 [ RunTime:0.014689s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13669859 ORDER BY `minOrder` ASC [ RunTime:0.020792s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13669859 ORDER BY `unit` DESC [ RunTime:0.044431s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13669859 LIMIT 2 [ RunTime:0.031700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13669859 ORDER BY `minOrder` ASC [ RunTime:0.034750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556802 LIMIT 5 [ RunTime:0.031084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556802 ORDER BY `minOrder` ASC [ RunTime:0.079920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556802 ORDER BY `unit` DESC [ RunTime:0.050337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556802 LIMIT 2 [ RunTime:0.041025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556802 ORDER BY `minOrder` ASC [ RunTime:0.062592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13215058 LIMIT 5 [ RunTime:0.014996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13215058 ORDER BY `minOrder` ASC [ RunTime:0.022386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13215058 ORDER BY `unit` DESC [ RunTime:0.014087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13215058 LIMIT 2 [ RunTime:0.003401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13215058 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18900689 LIMIT 5 [ RunTime:0.005447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18900689 ORDER BY `minOrder` ASC [ RunTime:0.011539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18900689 ORDER BY `unit` DESC [ RunTime:0.014066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18900689 LIMIT 2 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18900689 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11948317 LIMIT 5 [ RunTime:0.001116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11948317 ORDER BY `minOrder` ASC [ RunTime:0.015344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11948317 ORDER BY `unit` DESC [ RunTime:0.002509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11948317 LIMIT 2 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11948317 ORDER BY `minOrder` ASC [ RunTime:0.001247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18903122 LIMIT 5 [ RunTime:0.001489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903122 ORDER BY `minOrder` ASC [ RunTime:0.004246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18903122 ORDER BY `unit` DESC [ RunTime:0.003658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18903122 LIMIT 2 [ RunTime:0.001638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903122 ORDER BY `minOrder` ASC [ RunTime:0.001209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13215080 LIMIT 5 [ RunTime:0.002876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13215080 ORDER BY `minOrder` ASC [ RunTime:0.005496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13215080 ORDER BY `unit` DESC [ RunTime:0.000793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13215080 LIMIT 2 [ RunTime:0.001973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13215080 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512281 LIMIT 5 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512281 ORDER BY `minOrder` ASC [ RunTime:0.000842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512281 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512281 LIMIT 2 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512281 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12238019 LIMIT 5 [ RunTime:0.001530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12238019 ORDER BY `minOrder` ASC [ RunTime:0.000739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12238019 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12238019 LIMIT 2 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12238019 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18903771 LIMIT 5 [ RunTime:0.001143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903771 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18903771 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18903771 LIMIT 2 [ RunTime:0.000975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903771 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12238032 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12238032 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12238032 ORDER BY `unit` DESC [ RunTime:0.009413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12238032 LIMIT 2 [ RunTime:0.001380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12238032 ORDER BY `minOrder` ASC [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654408 LIMIT 5 [ RunTime:0.002267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654408 ORDER BY `minOrder` ASC [ RunTime:0.001394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19654408 ORDER BY `unit` DESC [ RunTime:0.000824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19654408 LIMIT 2 [ RunTime:0.004028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654408 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652621 LIMIT 5 [ RunTime:0.001402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652621 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652621 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652621 LIMIT 2 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652621 ORDER BY `minOrder` ASC [ RunTime:0.002472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639909 LIMIT 5 [ RunTime:0.001526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639909 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19639909 ORDER BY `unit` DESC [ RunTime:0.000847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19639909 LIMIT 2 [ RunTime:0.002836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639909 ORDER BY `minOrder` ASC [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274451 LIMIT 5 [ RunTime:0.001297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274451 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19274451 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19274451 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274451 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309106 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309106 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17309106 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17309106 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309106 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17303616 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17303616 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17303616 ORDER BY `unit` DESC [ RunTime:0.008354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17303616 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17303616 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17146189 LIMIT 5 [ RunTime:0.001861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17146189 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17146189 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17146189 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17146189 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149234 LIMIT 5 [ RunTime:0.001357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149234 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149234 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149234 LIMIT 2 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149234 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401013 LIMIT 5 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401013 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401013 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401013 LIMIT 2 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401013 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276346 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276346 ORDER BY `minOrder` ASC [ RunTime:0.001200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276346 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276346 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276346 ORDER BY `minOrder` ASC [ RunTime:0.002518s ]
select * from pdf where partno='1872210' and brandshort='phoenix contact' limit 1 [ RunTime:0.001316s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872210' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002656s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63496274 LIMIT 5 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63496274 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63496274 ORDER BY `unit` DESC [ RunTime:0.003220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63496274 LIMIT 2 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63496274 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='187252-01' and brandshort='NI' limit 1 [ RunTime:0.001069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '187252-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.003539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60563325 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60563325 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60563325 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60563325 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60563325 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
select * from pdf where partno='1872392' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872392' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62427444 LIMIT 5 [ RunTime:0.002142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62427444 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62427444 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62427444 LIMIT 2 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62427444 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
select * from pdf where partno='1872' and brandshort='Pololu' limit 1 [ RunTime:0.000951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.001936s ]
SELECT `id` FROM `stock` WHERE `id` <> 62427444 AND `partno` = '1872' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13669859 [ RunTime:0.003249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63496494 LIMIT 5 [ RunTime:0.007346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63496494 ORDER BY `minOrder` ASC [ RunTime:0.003055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63496494 ORDER BY `unit` DESC [ RunTime:0.003515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63496494 LIMIT 2 [ RunTime:0.007484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63496494 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
select * from pdf where partno='187252-0R5' and brandshort='NI' limit 1 [ RunTime:0.003026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '187252-0R5' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.003494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386465 LIMIT 5 [ RunTime:0.001145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386465 ORDER BY `minOrder` ASC [ RunTime:0.001446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386465 ORDER BY `unit` DESC [ RunTime:0.001408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386465 LIMIT 2 [ RunTime:0.002466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386465 ORDER BY `minOrder` ASC [ RunTime:0.003869s ]
select * from pdf where partno='1872720000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872720000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003652s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386465 AND `partno` = '1872720000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63496495 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63496495 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63496495 ORDER BY `unit` DESC [ RunTime:0.000962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63496495 LIMIT 2 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63496495 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='187252-0R25' and brandshort='NI' limit 1 [ RunTime:0.000839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '187252-0R25' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.004546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63213196 LIMIT 5 [ RunTime:0.001854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213196 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63213196 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63213196 LIMIT 2 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213196 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
select * from pdf where partno='18727' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.001249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '18727' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.004585s ]
SELECT `id` FROM `stock` WHERE `id` <> 63213196 AND `partno` = '18727' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12238032 [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63221544 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63221544 ORDER BY `minOrder` ASC [ RunTime:0.002485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63221544 ORDER BY `unit` DESC [ RunTime:0.010680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63221544 LIMIT 2 [ RunTime:0.009490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63221544 ORDER BY `minOrder` ASC [ RunTime:0.001092s ]
select * from pdf where partno='1872460000' and brandshort='Weidmüller' limit 1 [ RunTime:0.020037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872460000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007498s ]
SELECT `id` FROM `stock` WHERE `id` <> 63221544 AND `partno` = '1872460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11236703 [ RunTime:0.017765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63221326 LIMIT 5 [ RunTime:0.006419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63221326 ORDER BY `minOrder` ASC [ RunTime:0.004822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63221326 ORDER BY `unit` DESC [ RunTime:0.010727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63221326 LIMIT 2 [ RunTime:0.015524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63221326 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
select * from pdf where partno='1872440000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872440000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009213s ]
SELECT `id` FROM `stock` WHERE `id` <> 63221326 AND `partno` = '1872440000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12241807 [ RunTime:0.008506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63213192 LIMIT 5 [ RunTime:0.010611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213192 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63213192 ORDER BY `unit` DESC [ RunTime:0.014424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63213192 LIMIT 2 [ RunTime:0.010824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213192 ORDER BY `minOrder` ASC [ RunTime:0.001367s ]
select * from pdf where partno='18728' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.010995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '18728' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.014436s ]
SELECT `id` FROM `stock` WHERE `id` <> 63213192 AND `partno` = '18728' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.024151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12238019 [ RunTime:0.024845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63166834 LIMIT 5 [ RunTime:0.005303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63166834 ORDER BY `minOrder` ASC [ RunTime:0.022719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63166834 ORDER BY `unit` DESC [ RunTime:0.016569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63166834 LIMIT 2 [ RunTime:0.013559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63166834 ORDER BY `minOrder` ASC [ RunTime:0.007836s ]
select * from pdf where partno='1872679999' and brandshort='Weidmüller' limit 1 [ RunTime:0.003132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872679999' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007236s ]
SELECT `id` FROM `stock` WHERE `id` <> 63166834 AND `partno` = '1872679999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63166407 LIMIT 5 [ RunTime:0.008087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63166407 ORDER BY `minOrder` ASC [ RunTime:0.005669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63166407 ORDER BY `unit` DESC [ RunTime:0.012143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63166407 LIMIT 2 [ RunTime:0.006148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63166407 ORDER BY `minOrder` ASC [ RunTime:0.002461s ]
select * from pdf where partno='1872659999' and brandshort='Weidmüller' limit 1 [ RunTime:0.002808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872659999' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004189s ]
SELECT `id` FROM `stock` WHERE `id` <> 63166407 AND `partno` = '1872659999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531381 [ RunTime:0.001238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63166172 LIMIT 5 [ RunTime:0.003400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63166172 ORDER BY `minOrder` ASC [ RunTime:0.004284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63166172 ORDER BY `unit` DESC [ RunTime:0.004996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63166172 LIMIT 2 [ RunTime:0.006499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63166172 ORDER BY `minOrder` ASC [ RunTime:0.001794s ]
select * from pdf where partno='1872661733' and brandshort='Weidmüller' limit 1 [ RunTime:0.006266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872661733' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010657s ]
SELECT `id` FROM `stock` WHERE `id` <> 63166172 AND `partno` = '1872661733' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401013 [ RunTime:0.010555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63164953 LIMIT 5 [ RunTime:0.002396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63164953 ORDER BY `minOrder` ASC [ RunTime:0.006914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63164953 ORDER BY `unit` DESC [ RunTime:0.011251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63164953 LIMIT 2 [ RunTime:0.002022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63164953 ORDER BY `minOrder` ASC [ RunTime:0.005223s ]
select * from pdf where partno='1872031734' and brandshort='Weidmüller' limit 1 [ RunTime:0.005922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872031734' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006449s ]
SELECT `id` FROM `stock` WHERE `id` <> 63164953 AND `partno` = '1872031734' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63139908 LIMIT 5 [ RunTime:0.004454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63139908 ORDER BY `minOrder` ASC [ RunTime:0.007004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63139908 ORDER BY `unit` DESC [ RunTime:0.004334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63139908 LIMIT 2 [ RunTime:0.010144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63139908 ORDER BY `minOrder` ASC [ RunTime:0.010743s ]
select * from pdf where partno='1872' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.021321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.007261s ]
SELECT `id` FROM `stock` WHERE `id` <> 63139908 AND `partno` = '1872' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.008949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63011686 LIMIT 5 [ RunTime:0.008249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011686 ORDER BY `minOrder` ASC [ RunTime:0.005564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63011686 ORDER BY `unit` DESC [ RunTime:0.004176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63011686 LIMIT 2 [ RunTime:0.012072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011686 ORDER BY `minOrder` ASC [ RunTime:0.007295s ]
select * from pdf where partno='1872A 006A1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.007889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872A 006A1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.001015s ]
SELECT `id` FROM `stock` WHERE `id` <> 63011686 AND `partno` = '1872A 006A1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496462 [ RunTime:0.005396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63011685 LIMIT 5 [ RunTime:0.005417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011685 ORDER BY `minOrder` ASC [ RunTime:0.007395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63011685 ORDER BY `unit` DESC [ RunTime:0.007981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63011685 LIMIT 2 [ RunTime:0.007877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011685 ORDER BY `minOrder` ASC [ RunTime:0.010936s ]
select * from pdf where partno='1872A 004A1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.013293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872A 004A1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.012625s ]
SELECT `id` FROM `stock` WHERE `id` <> 63011685 AND `partno` = '1872A 004A1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.005717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374076 [ RunTime:0.009367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63011684 LIMIT 5 [ RunTime:0.006925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011684 ORDER BY `minOrder` ASC [ RunTime:0.009527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63011684 ORDER BY `unit` DESC [ RunTime:0.011656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63011684 LIMIT 2 [ RunTime:0.005727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011684 ORDER BY `minOrder` ASC [ RunTime:0.008108s ]
select * from pdf where partno='1872A F6H1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.014730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872A F6H1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.014897s ]
SELECT `id` FROM `stock` WHERE `id` <> 63011684 AND `partno` = '1872A F6H1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.011813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374075 [ RunTime:0.003453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63011683 LIMIT 5 [ RunTime:0.007635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011683 ORDER BY `minOrder` ASC [ RunTime:0.010639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63011683 ORDER BY `unit` DESC [ RunTime:0.007739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63011683 LIMIT 2 [ RunTime:0.006774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011683 ORDER BY `minOrder` ASC [ RunTime:0.009189s ]
select * from pdf where partno='1872A 0101000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872A 0101000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.007822s ]
SELECT `id` FROM `stock` WHERE `id` <> 63011683 AND `partno` = '1872A 0101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.011220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496461 [ RunTime:0.004900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63011682 LIMIT 5 [ RunTime:0.004098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011682 ORDER BY `minOrder` ASC [ RunTime:0.003688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63011682 ORDER BY `unit` DESC [ RunTime:0.004171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63011682 LIMIT 2 [ RunTime:0.004848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63011682 ORDER BY `minOrder` ASC [ RunTime:0.004289s ]
select * from pdf where partno='1872A 0071000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.007110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1872A 0071000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.006038s ]
SELECT `id` FROM `stock` WHERE `id` <> 63011682 AND `partno` = '1872A 0071000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.009571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13496460 [ RunTime:0.007405s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007155s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011651s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003850s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004114s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004895s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016900s ]
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 '1872%' OR `brand` LIKE '1872%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023145s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1872%' OR `brand` LIKE '1872%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023465s ]