SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001266s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015786s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416434 LIMIT 5 [ RunTime:0.001141s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416434 ORDER BY `minOrder` ASC [ RunTime:0.001831s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11416434 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11416434 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416434 ORDER BY `minOrder` ASC [ RunTime:0.003528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405936 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405936 ORDER BY `minOrder` ASC [ RunTime:0.003540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405936 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405936 LIMIT 2 [ RunTime:0.002472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405936 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349266 LIMIT 5 [ RunTime:0.003884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349266 ORDER BY `minOrder` ASC [ RunTime:0.002007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349266 ORDER BY `unit` DESC [ RunTime:0.008754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349266 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349266 ORDER BY `minOrder` ASC [ RunTime:0.008812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417160 LIMIT 5 [ RunTime:0.006253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417160 ORDER BY `minOrder` ASC [ RunTime:0.001753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417160 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417160 LIMIT 2 [ RunTime:0.003111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417160 ORDER BY `minOrder` ASC [ RunTime:0.005289s ]
select * from pdf where partno='151791-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047311 LIMIT 5 [ RunTime:0.008903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047311 ORDER BY `minOrder` ASC [ RunTime:0.004618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047311 ORDER BY `unit` DESC [ RunTime:0.001506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047311 LIMIT 2 [ RunTime:0.008037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047311 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12539249 LIMIT 5 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12539249 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12539249 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12539249 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12539249 ORDER BY `minOrder` ASC [ RunTime:0.004668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12526482 LIMIT 5 [ RunTime:0.001470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12526482 ORDER BY `minOrder` ASC [ RunTime:0.016603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12526482 ORDER BY `unit` DESC [ RunTime:0.003543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12526482 LIMIT 2 [ RunTime:0.006669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12526482 ORDER BY `minOrder` ASC [ RunTime:0.004059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12395142 LIMIT 5 [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12395142 ORDER BY `minOrder` ASC [ RunTime:0.007883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12395142 ORDER BY `unit` DESC [ RunTime:0.012826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12395142 LIMIT 2 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12395142 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
select * from pdf where partno='15177' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4756 LIMIT 5 [ RunTime:0.006837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4756 ORDER BY `minOrder` ASC [ RunTime:0.003265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4756 ORDER BY `unit` DESC [ RunTime:0.006506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4756 LIMIT 2 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4756 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517360000' OR `brand` LIKE 'WEIDMULLER%' ) ) LIMIT 1 [ RunTime:0.012251s ]
SELECT `id` FROM `stock` WHERE `id` <> 4756 AND `partno` = '1517360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.007689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659868 [ RunTime:0.014830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14515313 LIMIT 5 [ RunTime:0.002992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14515313 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14515313 ORDER BY `unit` DESC [ RunTime:0.003209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14515313 LIMIT 2 [ RunTime:0.013759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14515313 ORDER BY `minOrder` ASC [ RunTime:0.020105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19263974 LIMIT 5 [ RunTime:0.014404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19263974 ORDER BY `minOrder` ASC [ RunTime:0.007351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19263974 ORDER BY `unit` DESC [ RunTime:0.000881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19263974 LIMIT 2 [ RunTime:0.004862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19263974 ORDER BY `minOrder` ASC [ RunTime:0.005213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13640649 LIMIT 5 [ RunTime:0.003977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13640649 ORDER BY `minOrder` ASC [ RunTime:0.014167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13640649 ORDER BY `unit` DESC [ RunTime:0.009025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13640649 LIMIT 2 [ RunTime:0.004784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13640649 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19141175 LIMIT 5 [ RunTime:0.002803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141175 ORDER BY `minOrder` ASC [ RunTime:0.004995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19141175 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19141175 LIMIT 2 [ RunTime:0.004932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141175 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19141195 LIMIT 5 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141195 ORDER BY `minOrder` ASC [ RunTime:0.002750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19141195 ORDER BY `unit` DESC [ RunTime:0.001864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19141195 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141195 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19141168 LIMIT 5 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141168 ORDER BY `minOrder` ASC [ RunTime:0.002976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19141168 ORDER BY `unit` DESC [ RunTime:0.010791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19141168 LIMIT 2 [ RunTime:0.018322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141168 ORDER BY `minOrder` ASC [ RunTime:0.011287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19067420 LIMIT 5 [ RunTime:0.007407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19067420 ORDER BY `minOrder` ASC [ RunTime:0.005715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19067420 ORDER BY `unit` DESC [ RunTime:0.008929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19067420 LIMIT 2 [ RunTime:0.005197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19067420 ORDER BY `minOrder` ASC [ RunTime:0.002226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509117 LIMIT 5 [ RunTime:0.003473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509117 ORDER BY `minOrder` ASC [ RunTime:0.001614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509117 ORDER BY `unit` DESC [ RunTime:0.021578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509117 LIMIT 2 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509117 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509108 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509108 ORDER BY `minOrder` ASC [ RunTime:0.010938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509108 ORDER BY `unit` DESC [ RunTime:0.025024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509108 LIMIT 2 [ RunTime:0.003879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509108 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17096394 LIMIT 5 [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17096394 ORDER BY `minOrder` ASC [ RunTime:0.005884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17096394 ORDER BY `unit` DESC [ RunTime:0.039776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17096394 LIMIT 2 [ RunTime:0.019623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17096394 ORDER BY `minOrder` ASC [ RunTime:0.012988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15317074 LIMIT 5 [ RunTime:0.018891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317074 ORDER BY `minOrder` ASC [ RunTime:0.009258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15317074 ORDER BY `unit` DESC [ RunTime:0.010323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15317074 LIMIT 2 [ RunTime:0.029510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15317074 ORDER BY `minOrder` ASC [ RunTime:0.021323s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282152 LIMIT 5 [ RunTime:0.003622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282152 ORDER BY `minOrder` ASC [ RunTime:0.011820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282152 ORDER BY `unit` DESC [ RunTime:0.006118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282152 LIMIT 2 [ RunTime:0.004955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282152 ORDER BY `minOrder` ASC [ RunTime:0.007454s ]
select * from pdf where partno='151730' and brandshort='te connectivity' limit 1 [ RunTime:0.001362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151730' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.031866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281792 LIMIT 5 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281792 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281792 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281792 LIMIT 2 [ RunTime:0.002694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281792 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='151791-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151791-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004431s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281792 AND `partno` = '151791-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137581 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137581 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137581 ORDER BY `unit` DESC [ RunTime:0.004995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137581 LIMIT 2 [ RunTime:0.002968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137581 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='1517602' and brandshort='phoenix contact' limit 1 [ RunTime:0.001143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517602' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.011318s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644729 LIMIT 5 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644729 ORDER BY `minOrder` ASC [ RunTime:0.001534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644729 ORDER BY `unit` DESC [ RunTime:0.005740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644729 LIMIT 2 [ RunTime:0.004539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644729 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
select * from pdf where partno='151730' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151730' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000671s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644729 AND `partno` = '151730' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416434 [ RunTime:0.008545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640370 LIMIT 5 [ RunTime:0.010563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640370 ORDER BY `minOrder` ASC [ RunTime:0.002327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640370 ORDER BY `unit` DESC [ RunTime:0.019191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640370 LIMIT 2 [ RunTime:0.007137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640370 ORDER BY `minOrder` ASC [ RunTime:0.030978s ]
select * from pdf where partno='151791-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151791-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013044s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640370 AND `partno` = '151791-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417160 [ RunTime:0.010532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63132237 LIMIT 5 [ RunTime:0.005476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63132237 ORDER BY `minOrder` ASC [ RunTime:0.001312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63132237 ORDER BY `unit` DESC [ RunTime:0.002620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63132237 LIMIT 2 [ RunTime:0.003665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63132237 ORDER BY `minOrder` ASC [ RunTime:0.006131s ]
select * from pdf where partno='1517' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.012062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.011729s ]
SELECT `id` FROM `stock` WHERE `id` <> 63132237 AND `partno` = '1517' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405936 [ RunTime:0.012867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63387076 LIMIT 5 [ RunTime:0.011411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387076 ORDER BY `minOrder` ASC [ RunTime:0.003984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63387076 ORDER BY `unit` DESC [ RunTime:0.007527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63387076 LIMIT 2 [ RunTime:0.005034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387076 ORDER BY `minOrder` ASC [ RunTime:0.007332s ]
select * from pdf where partno='15170B' and brandshort='Essentra Components' limit 1 [ RunTime:0.001355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15170B' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.001011s ]
SELECT `id` FROM `stock` WHERE `id` <> 63387076 AND `partno` = '15170B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63387269 LIMIT 5 [ RunTime:0.006410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387269 ORDER BY `minOrder` ASC [ RunTime:0.012212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63387269 ORDER BY `unit` DESC [ RunTime:0.015603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63387269 LIMIT 2 [ RunTime:0.022420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387269 ORDER BY `minOrder` ASC [ RunTime:0.005446s ]
select * from pdf where partno='15172B' and brandshort='Essentra Components' limit 1 [ RunTime:0.002514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15172B' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000863s ]
SELECT `id` FROM `stock` WHERE `id` <> 63387269 AND `partno` = '15172B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.003202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047311 [ RunTime:0.000919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559738 LIMIT 5 [ RunTime:0.002027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559738 ORDER BY `minOrder` ASC [ RunTime:0.001493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559738 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559738 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559738 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='1517CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001766s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559738 AND `partno` = '1517CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349266 [ RunTime:0.000993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64049158 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049158 ORDER BY `minOrder` ASC [ RunTime:0.004476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64049158 ORDER BY `unit` DESC [ RunTime:0.010437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64049158 LIMIT 2 [ RunTime:0.023943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049158 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
select * from pdf where partno='15177' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15177' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.002564s ]
SELECT `id` FROM `stock` WHERE `id` <> 64049158 AND `partno` = '15177' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12395142 [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60428707 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60428707 ORDER BY `minOrder` ASC [ RunTime:0.004228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60428707 ORDER BY `unit` DESC [ RunTime:0.006327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60428707 LIMIT 2 [ RunTime:0.002400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60428707 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='1517' and brandshort='Curtis Industries' limit 1 [ RunTime:0.011981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.010717s ]
SELECT `id` FROM `stock` WHERE `id` <> 60428707 AND `partno` = '1517' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.003233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12539249 [ RunTime:0.002180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60429968 LIMIT 5 [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429968 ORDER BY `minOrder` ASC [ RunTime:0.041218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60429968 ORDER BY `unit` DESC [ RunTime:0.001306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60429968 LIMIT 2 [ RunTime:0.008208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429968 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='1517-Y' and brandshort='Curtis Industries' limit 1 [ RunTime:0.001248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517-Y' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.004189s ]
SELECT `id` FROM `stock` WHERE `id` <> 60429968 AND `partno` = '1517-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12526482 [ RunTime:0.003406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60429711 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429711 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60429711 ORDER BY `unit` DESC [ RunTime:0.002650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60429711 LIMIT 2 [ RunTime:0.003049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60429711 ORDER BY `minOrder` ASC [ RunTime:0.005806s ]
select * from pdf where partno='1517W' and brandshort='Curtis Industries' limit 1 [ RunTime:0.005726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517W' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.002614s ]
SELECT `id` FROM `stock` WHERE `id` <> 60429711 AND `partno` = '1517W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.009444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61187585 LIMIT 5 [ RunTime:0.006433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61187585 ORDER BY `minOrder` ASC [ RunTime:0.014387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61187585 ORDER BY `unit` DESC [ RunTime:0.000817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61187585 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61187585 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
select * from pdf where partno='151700-0553' and brandshort='WEC' limit 1 [ RunTime:0.002970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151700-0553' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62388606 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62388606 ORDER BY `minOrder` ASC [ RunTime:0.004396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62388606 ORDER BY `unit` DESC [ RunTime:0.002017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62388606 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62388606 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='151733-05' and brandshort='NI' limit 1 [ RunTime:0.000930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151733-05' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.011444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62387915 LIMIT 5 [ RunTime:0.007628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62387915 ORDER BY `minOrder` ASC [ RunTime:0.001671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62387915 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62387915 LIMIT 2 [ RunTime:0.002357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62387915 ORDER BY `minOrder` ASC [ RunTime:0.000803s ]
select * from pdf where partno='151733-02' and brandshort='NI' limit 1 [ RunTime:0.000966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151733-02' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.018335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62387849 LIMIT 5 [ RunTime:0.013740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62387849 ORDER BY `minOrder` ASC [ RunTime:0.008453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62387849 ORDER BY `unit` DESC [ RunTime:0.002259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62387849 LIMIT 2 [ RunTime:0.004247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62387849 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='151733-01' and brandshort='NI' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151733-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.002406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64247003 LIMIT 5 [ RunTime:0.001856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64247003 ORDER BY `minOrder` ASC [ RunTime:0.001539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64247003 ORDER BY `unit` DESC [ RunTime:0.001919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64247003 LIMIT 2 [ RunTime:0.001553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64247003 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='151741' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151741' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002940s ]
SELECT `id` FROM `stock` WHERE `id` <> 64247003 AND `partno` = '151741' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.037875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359925 [ RunTime:0.004222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63425652 LIMIT 5 [ RunTime:0.001962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63425652 ORDER BY `minOrder` ASC [ RunTime:0.003469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63425652 ORDER BY `unit` DESC [ RunTime:0.002861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63425652 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63425652 ORDER BY `minOrder` ASC [ RunTime:0.000873s ]
select * from pdf where partno='1517000' and brandshort='Rittal' limit 1 [ RunTime:0.000953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.001349s ]
SELECT `id` FROM `stock` WHERE `id` <> 63425652 AND `partno` = '1517000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.000817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63376572 LIMIT 5 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376572 ORDER BY `minOrder` ASC [ RunTime:0.002652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63376572 ORDER BY `unit` DESC [ RunTime:0.001895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63376572 LIMIT 2 [ RunTime:0.011403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376572 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='151749' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151749' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009175s ]
SELECT `id` FROM `stock` WHERE `id` <> 63376572 AND `partno` = '151749' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509108 [ RunTime:0.003774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64437734 LIMIT 5 [ RunTime:0.016169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437734 ORDER BY `minOrder` ASC [ RunTime:0.025681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64437734 ORDER BY `unit` DESC [ RunTime:0.016942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64437734 LIMIT 2 [ RunTime:0.015248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437734 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='1517107' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517107' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64437708 LIMIT 5 [ RunTime:0.008559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437708 ORDER BY `minOrder` ASC [ RunTime:0.010860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64437708 ORDER BY `unit` DESC [ RunTime:0.000700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64437708 LIMIT 2 [ RunTime:0.027159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437708 ORDER BY `minOrder` ASC [ RunTime:0.008033s ]
select * from pdf where partno='1517181' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517181' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64437632 LIMIT 5 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437632 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64437632 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64437632 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437632 ORDER BY `minOrder` ASC [ RunTime:0.003323s ]
select * from pdf where partno='1517042' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1517042' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009680s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002201s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001157s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010470s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002736s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010473s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008091s ]
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 '1517%' OR `brand` LIKE '1517%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001512s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1517%' OR `brand` LIKE '1517%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005189s ]