SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002171s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008888s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415283 LIMIT 5 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415283 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16415283 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16415283 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415283 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16659816 LIMIT 5 [ RunTime:0.005684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16659816 ORDER BY `minOrder` ASC [ RunTime:0.011102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16659816 ORDER BY `unit` DESC [ RunTime:0.013861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16659816 LIMIT 2 [ RunTime:0.009567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16659816 ORDER BY `minOrder` ASC [ RunTime:0.006553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509932 LIMIT 5 [ RunTime:0.003804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509932 ORDER BY `minOrder` ASC [ RunTime:0.014827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509932 ORDER BY `unit` DESC [ RunTime:0.010013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509932 LIMIT 2 [ RunTime:0.012412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509932 ORDER BY `minOrder` ASC [ RunTime:0.000949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16659823 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16659823 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16659823 ORDER BY `unit` DESC [ RunTime:0.008390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16659823 LIMIT 2 [ RunTime:0.007075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16659823 ORDER BY `minOrder` ASC [ RunTime:0.006138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901512 LIMIT 5 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901512 ORDER BY `minOrder` ASC [ RunTime:0.001101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13901512 ORDER BY `unit` DESC [ RunTime:0.000885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13901512 LIMIT 2 [ RunTime:0.004567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13901512 ORDER BY `minOrder` ASC [ RunTime:0.003946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16736622 LIMIT 5 [ RunTime:0.002594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16736622 ORDER BY `minOrder` ASC [ RunTime:0.004161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16736622 ORDER BY `unit` DESC [ RunTime:0.007392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16736622 LIMIT 2 [ RunTime:0.005404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16736622 ORDER BY `minOrder` ASC [ RunTime:0.002329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14798057 LIMIT 5 [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14798057 ORDER BY `minOrder` ASC [ RunTime:0.004647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14798057 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14798057 LIMIT 2 [ RunTime:0.001580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14798057 ORDER BY `minOrder` ASC [ RunTime:0.004634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796932 LIMIT 5 [ RunTime:0.003731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796932 ORDER BY `minOrder` ASC [ RunTime:0.003411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14796932 ORDER BY `unit` DESC [ RunTime:0.003074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14796932 LIMIT 2 [ RunTime:0.003746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796932 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866748 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866748 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18866748 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18866748 LIMIT 2 [ RunTime:0.002565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866748 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16659833 LIMIT 5 [ RunTime:0.002652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16659833 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16659833 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16659833 LIMIT 2 [ RunTime:0.002764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16659833 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658634 LIMIT 5 [ RunTime:0.003327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16658634 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16658634 ORDER BY `unit` DESC [ RunTime:0.000802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16658634 LIMIT 2 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16658634 ORDER BY `minOrder` ASC [ RunTime:0.001255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658626 LIMIT 5 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16658626 ORDER BY `minOrder` ASC [ RunTime:0.002096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16658626 ORDER BY `unit` DESC [ RunTime:0.004346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16658626 LIMIT 2 [ RunTime:0.002617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16658626 ORDER BY `minOrder` ASC [ RunTime:0.001949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796944 LIMIT 5 [ RunTime:0.006896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796944 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14796944 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14796944 LIMIT 2 [ RunTime:0.001768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14796944 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660312 LIMIT 5 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660312 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16660312 ORDER BY `unit` DESC [ RunTime:0.004972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16660312 LIMIT 2 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660312 ORDER BY `minOrder` ASC [ RunTime:0.004597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16660310 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660310 ORDER BY `minOrder` ASC [ RunTime:0.004444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16660310 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16660310 LIMIT 2 [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16660310 ORDER BY `minOrder` ASC [ RunTime:0.002507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14798609 LIMIT 5 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14798609 ORDER BY `minOrder` ASC [ RunTime:0.002709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14798609 ORDER BY `unit` DESC [ RunTime:0.005030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14798609 LIMIT 2 [ RunTime:0.005991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14798609 ORDER BY `minOrder` ASC [ RunTime:0.003264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140948 LIMIT 5 [ RunTime:0.003417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140948 ORDER BY `minOrder` ASC [ RunTime:0.002651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140948 ORDER BY `unit` DESC [ RunTime:0.001715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140948 LIMIT 2 [ RunTime:0.002134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140948 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140947 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140947 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140947 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140947 LIMIT 2 [ RunTime:0.001034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140947 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140946 LIMIT 5 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140946 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140946 ORDER BY `unit` DESC [ RunTime:0.000699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140946 LIMIT 2 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140946 ORDER BY `minOrder` ASC [ RunTime:0.001144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19140827 LIMIT 5 [ RunTime:0.001151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140827 ORDER BY `minOrder` ASC [ RunTime:0.000868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19140827 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19140827 LIMIT 2 [ RunTime:0.001170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19140827 ORDER BY `minOrder` ASC [ RunTime:0.001505s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088621 LIMIT 5 [ RunTime:0.001767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088621 ORDER BY `minOrder` ASC [ RunTime:0.002119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088621 ORDER BY `unit` DESC [ RunTime:0.001627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088621 LIMIT 2 [ RunTime:0.001325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088621 ORDER BY `minOrder` ASC [ RunTime:0.001962s ]
select * from pdf where partno='2736903' and brandshort='phoenix contact' limit 1 [ RunTime:0.001496s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736903' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090041 LIMIT 5 [ RunTime:0.002975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090041 ORDER BY `minOrder` ASC [ RunTime:0.004201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090041 ORDER BY `unit` DESC [ RunTime:0.004597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090041 LIMIT 2 [ RunTime:0.002541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090041 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
select * from pdf where partno='2736450000' and brandshort='weidmuller' limit 1 [ RunTime:0.001217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736450000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.001742s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090041 AND `partno` = '2736450000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.002978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16658275 [ RunTime:0.003806s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339366 LIMIT 5 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339366 ORDER BY `minOrder` ASC [ RunTime:0.001712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339366 ORDER BY `unit` DESC [ RunTime:0.006136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339366 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339366 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='273650-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '273650-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000266s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339366 AND `partno` = '273650-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415283 [ RunTime:0.006468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531403 LIMIT 5 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531403 ORDER BY `minOrder` ASC [ RunTime:0.001614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531403 ORDER BY `unit` DESC [ RunTime:0.005714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531403 LIMIT 2 [ RunTime:0.000224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531403 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
select * from pdf where partno='273650-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '273650-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000233s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531403 AND `partno` = '273650-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415283 [ RunTime:0.001896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339367 LIMIT 5 [ RunTime:0.000211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339367 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339367 ORDER BY `unit` DESC [ RunTime:0.001560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339367 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339367 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
select * from pdf where partno='273650-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '273650-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.003440s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339367 AND `partno` = '273650-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415283 [ RunTime:0.001713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531404 LIMIT 5 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531404 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531404 ORDER BY `unit` DESC [ RunTime:0.001438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531404 LIMIT 2 [ RunTime:0.000197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531404 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
select * from pdf where partno='273650-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '273650-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000235s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531404 AND `partno` = '273650-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415283 [ RunTime:0.004447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51146312 LIMIT 5 [ RunTime:0.002927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51146312 ORDER BY `minOrder` ASC [ RunTime:0.003416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51146312 ORDER BY `unit` DESC [ RunTime:0.002009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51146312 LIMIT 2 [ RunTime:0.001254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51146312 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
select * from pdf where partno='2736' and brandshort='KEMET' limit 1 [ RunTime:0.009304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.005576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720682 LIMIT 5 [ RunTime:0.001660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720682 ORDER BY `minOrder` ASC [ RunTime:0.008245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720682 ORDER BY `unit` DESC [ RunTime:0.004140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720682 LIMIT 2 [ RunTime:0.001430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720682 ORDER BY `minOrder` ASC [ RunTime:0.003115s ]
select * from pdf where partno='2736210000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736210000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001600s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720682 AND `partno` = '2736210000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657999 [ RunTime:0.004782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38113191 LIMIT 5 [ RunTime:0.008924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38113191 ORDER BY `minOrder` ASC [ RunTime:0.010337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38113191 ORDER BY `unit` DESC [ RunTime:0.001842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38113191 LIMIT 2 [ RunTime:0.006493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38113191 ORDER BY `minOrder` ASC [ RunTime:0.002710s ]
select * from pdf where partno='2736210000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736210000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000447s ]
SELECT `id` FROM `stock` WHERE `id` <> 38113191 AND `partno` = '2736210000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657999 [ RunTime:0.010489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720123 LIMIT 5 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720123 ORDER BY `minOrder` ASC [ RunTime:0.010589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720123 ORDER BY `unit` DESC [ RunTime:0.001169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720123 LIMIT 2 [ RunTime:0.009863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720123 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
select * from pdf where partno='2736430000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736430000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005234s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720123 AND `partno` = '2736430000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796377 [ RunTime:0.017486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38112322 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38112322 ORDER BY `minOrder` ASC [ RunTime:0.006941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38112322 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38112322 LIMIT 2 [ RunTime:0.006303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38112322 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
select * from pdf where partno='2736430000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736430000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000510s ]
SELECT `id` FROM `stock` WHERE `id` <> 38112322 AND `partno` = '2736430000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796377 [ RunTime:0.002790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37431708 LIMIT 5 [ RunTime:0.003736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37431708 ORDER BY `minOrder` ASC [ RunTime:0.009536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37431708 ORDER BY `unit` DESC [ RunTime:0.006378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37431708 LIMIT 2 [ RunTime:0.004505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37431708 ORDER BY `minOrder` ASC [ RunTime:0.012969s ]
select * from pdf where partno='2736' and brandshort='Pololu' limit 1 [ RunTime:0.001287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.003188s ]
SELECT `id` FROM `stock` WHERE `id` <> 37431708 AND `partno` = '2736' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.004652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509932 [ RunTime:0.008059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50234748 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50234748 ORDER BY `minOrder` ASC [ RunTime:0.002993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50234748 ORDER BY `unit` DESC [ RunTime:0.000949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50234748 LIMIT 2 [ RunTime:0.012845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50234748 ORDER BY `minOrder` ASC [ RunTime:0.002903s ]
select * from pdf where partno='2736' and brandshort='Pololu' limit 1 [ RunTime:0.000471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.000369s ]
SELECT `id` FROM `stock` WHERE `id` <> 50234748 AND `partno` = '2736' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509932 [ RunTime:0.006174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38112377 LIMIT 5 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38112377 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38112377 ORDER BY `unit` DESC [ RunTime:0.001666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38112377 LIMIT 2 [ RunTime:0.001812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38112377 ORDER BY `minOrder` ASC [ RunTime:0.007855s ]
select * from pdf where partno='2736310000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736310000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003938s ]
SELECT `id` FROM `stock` WHERE `id` <> 38112377 AND `partno` = '2736310000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796932 [ RunTime:0.009856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720464 LIMIT 5 [ RunTime:0.002892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720464 ORDER BY `minOrder` ASC [ RunTime:0.006707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720464 ORDER BY `unit` DESC [ RunTime:0.001028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720464 LIMIT 2 [ RunTime:0.002298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720464 ORDER BY `minOrder` ASC [ RunTime:0.009604s ]
select * from pdf where partno='2736460000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736460000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008286s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720464 AND `partno` = '2736460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901512 [ RunTime:0.007748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38112867 LIMIT 5 [ RunTime:0.004161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38112867 ORDER BY `minOrder` ASC [ RunTime:0.002443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38112867 ORDER BY `unit` DESC [ RunTime:0.001922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38112867 LIMIT 2 [ RunTime:0.002255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38112867 ORDER BY `minOrder` ASC [ RunTime:0.005921s ]
select * from pdf where partno='2736460000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736460000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000258s ]
SELECT `id` FROM `stock` WHERE `id` <> 38112867 AND `partno` = '2736460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13901512 [ RunTime:0.002461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720175 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720175 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720175 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720175 LIMIT 2 [ RunTime:0.002126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720175 ORDER BY `minOrder` ASC [ RunTime:0.006274s ]
select * from pdf where partno='2736310000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736310000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000222s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720175 AND `partno` = '2736310000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796932 [ RunTime:0.002389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720695 LIMIT 5 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720695 ORDER BY `minOrder` ASC [ RunTime:0.007593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720695 ORDER BY `unit` DESC [ RunTime:0.004717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720695 LIMIT 2 [ RunTime:0.001447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720695 ORDER BY `minOrder` ASC [ RunTime:0.007832s ]
select * from pdf where partno='2736280000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736280000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005275s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720695 AND `partno` = '2736280000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14798057 [ RunTime:0.007748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50266403 LIMIT 5 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50266403 ORDER BY `minOrder` ASC [ RunTime:0.002200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50266403 ORDER BY `unit` DESC [ RunTime:0.001632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50266403 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50266403 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='2736505' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736505' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38113205 LIMIT 5 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38113205 ORDER BY `minOrder` ASC [ RunTime:0.004584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38113205 ORDER BY `unit` DESC [ RunTime:0.002904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38113205 LIMIT 2 [ RunTime:0.003895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38113205 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
select * from pdf where partno='2736280000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736280000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000447s ]
SELECT `id` FROM `stock` WHERE `id` <> 38113205 AND `partno` = '2736280000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14798057 [ RunTime:0.008786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37463497 LIMIT 5 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37463497 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37463497 ORDER BY `unit` DESC [ RunTime:0.003298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37463497 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37463497 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='2736505' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736505' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50720702 LIMIT 5 [ RunTime:0.000833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720702 ORDER BY `minOrder` ASC [ RunTime:0.004663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50720702 ORDER BY `unit` DESC [ RunTime:0.002936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50720702 LIMIT 2 [ RunTime:0.003907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50720702 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
select * from pdf where partno='2736440000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2736440000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002911s ]
SELECT `id` FROM `stock` WHERE `id` <> 50720702 AND `partno` = '2736440000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14796583 [ RunTime:0.010029s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001931s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005994s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004775s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004383s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004119s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003735s ]
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 '2736%' OR `brand` LIKE '2736%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003497s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2736%' OR `brand` LIKE '2736%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003792s ]