SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002103s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047404s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569167 LIMIT 5 [ RunTime:0.005926s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569167 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19569167 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19569167 LIMIT 2 [ RunTime:0.005236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569167 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569122 LIMIT 5 [ RunTime:0.002774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569122 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19569122 ORDER BY `unit` DESC [ RunTime:0.002480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19569122 LIMIT 2 [ RunTime:0.001834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569122 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569038 LIMIT 5 [ RunTime:0.002019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569038 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19569038 ORDER BY `unit` DESC [ RunTime:0.003556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19569038 LIMIT 2 [ RunTime:0.000740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569038 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027908 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027908 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027908 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027908 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027908 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027830 LIMIT 5 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027830 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027830 ORDER BY `unit` DESC [ RunTime:0.000264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027830 LIMIT 2 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027830 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
select * from pdf where partno='ADP06080R5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027583 LIMIT 5 [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027583 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027583 ORDER BY `unit` DESC [ RunTime:0.000273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027583 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027583 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027286 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027286 ORDER BY `minOrder` ASC [ RunTime:0.002991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027286 ORDER BY `unit` DESC [ RunTime:0.002895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027286 LIMIT 2 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027286 ORDER BY `minOrder` ASC [ RunTime:0.002517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274716 LIMIT 5 [ RunTime:0.003154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274716 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274716 ORDER BY `unit` DESC [ RunTime:0.004483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274716 LIMIT 2 [ RunTime:0.001780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274716 ORDER BY `minOrder` ASC [ RunTime:0.003049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203576 LIMIT 5 [ RunTime:0.001978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203576 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14203576 ORDER BY `unit` DESC [ RunTime:0.007614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14203576 LIMIT 2 [ RunTime:0.002319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203576 ORDER BY `minOrder` ASC [ RunTime:0.003092s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002227s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63442429 LIMIT 5 [ RunTime:0.001283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63442429 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63442429 ORDER BY `unit` DESC [ RunTime:0.000197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63442429 LIMIT 2 [ RunTime:0.000198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63442429 ORDER BY `minOrder` ASC [ RunTime:0.000190s ]
select * from pdf where partno='ADP06080RR5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.007134s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06080RR5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.014257s ]
SELECT `id` FROM `stock` WHERE `id` <> 63442429 AND `partno` = 'ADP06080RR5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.003195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027908 [ RunTime:0.003115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63442282 LIMIT 5 [ RunTime:0.007525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63442282 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63442282 ORDER BY `unit` DESC [ RunTime:0.001768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63442282 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63442282 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='ADP06080R5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.007153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06080R5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.011581s ]
SELECT `id` FROM `stock` WHERE `id` <> 63442282 AND `partno` = 'ADP06080R5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.011777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027830 [ RunTime:0.013284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441809 LIMIT 5 [ RunTime:0.015058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441809 ORDER BY `minOrder` ASC [ RunTime:0.012997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441809 ORDER BY `unit` DESC [ RunTime:0.007581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441809 LIMIT 2 [ RunTime:0.001680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441809 ORDER BY `minOrder` ASC [ RunTime:0.001784s ]
select * from pdf where partno='ADP06080LR5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.002068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06080LR5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.001692s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441809 AND `partno` = 'ADP06080LR5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027583 [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441727 LIMIT 5 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441727 ORDER BY `minOrder` ASC [ RunTime:0.000870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441727 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441727 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441727 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='ADP06060R5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06060R5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441727 AND `partno` = 'ADP06060R5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203576 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441358 LIMIT 5 [ RunTime:0.000827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441358 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441358 ORDER BY `unit` DESC [ RunTime:0.000874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441358 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441358 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='ADP06050R5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06050R5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441358 AND `partno` = 'ADP06050R5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027286 [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440941 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440941 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440941 ORDER BY `unit` DESC [ RunTime:0.007008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440941 LIMIT 2 [ RunTime:0.001582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440941 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='ADP06040R5' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06040R5' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.002071s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440941 AND `partno` = 'ADP06040R5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.001968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274716 [ RunTime:0.000647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58362513 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58362513 ORDER BY `minOrder` ASC [ RunTime:0.004332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58362513 ORDER BY `unit` DESC [ RunTime:0.007956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58362513 LIMIT 2 [ RunTime:0.003750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58362513 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='ADP06S04' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06S04' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004017s ]
SELECT `id` FROM `stock` WHERE `id` <> 58362513 AND `partno` = 'ADP06S04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58362196 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58362196 ORDER BY `minOrder` ASC [ RunTime:0.001186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58362196 ORDER BY `unit` DESC [ RunTime:0.007169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58362196 LIMIT 2 [ RunTime:0.004845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58362196 ORDER BY `minOrder` ASC [ RunTime:0.002438s ]
select * from pdf where partno='ADP0604' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP0604' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003022s ]
SELECT `id` FROM `stock` WHERE `id` <> 58362196 AND `partno` = 'ADP0604' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58361838 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361838 ORDER BY `minOrder` ASC [ RunTime:0.003500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58361838 ORDER BY `unit` DESC [ RunTime:0.012194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58361838 LIMIT 2 [ RunTime:0.002061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361838 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='ADP06SA' and brandshort='TE Connectivity ALCOSWITCH Switches' limit 1 [ RunTime:0.005726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06SA' OR `brand` LIKE 'TE Connectivity ALCOSWITCH Switches%' ) ) LIMIT 1 [ RunTime:0.002212s ]
SELECT `id` FROM `stock` WHERE `id` <> 58361838 AND `partno` = 'ADP06SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity alcoswitch switches%' ) [ RunTime:0.002100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569167 [ RunTime:0.000840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58361779 LIMIT 5 [ RunTime:0.007285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361779 ORDER BY `minOrder` ASC [ RunTime:0.004414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58361779 ORDER BY `unit` DESC [ RunTime:0.014412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58361779 LIMIT 2 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361779 ORDER BY `minOrder` ASC [ RunTime:0.009764s ]
select * from pdf where partno='ADP06S' and brandshort='TE Connectivity ALCOSWITCH Switches' limit 1 [ RunTime:0.010549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06S' OR `brand` LIKE 'TE Connectivity ALCOSWITCH Switches%' ) ) LIMIT 1 [ RunTime:0.004258s ]
SELECT `id` FROM `stock` WHERE `id` <> 58361779 AND `partno` = 'ADP06S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity alcoswitch switches%' ) [ RunTime:0.001798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569122 [ RunTime:0.001018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58361769 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361769 ORDER BY `minOrder` ASC [ RunTime:0.003550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58361769 ORDER BY `unit` DESC [ RunTime:0.011775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58361769 LIMIT 2 [ RunTime:0.001795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361769 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
select * from pdf where partno='ADP06STR04' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06STR04' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004217s ]
SELECT `id` FROM `stock` WHERE `id` <> 58361769 AND `partno` = 'ADP06STR04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58361634 LIMIT 5 [ RunTime:0.003806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361634 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58361634 ORDER BY `unit` DESC [ RunTime:0.012887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58361634 LIMIT 2 [ RunTime:0.002383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58361634 ORDER BY `minOrder` ASC [ RunTime:0.006614s ]
select * from pdf where partno='ADP06' and brandshort='TE Connectivity ALCOSWITCH Switches' limit 1 [ RunTime:0.002894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ADP06' OR `brand` LIKE 'TE Connectivity ALCOSWITCH Switches%' ) ) LIMIT 1 [ RunTime:0.001850s ]
SELECT `id` FROM `stock` WHERE `id` <> 58361634 AND `partno` = 'ADP06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity alcoswitch switches%' ) [ RunTime:0.002727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569038 [ RunTime:0.002542s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002948s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004280s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004032s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003265s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003578s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006194s ]
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 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002069s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ADP06%' OR `brand` LIKE 'ADP06%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002964s ]