SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002196s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010570s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343762 LIMIT 5 [ RunTime:0.008620s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343762 ORDER BY `minOrder` ASC [ RunTime:0.011158s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343762 ORDER BY `unit` DESC [ RunTime:0.020952s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343762 LIMIT 2 [ RunTime:0.016367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343762 ORDER BY `minOrder` ASC [ RunTime:0.013559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343872 LIMIT 5 [ RunTime:0.012102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343872 ORDER BY `minOrder` ASC [ RunTime:0.054618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343872 ORDER BY `unit` DESC [ RunTime:0.029055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343872 LIMIT 2 [ RunTime:0.012401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343872 ORDER BY `minOrder` ASC [ RunTime:0.032712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426088 LIMIT 5 [ RunTime:0.037016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426088 ORDER BY `minOrder` ASC [ RunTime:0.036734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13426088 ORDER BY `unit` DESC [ RunTime:0.067938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13426088 LIMIT 2 [ RunTime:0.028073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426088 ORDER BY `minOrder` ASC [ RunTime:0.022480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13365494 LIMIT 5 [ RunTime:0.042685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13365494 ORDER BY `minOrder` ASC [ RunTime:0.058540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13365494 ORDER BY `unit` DESC [ RunTime:0.029768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13365494 LIMIT 2 [ RunTime:0.053037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13365494 ORDER BY `minOrder` ASC [ RunTime:0.021213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18761662 LIMIT 5 [ RunTime:0.067685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18761662 ORDER BY `minOrder` ASC [ RunTime:0.041113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18761662 ORDER BY `unit` DESC [ RunTime:0.067922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18761662 LIMIT 2 [ RunTime:0.044594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18761662 ORDER BY `minOrder` ASC [ RunTime:0.076108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15252101 LIMIT 5 [ RunTime:0.024163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15252101 ORDER BY `minOrder` ASC [ RunTime:0.023737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15252101 ORDER BY `unit` DESC [ RunTime:0.033845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15252101 LIMIT 2 [ RunTime:0.071567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15252101 ORDER BY `minOrder` ASC [ RunTime:0.002928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193775 LIMIT 5 [ RunTime:0.053447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193775 ORDER BY `minOrder` ASC [ RunTime:0.032811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193775 ORDER BY `unit` DESC [ RunTime:0.017787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193775 LIMIT 2 [ RunTime:0.062780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193775 ORDER BY `minOrder` ASC [ RunTime:0.011214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193764 LIMIT 5 [ RunTime:0.018152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193764 ORDER BY `minOrder` ASC [ RunTime:0.048818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193764 ORDER BY `unit` DESC [ RunTime:0.011844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193764 LIMIT 2 [ RunTime:0.094727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193764 ORDER BY `minOrder` ASC [ RunTime:0.033683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193017 LIMIT 5 [ RunTime:0.059560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193017 ORDER BY `minOrder` ASC [ RunTime:0.015643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193017 ORDER BY `unit` DESC [ RunTime:0.057894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193017 LIMIT 2 [ RunTime:0.036051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193017 ORDER BY `minOrder` ASC [ RunTime:0.062812s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048725s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64574809 LIMIT 5 [ RunTime:0.061016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574809 ORDER BY `minOrder` ASC [ RunTime:0.045114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64574809 ORDER BY `unit` DESC [ RunTime:0.049903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64574809 LIMIT 2 [ RunTime:0.013136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574809 ORDER BY `minOrder` ASC [ RunTime:0.018507s ]
select * from pdf where partno='80303CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.035576s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80303CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.046595s ]
SELECT `id` FROM `stock` WHERE `id` <> 64574809 AND `partno` = '80303CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.080557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343762 [ RunTime:0.024197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41372016 LIMIT 5 [ RunTime:0.043226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41372016 ORDER BY `minOrder` ASC [ RunTime:0.049921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41372016 ORDER BY `unit` DESC [ RunTime:0.032473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41372016 LIMIT 2 [ RunTime:0.050401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41372016 ORDER BY `minOrder` ASC [ RunTime:0.007004s ]
select * from pdf where partno='8030334500' and brandshort='Dialight' limit 1 [ RunTime:0.077390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8030334500' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.030527s ]
SELECT `id` FROM `stock` WHERE `id` <> 41372016 AND `partno` = '8030334500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.086829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64576025 LIMIT 5 [ RunTime:0.031744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64576025 ORDER BY `minOrder` ASC [ RunTime:0.027632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64576025 ORDER BY `unit` DESC [ RunTime:0.024043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64576025 LIMIT 2 [ RunTime:0.035321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64576025 ORDER BY `minOrder` ASC [ RunTime:0.012467s ]
select * from pdf where partno='80303SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.020281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80303SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.043271s ]
SELECT `id` FROM `stock` WHERE `id` <> 64576025 AND `partno` = '80303SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.125651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343872 [ RunTime:0.017380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40497486 LIMIT 5 [ RunTime:0.059707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40497486 ORDER BY `minOrder` ASC [ RunTime:0.078360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40497486 ORDER BY `unit` DESC [ RunTime:0.036518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40497486 LIMIT 2 [ RunTime:0.038594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40497486 ORDER BY `minOrder` ASC [ RunTime:0.023270s ]
select * from pdf where partno='80303C' and brandshort='Murata Electronics' limit 1 [ RunTime:0.023318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80303C' OR `brand` LIKE 'Murata Electronics%' ) ) LIMIT 1 [ RunTime:0.030039s ]
SELECT `id` FROM `stock` WHERE `id` <> 40497486 AND `partno` = '80303C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata electronics%' ) [ RunTime:0.049621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426088 [ RunTime:0.006218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58572436 LIMIT 5 [ RunTime:0.030239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58572436 ORDER BY `minOrder` ASC [ RunTime:0.047416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58572436 ORDER BY `unit` DESC [ RunTime:0.030765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58572436 LIMIT 2 [ RunTime:0.050917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58572436 ORDER BY `minOrder` ASC [ RunTime:0.074590s ]
select * from pdf where partno='80303' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.030543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80303' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.028576s ]
SELECT `id` FROM `stock` WHERE `id` <> 58572436 AND `partno` = '80303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.022068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193775 [ RunTime:0.093613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58572403 LIMIT 5 [ RunTime:0.078437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58572403 ORDER BY `minOrder` ASC [ RunTime:0.052416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58572403 ORDER BY `unit` DESC [ RunTime:0.028828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58572403 LIMIT 2 [ RunTime:0.080010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58572403 ORDER BY `minOrder` ASC [ RunTime:0.033494s ]
select * from pdf where partno='80303G' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.026505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80303G' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.013526s ]
SELECT `id` FROM `stock` WHERE `id` <> 58572403 AND `partno` = '80303G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.003584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193764 [ RunTime:0.011141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44013568 LIMIT 5 [ RunTime:0.056787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44013568 ORDER BY `minOrder` ASC [ RunTime:0.047925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44013568 ORDER BY `unit` DESC [ RunTime:0.035899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44013568 LIMIT 2 [ RunTime:0.016399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44013568 ORDER BY `minOrder` ASC [ RunTime:0.024193s ]
select * from pdf where partno='803036-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.074625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803036-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.059566s ]
SELECT `id` FROM `stock` WHERE `id` <> 44013568 AND `partno` = '803036-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.018166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18761662 [ RunTime:0.031010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41405049 LIMIT 5 [ RunTime:0.031252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41405049 ORDER BY `minOrder` ASC [ RunTime:0.072256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41405049 ORDER BY `unit` DESC [ RunTime:0.041519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41405049 LIMIT 2 [ RunTime:0.053945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41405049 ORDER BY `minOrder` ASC [ RunTime:0.011035s ]
select * from pdf where partno='8030331500WOLNS' and brandshort='Dialight' limit 1 [ RunTime:0.053486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8030331500WOLNS' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.039542s ]
SELECT `id` FROM `stock` WHERE `id` <> 41405049 AND `partno` = '8030331500WOLNS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.042034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15252101 [ RunTime:0.022044s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007282s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047716s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034670s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075865s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014181s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027365s ]
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 '80303%' OR `brand` LIKE '80303%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079474s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '80303%' OR `brand` LIKE '80303%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016132s ]