SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001338s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018182s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16492132 LIMIT 5 [ RunTime:0.014990s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16492132 ORDER BY `minOrder` ASC [ RunTime:0.017853s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16492132 ORDER BY `unit` DESC [ RunTime:0.028279s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16492132 LIMIT 2 [ RunTime:0.032303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16492132 ORDER BY `minOrder` ASC [ RunTime:0.043180s ]
select * from pdf where partno='UTP6A1.5MGR-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.014902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16492131 LIMIT 5 [ RunTime:0.029755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16492131 ORDER BY `minOrder` ASC [ RunTime:0.029489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16492131 ORDER BY `unit` DESC [ RunTime:0.019038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16492131 LIMIT 2 [ RunTime:0.014158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16492131 ORDER BY `minOrder` ASC [ RunTime:0.007386s ]
select * from pdf where partno='UTP6A1.5MBU-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.021624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16492130 LIMIT 5 [ RunTime:0.050515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16492130 ORDER BY `minOrder` ASC [ RunTime:0.048587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16492130 ORDER BY `unit` DESC [ RunTime:0.036009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16492130 LIMIT 2 [ RunTime:0.007651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16492130 ORDER BY `minOrder` ASC [ RunTime:0.021456s ]
select * from pdf where partno='UTP6A1.5MBL-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.036156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14511903 LIMIT 5 [ RunTime:0.034015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14511903 ORDER BY `minOrder` ASC [ RunTime:0.115995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14511903 ORDER BY `unit` DESC [ RunTime:0.042538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14511903 LIMIT 2 [ RunTime:0.012486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14511903 ORDER BY `minOrder` ASC [ RunTime:0.024872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499916 LIMIT 5 [ RunTime:0.061228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499916 ORDER BY `minOrder` ASC [ RunTime:0.119627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499916 ORDER BY `unit` DESC [ RunTime:0.040651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499916 LIMIT 2 [ RunTime:0.105442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499916 ORDER BY `minOrder` ASC [ RunTime:0.035484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499632 LIMIT 5 [ RunTime:0.061122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499632 ORDER BY `minOrder` ASC [ RunTime:0.011671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499632 ORDER BY `unit` DESC [ RunTime:0.043896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499632 LIMIT 2 [ RunTime:0.029152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499632 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='UTP6A1.5MYL-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.044342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499631 LIMIT 5 [ RunTime:0.014546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499631 ORDER BY `minOrder` ASC [ RunTime:0.059802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499631 ORDER BY `unit` DESC [ RunTime:0.077254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499631 LIMIT 2 [ RunTime:0.031228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499631 ORDER BY `minOrder` ASC [ RunTime:0.028280s ]
select * from pdf where partno='UTP6A1.5MRD-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.044801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499630 LIMIT 5 [ RunTime:0.072503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499630 ORDER BY `minOrder` ASC [ RunTime:0.076717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499630 ORDER BY `unit` DESC [ RunTime:0.046001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499630 LIMIT 2 [ RunTime:0.025276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499630 ORDER BY `minOrder` ASC [ RunTime:0.014836s ]
select * from pdf where partno='UTP6A1.5M-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499629 LIMIT 5 [ RunTime:0.035059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499629 ORDER BY `minOrder` ASC [ RunTime:0.019966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14499629 ORDER BY `unit` DESC [ RunTime:0.109460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14499629 LIMIT 2 [ RunTime:0.042598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14499629 ORDER BY `minOrder` ASC [ RunTime:0.028884s ]
select * from pdf where partno='UTP6A1.5MGY-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.018775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631641 LIMIT 5 [ RunTime:0.034336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631641 ORDER BY `minOrder` ASC [ RunTime:0.010153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631641 ORDER BY `unit` DESC [ RunTime:0.013952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631641 LIMIT 2 [ RunTime:0.025602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631641 ORDER BY `minOrder` ASC [ RunTime:0.033961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631640 LIMIT 5 [ RunTime:0.021135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631640 ORDER BY `minOrder` ASC [ RunTime:0.030614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631640 ORDER BY `unit` DESC [ RunTime:0.059709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631640 LIMIT 2 [ RunTime:0.027923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631640 ORDER BY `minOrder` ASC [ RunTime:0.042840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631639 LIMIT 5 [ RunTime:0.041694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631639 ORDER BY `minOrder` ASC [ RunTime:0.016590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631639 ORDER BY `unit` DESC [ RunTime:0.023527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631639 LIMIT 2 [ RunTime:0.033993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631639 ORDER BY `minOrder` ASC [ RunTime:0.013875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631638 LIMIT 5 [ RunTime:0.007314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631638 ORDER BY `minOrder` ASC [ RunTime:0.027244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631638 ORDER BY `unit` DESC [ RunTime:0.040861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631638 LIMIT 2 [ RunTime:0.028284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631638 ORDER BY `minOrder` ASC [ RunTime:0.031354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631637 LIMIT 5 [ RunTime:0.018142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631637 ORDER BY `minOrder` ASC [ RunTime:0.033493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631637 ORDER BY `unit` DESC [ RunTime:0.025499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631637 LIMIT 2 [ RunTime:0.018788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631637 ORDER BY `minOrder` ASC [ RunTime:0.005227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631426 LIMIT 5 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631426 ORDER BY `minOrder` ASC [ RunTime:0.025041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631426 ORDER BY `unit` DESC [ RunTime:0.031289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631426 LIMIT 2 [ RunTime:0.043051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631426 ORDER BY `minOrder` ASC [ RunTime:0.009863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631425 LIMIT 5 [ RunTime:0.021612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631425 ORDER BY `minOrder` ASC [ RunTime:0.017436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631425 ORDER BY `unit` DESC [ RunTime:0.022855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631425 LIMIT 2 [ RunTime:0.046960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631425 ORDER BY `minOrder` ASC [ RunTime:0.005320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631424 LIMIT 5 [ RunTime:0.028770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631424 ORDER BY `minOrder` ASC [ RunTime:0.015534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631424 ORDER BY `unit` DESC [ RunTime:0.015717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631424 LIMIT 2 [ RunTime:0.020287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631424 ORDER BY `minOrder` ASC [ RunTime:0.006068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631327 LIMIT 5 [ RunTime:0.023512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631327 ORDER BY `minOrder` ASC [ RunTime:0.028917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13631327 ORDER BY `unit` DESC [ RunTime:0.046043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13631327 LIMIT 2 [ RunTime:0.052252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13631327 ORDER BY `minOrder` ASC [ RunTime:0.016631s ]
select * from pdf where partno='UTP6A1.5MOR-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.011668s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018476s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395937 LIMIT 5 [ RunTime:0.015751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395937 ORDER BY `minOrder` ASC [ RunTime:0.047102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395937 ORDER BY `unit` DESC [ RunTime:0.029140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395937 LIMIT 2 [ RunTime:0.063543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395937 ORDER BY `minOrder` ASC [ RunTime:0.073951s ]
select * from pdf where partno='UTP6A1.5MVL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.051372s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MVL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.029902s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395937 AND `partno` = 'UTP6A1.5MVL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.036744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499916 [ RunTime:0.016507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395936 LIMIT 5 [ RunTime:0.023310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395936 ORDER BY `minOrder` ASC [ RunTime:0.067022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395936 ORDER BY `unit` DESC [ RunTime:0.027983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395936 LIMIT 2 [ RunTime:0.051047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395936 ORDER BY `minOrder` ASC [ RunTime:0.022203s ]
select * from pdf where partno='UTP6A1.5MOR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.027450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MOR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.036706s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395936 AND `partno` = 'UTP6A1.5MOR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.071205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631641 [ RunTime:0.041578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395935 LIMIT 5 [ RunTime:0.021266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395935 ORDER BY `minOrder` ASC [ RunTime:0.024450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395935 ORDER BY `unit` DESC [ RunTime:0.047072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395935 LIMIT 2 [ RunTime:0.013150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395935 ORDER BY `minOrder` ASC [ RunTime:0.017797s ]
select * from pdf where partno='UTP6A1.5MGY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MGY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.014001s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395935 AND `partno` = 'UTP6A1.5MGY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.024880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631640 [ RunTime:0.008425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395934 LIMIT 5 [ RunTime:0.034497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395934 ORDER BY `minOrder` ASC [ RunTime:0.018933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395934 ORDER BY `unit` DESC [ RunTime:0.016522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395934 LIMIT 2 [ RunTime:0.049373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395934 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='UTP6A1.5MBU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.018673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MBU' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.017439s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395934 AND `partno` = 'UTP6A1.5MBU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.042505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631639 [ RunTime:0.011693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395933 LIMIT 5 [ RunTime:0.039282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395933 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395933 ORDER BY `unit` DESC [ RunTime:0.011943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395933 LIMIT 2 [ RunTime:0.009033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395933 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
select * from pdf where partno='UTP6A1.5MBL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.012409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MBL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003295s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395933 AND `partno` = 'UTP6A1.5MBL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631638 [ RunTime:0.004570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395932 LIMIT 5 [ RunTime:0.009370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395932 ORDER BY `minOrder` ASC [ RunTime:0.009975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395932 ORDER BY `unit` DESC [ RunTime:0.022099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395932 LIMIT 2 [ RunTime:0.037878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395932 ORDER BY `minOrder` ASC [ RunTime:0.014069s ]
select * from pdf where partno='UTP6A1.5M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.024316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001123s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395932 AND `partno` = 'UTP6A1.5M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.020465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631637 [ RunTime:0.035813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395372 LIMIT 5 [ RunTime:0.018878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395372 ORDER BY `minOrder` ASC [ RunTime:0.039125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395372 ORDER BY `unit` DESC [ RunTime:0.011953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395372 LIMIT 2 [ RunTime:0.028493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395372 ORDER BY `minOrder` ASC [ RunTime:0.010178s ]
select * from pdf where partno='UTP6A1.5MYL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.029936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MYL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007222s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395372 AND `partno` = 'UTP6A1.5MYL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.005637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631426 [ RunTime:0.010016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395371 LIMIT 5 [ RunTime:0.024484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395371 ORDER BY `minOrder` ASC [ RunTime:0.019995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395371 ORDER BY `unit` DESC [ RunTime:0.008940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395371 LIMIT 2 [ RunTime:0.035349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395371 ORDER BY `minOrder` ASC [ RunTime:0.040443s ]
select * from pdf where partno='UTP6A1.5MRD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.019158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MRD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.018658s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395371 AND `partno` = 'UTP6A1.5MRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.073525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631425 [ RunTime:0.043922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395370 LIMIT 5 [ RunTime:0.026618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395370 ORDER BY `minOrder` ASC [ RunTime:0.019866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395370 ORDER BY `unit` DESC [ RunTime:0.032073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395370 LIMIT 2 [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395370 ORDER BY `minOrder` ASC [ RunTime:0.014804s ]
select * from pdf where partno='UTP6A1.5MGR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.010415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MGR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.020373s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395370 AND `partno` = 'UTP6A1.5MGR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.019433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631424 [ RunTime:0.025862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395145 LIMIT 5 [ RunTime:0.027906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395145 ORDER BY `minOrder` ASC [ RunTime:0.014327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395145 ORDER BY `unit` DESC [ RunTime:0.026038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395145 LIMIT 2 [ RunTime:0.011242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395145 ORDER BY `minOrder` ASC [ RunTime:0.001934s ]
select * from pdf where partno='UTP6A1.5MYL-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MYL-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.002320s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395145 AND `partno` = 'UTP6A1.5MYL-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.007358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499632 [ RunTime:0.006856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395144 LIMIT 5 [ RunTime:0.002534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395144 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395144 ORDER BY `unit` DESC [ RunTime:0.003263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395144 LIMIT 2 [ RunTime:0.015108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395144 ORDER BY `minOrder` ASC [ RunTime:0.008449s ]
select * from pdf where partno='UTP6A1.5MRD-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MRD-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000962s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395144 AND `partno` = 'UTP6A1.5MRD-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.009852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499631 [ RunTime:0.008649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395143 LIMIT 5 [ RunTime:0.007330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395143 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395143 ORDER BY `unit` DESC [ RunTime:0.001334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395143 LIMIT 2 [ RunTime:0.006821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395143 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='UTP6A1.5M-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5M-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.008280s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395143 AND `partno` = 'UTP6A1.5M-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.011306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499630 [ RunTime:0.003895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395142 LIMIT 5 [ RunTime:0.021087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395142 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395142 ORDER BY `unit` DESC [ RunTime:0.022859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395142 LIMIT 2 [ RunTime:0.014452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395142 ORDER BY `minOrder` ASC [ RunTime:0.019164s ]
select * from pdf where partno='UTP6A1.5MOR-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MOR-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.011198s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395142 AND `partno` = 'UTP6A1.5MOR-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.012692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13631327 [ RunTime:0.029982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395141 LIMIT 5 [ RunTime:0.013409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395141 ORDER BY `minOrder` ASC [ RunTime:0.004650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395141 ORDER BY `unit` DESC [ RunTime:0.015707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395141 LIMIT 2 [ RunTime:0.012771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395141 ORDER BY `minOrder` ASC [ RunTime:0.001593s ]
select * from pdf where partno='UTP6A1.5MGY-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.003551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MGY-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.045282s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395141 AND `partno` = 'UTP6A1.5MGY-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.022815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14499629 [ RunTime:0.021269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395140 LIMIT 5 [ RunTime:0.018313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395140 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395140 ORDER BY `unit` DESC [ RunTime:0.006294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395140 LIMIT 2 [ RunTime:0.014498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395140 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
select * from pdf where partno='UTP6A1.5MGR-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MGR-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.014618s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395140 AND `partno` = 'UTP6A1.5MGR-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.023834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16492132 [ RunTime:0.002398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395139 LIMIT 5 [ RunTime:0.016852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395139 ORDER BY `minOrder` ASC [ RunTime:0.034040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395139 ORDER BY `unit` DESC [ RunTime:0.022623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395139 LIMIT 2 [ RunTime:0.005304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395139 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
select * from pdf where partno='UTP6A1.5MBU-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MBU-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.012543s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395139 AND `partno` = 'UTP6A1.5MBU-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.016362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16492131 [ RunTime:0.021629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62395138 LIMIT 5 [ RunTime:0.020171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395138 ORDER BY `minOrder` ASC [ RunTime:0.009776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62395138 ORDER BY `unit` DESC [ RunTime:0.006374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62395138 LIMIT 2 [ RunTime:0.012673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62395138 ORDER BY `minOrder` ASC [ RunTime:0.014569s ]
select * from pdf where partno='UTP6A1.5MBL-Q' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP6A1.5MBL-Q' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.017968s ]
SELECT `id` FROM `stock` WHERE `id` <> 62395138 AND `partno` = 'UTP6A1.5MBL-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.017890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16492130 [ RunTime:0.010543s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.095199s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112819s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063033s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011337s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035436s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054399s ]
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 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032478s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UTP6A1.5M%' OR `brand` LIKE 'UTP6A1.5M%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029805s ]