SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002699s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089447s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511290 LIMIT 5 [ RunTime:0.080722s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511290 ORDER BY `minOrder` ASC [ RunTime:0.000792s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19511290 ORDER BY `unit` DESC [ RunTime:0.025772s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19511290 LIMIT 2 [ RunTime:0.054035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511290 ORDER BY `minOrder` ASC [ RunTime:0.007604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15680721 LIMIT 5 [ RunTime:0.042569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15680721 ORDER BY `minOrder` ASC [ RunTime:0.059791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15680721 ORDER BY `unit` DESC [ RunTime:0.064609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15680721 LIMIT 2 [ RunTime:0.047387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15680721 ORDER BY `minOrder` ASC [ RunTime:0.035794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308161 LIMIT 5 [ RunTime:0.108909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308161 ORDER BY `minOrder` ASC [ RunTime:0.076033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13308161 ORDER BY `unit` DESC [ RunTime:0.054614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13308161 LIMIT 2 [ RunTime:0.050925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308161 ORDER BY `minOrder` ASC [ RunTime:0.075716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13306642 LIMIT 5 [ RunTime:0.051857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13306642 ORDER BY `minOrder` ASC [ RunTime:0.051043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13306642 ORDER BY `unit` DESC [ RunTime:0.051074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13306642 LIMIT 2 [ RunTime:0.050956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13306642 ORDER BY `minOrder` ASC [ RunTime:0.050910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13180521 LIMIT 5 [ RunTime:0.062822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13180521 ORDER BY `minOrder` ASC [ RunTime:0.020413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13180521 ORDER BY `unit` DESC [ RunTime:0.033091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13180521 LIMIT 2 [ RunTime:0.047813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13180521 ORDER BY `minOrder` ASC [ RunTime:0.040090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448511 LIMIT 5 [ RunTime:0.047640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448511 ORDER BY `minOrder` ASC [ RunTime:0.057726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12448511 ORDER BY `unit` DESC [ RunTime:0.083851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12448511 LIMIT 2 [ RunTime:0.042559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448511 ORDER BY `minOrder` ASC [ RunTime:0.093403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448471 LIMIT 5 [ RunTime:0.038089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448471 ORDER BY `minOrder` ASC [ RunTime:0.030639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12448471 ORDER BY `unit` DESC [ RunTime:0.013436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12448471 LIMIT 2 [ RunTime:0.024401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448471 ORDER BY `minOrder` ASC [ RunTime:0.016302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448098 LIMIT 5 [ RunTime:0.057353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448098 ORDER BY `minOrder` ASC [ RunTime:0.023281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12448098 ORDER BY `unit` DESC [ RunTime:0.029021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12448098 LIMIT 2 [ RunTime:0.035769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12448098 ORDER BY `minOrder` ASC [ RunTime:0.017088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447302 LIMIT 5 [ RunTime:0.042499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447302 ORDER BY `minOrder` ASC [ RunTime:0.036670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12447302 ORDER BY `unit` DESC [ RunTime:0.016373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12447302 LIMIT 2 [ RunTime:0.044522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12447302 ORDER BY `minOrder` ASC [ RunTime:0.013133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365687 LIMIT 5 [ RunTime:0.016748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11365687 ORDER BY `minOrder` ASC [ RunTime:0.017692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11365687 ORDER BY `unit` DESC [ RunTime:0.035580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11365687 LIMIT 2 [ RunTime:0.020062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11365687 ORDER BY `minOrder` ASC [ RunTime:0.015112s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015193s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60657584 LIMIT 5 [ RunTime:0.012595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60657584 ORDER BY `minOrder` ASC [ RunTime:0.032609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60657584 ORDER BY `unit` DESC [ RunTime:0.029409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60657584 LIMIT 2 [ RunTime:0.055020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60657584 ORDER BY `minOrder` ASC [ RunTime:0.039824s ]
select * from pdf where partno='52575-0710M-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.053070s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52575-0710M-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.019234s ]
SELECT `id` FROM `stock` WHERE `id` <> 60657584 AND `partno` = '52575-0710M-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.046692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13180521 [ RunTime:0.018738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57237399 LIMIT 5 [ RunTime:0.050452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57237399 ORDER BY `minOrder` ASC [ RunTime:0.020450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57237399 ORDER BY `unit` DESC [ RunTime:0.025969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57237399 LIMIT 2 [ RunTime:0.064734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57237399 ORDER BY `minOrder` ASC [ RunTime:0.012434s ]
select * from pdf where partno='5257' and brandshort='Pololu' limit 1 [ RunTime:0.036395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.038149s ]
SELECT `id` FROM `stock` WHERE `id` <> 57237399 AND `partno` = '5257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.028919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511290 [ RunTime:0.017242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57756238 LIMIT 5 [ RunTime:0.034079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756238 ORDER BY `minOrder` ASC [ RunTime:0.020613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57756238 ORDER BY `unit` DESC [ RunTime:0.021330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57756238 LIMIT 2 [ RunTime:0.013170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756238 ORDER BY `minOrder` ASC [ RunTime:0.022333s ]
select * from pdf where partno='5257CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.017561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.022648s ]
SELECT `id` FROM `stock` WHERE `id` <> 57756238 AND `partno` = '5257CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.008754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60663053 LIMIT 5 [ RunTime:0.009805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60663053 ORDER BY `minOrder` ASC [ RunTime:0.024340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60663053 ORDER BY `unit` DESC [ RunTime:0.016923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60663053 LIMIT 2 [ RunTime:0.014019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60663053 ORDER BY `minOrder` ASC [ RunTime:0.029929s ]
select * from pdf where partno='52575-0470M- 001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.016623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52575-0470M- 001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.007580s ]
SELECT `id` FROM `stock` WHERE `id` <> 60663053 AND `partno` = '52575-0470M- 001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.010869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423278 LIMIT 5 [ RunTime:0.023027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423278 ORDER BY `minOrder` ASC [ RunTime:0.010014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423278 ORDER BY `unit` DESC [ RunTime:0.004741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423278 LIMIT 2 [ RunTime:0.012650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423278 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
select * from pdf where partno='5257WADUL' and brandshort='APEM Inc.' limit 1 [ RunTime:0.011730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257WADUL' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.034969s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423278 AND `partno` = '5257WADUL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.013686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11365687 [ RunTime:0.005144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423228 LIMIT 5 [ RunTime:0.014658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423228 ORDER BY `minOrder` ASC [ RunTime:0.003533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423228 ORDER BY `unit` DESC [ RunTime:0.011213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423228 LIMIT 2 [ RunTime:0.004508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423228 ORDER BY `minOrder` ASC [ RunTime:0.002339s ]
select * from pdf where partno='5257WCDB16' and brandshort='APEM Inc.' limit 1 [ RunTime:0.004027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257WCDB16' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.002345s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423228 AND `partno` = '5257WCDB16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.006115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423224 LIMIT 5 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423224 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423224 ORDER BY `unit` DESC [ RunTime:0.000886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423224 LIMIT 2 [ RunTime:0.005235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423224 ORDER BY `minOrder` ASC [ RunTime:0.002132s ]
select * from pdf where partno='5257WWA' and brandshort='APEM Inc.' limit 1 [ RunTime:0.002447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257WWA' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.003440s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423224 AND `partno` = '5257WWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.001200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448511 [ RunTime:0.005272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423174 LIMIT 5 [ RunTime:0.005159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423174 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423174 ORDER BY `unit` DESC [ RunTime:0.000920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423174 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423174 ORDER BY `minOrder` ASC [ RunTime:0.004215s ]
select * from pdf where partno='5257WADB16UL' and brandshort='APEM Inc.' limit 1 [ RunTime:0.004343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257WADB16UL' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.002749s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423174 AND `partno` = '5257WADB16UL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.004024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448471 [ RunTime:0.000895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58423094 LIMIT 5 [ RunTime:0.004116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423094 ORDER BY `minOrder` ASC [ RunTime:0.004431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58423094 ORDER BY `unit` DESC [ RunTime:0.002896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58423094 LIMIT 2 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58423094 ORDER BY `minOrder` ASC [ RunTime:0.001351s ]
select * from pdf where partno='5257CDKB16' and brandshort='APEM Inc.' limit 1 [ RunTime:0.002649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257CDKB16' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.003369s ]
SELECT `id` FROM `stock` WHERE `id` <> 58423094 AND `partno` = '5257CDKB16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.003390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58422566 LIMIT 5 [ RunTime:0.002082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58422566 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58422566 ORDER BY `unit` DESC [ RunTime:0.006861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58422566 LIMIT 2 [ RunTime:0.004956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58422566 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
select * from pdf where partno='5257AB' and brandshort='APEM Inc.' limit 1 [ RunTime:0.002940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257AB' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.001852s ]
SELECT `id` FROM `stock` WHERE `id` <> 58422566 AND `partno` = '5257AB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12448098 [ RunTime:0.002975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58420146 LIMIT 5 [ RunTime:0.001300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58420146 ORDER BY `minOrder` ASC [ RunTime:0.001282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58420146 ORDER BY `unit` DESC [ RunTime:0.002155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58420146 LIMIT 2 [ RunTime:0.003191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58420146 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
select * from pdf where partno='5257CDB' and brandshort='APEM Inc.' limit 1 [ RunTime:0.004897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257CDB' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.000951s ]
SELECT `id` FROM `stock` WHERE `id` <> 58420146 AND `partno` = '5257CDB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.001046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12447302 [ RunTime:0.003106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40776384 LIMIT 5 [ RunTime:0.001606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40776384 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40776384 ORDER BY `unit` DESC [ RunTime:0.000939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40776384 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40776384 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
select * from pdf where partno='5257' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5257' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.002049s ]
SELECT `id` FROM `stock` WHERE `id` <> 40776384 AND `partno` = '5257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.001395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15680721 [ RunTime:0.001104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32516535 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32516535 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32516535 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32516535 LIMIT 2 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32516535 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
select * from pdf where partno='52572' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.002199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52572' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.002602s ]
SELECT `id` FROM `stock` WHERE `id` <> 32516535 AND `partno` = '52572' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.002438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32508363 LIMIT 5 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32508363 ORDER BY `minOrder` ASC [ RunTime:0.001371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32508363 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32508363 LIMIT 2 [ RunTime:0.002304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32508363 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
select * from pdf where partno='52571' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.007301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52571' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.002662s ]
SELECT `id` FROM `stock` WHERE `id` <> 32508363 AND `partno` = '52571' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.001175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32488441 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32488441 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32488441 ORDER BY `unit` DESC [ RunTime:0.000999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32488441 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32488441 ORDER BY `minOrder` ASC [ RunTime:0.002663s ]
select * from pdf where partno='52573' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.006815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52573' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.007791s ]
SELECT `id` FROM `stock` WHERE `id` <> 32488441 AND `partno` = '52573' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.016118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32346532 LIMIT 5 [ RunTime:0.017208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32346532 ORDER BY `minOrder` ASC [ RunTime:0.008797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32346532 ORDER BY `unit` DESC [ RunTime:0.009021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32346532 LIMIT 2 [ RunTime:0.016146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32346532 ORDER BY `minOrder` ASC [ RunTime:0.008603s ]
select * from pdf where partno='52573G' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.018117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52573G' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.027657s ]
SELECT `id` FROM `stock` WHERE `id` <> 32346532 AND `partno` = '52573G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.009350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308161 [ RunTime:0.010803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32335698 LIMIT 5 [ RunTime:0.020876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32335698 ORDER BY `minOrder` ASC [ RunTime:0.028434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32335698 ORDER BY `unit` DESC [ RunTime:0.007308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32335698 LIMIT 2 [ RunTime:0.027554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32335698 ORDER BY `minOrder` ASC [ RunTime:0.043905s ]
select * from pdf where partno='52570' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.024943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52570' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.009514s ]
SELECT `id` FROM `stock` WHERE `id` <> 32335698 AND `partno` = '52570' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.023630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13306642 [ RunTime:0.010280s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059775s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015267s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012229s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020506s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018641s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058918s ]
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 '5257%' OR `brand` LIKE '5257%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061525s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5257%' OR `brand` LIKE '5257%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.081609s ]