SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002282s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042366s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518957 LIMIT 5 [ RunTime:0.018941s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518957 ORDER BY `minOrder` ASC [ RunTime:0.010819s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12518957 ORDER BY `unit` DESC [ RunTime:0.015956s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12518957 LIMIT 2 [ RunTime:0.023759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12518957 ORDER BY `minOrder` ASC [ RunTime:0.032415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532741 LIMIT 5 [ RunTime:0.024662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532741 ORDER BY `minOrder` ASC [ RunTime:0.008221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13532741 ORDER BY `unit` DESC [ RunTime:0.008675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13532741 LIMIT 2 [ RunTime:0.007788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532741 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16416802 LIMIT 5 [ RunTime:0.008866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16416802 ORDER BY `minOrder` ASC [ RunTime:0.013082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16416802 ORDER BY `unit` DESC [ RunTime:0.002850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16416802 LIMIT 2 [ RunTime:0.004734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16416802 ORDER BY `minOrder` ASC [ RunTime:0.003911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14402584 LIMIT 5 [ RunTime:0.009678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14402584 ORDER BY `minOrder` ASC [ RunTime:0.004797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14402584 ORDER BY `unit` DESC [ RunTime:0.011692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14402584 LIMIT 2 [ RunTime:0.008622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14402584 ORDER BY `minOrder` ASC [ RunTime:0.002693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14402580 LIMIT 5 [ RunTime:0.014099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14402580 ORDER BY `minOrder` ASC [ RunTime:0.036002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14402580 ORDER BY `unit` DESC [ RunTime:0.027189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14402580 LIMIT 2 [ RunTime:0.016438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14402580 ORDER BY `minOrder` ASC [ RunTime:0.009698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149725 LIMIT 5 [ RunTime:0.039936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149725 ORDER BY `minOrder` ASC [ RunTime:0.012830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149725 ORDER BY `unit` DESC [ RunTime:0.050510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149725 LIMIT 2 [ RunTime:0.003960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149725 ORDER BY `minOrder` ASC [ RunTime:0.003657s ]
select * from pdf where partno='1505740000' and brandshort='Weidmüller' limit 1 [ RunTime:0.037488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14700517 LIMIT 5 [ RunTime:0.039258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14700517 ORDER BY `minOrder` ASC [ RunTime:0.023154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14700517 ORDER BY `unit` DESC [ RunTime:0.060879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14700517 LIMIT 2 [ RunTime:0.024591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14700517 ORDER BY `minOrder` ASC [ RunTime:0.004518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517003 LIMIT 5 [ RunTime:0.012975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517003 ORDER BY `minOrder` ASC [ RunTime:0.012464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517003 ORDER BY `unit` DESC [ RunTime:0.014495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517003 LIMIT 2 [ RunTime:0.041495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517003 ORDER BY `minOrder` ASC [ RunTime:0.001388s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012159s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640067 LIMIT 5 [ RunTime:0.020182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640067 ORDER BY `minOrder` ASC [ RunTime:0.017205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640067 ORDER BY `unit` DESC [ RunTime:0.004287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640067 LIMIT 2 [ RunTime:0.025368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640067 ORDER BY `minOrder` ASC [ RunTime:0.014650s ]
select * from pdf where partno='150572-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020679s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150572-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020430s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640067 AND `partno` = '150572-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.031091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12518957 [ RunTime:0.012499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60364033 LIMIT 5 [ RunTime:0.016427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364033 ORDER BY `minOrder` ASC [ RunTime:0.007250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60364033 ORDER BY `unit` DESC [ RunTime:0.011704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60364033 LIMIT 2 [ RunTime:0.004036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60364033 ORDER BY `minOrder` ASC [ RunTime:0.002209s ]
select * from pdf where partno='15057064' and brandshort='Molex' limit 1 [ RunTime:0.005044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15057064' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.037107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63109477 LIMIT 5 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109477 ORDER BY `minOrder` ASC [ RunTime:0.004944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63109477 ORDER BY `unit` DESC [ RunTime:0.003403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63109477 LIMIT 2 [ RunTime:0.001567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109477 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='1505770000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1505770000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009065s ]
SELECT `id` FROM `stock` WHERE `id` <> 63109477 AND `partno` = '1505770000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532741 [ RunTime:0.009846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63110918 LIMIT 5 [ RunTime:0.022630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63110918 ORDER BY `minOrder` ASC [ RunTime:0.013223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63110918 ORDER BY `unit` DESC [ RunTime:0.010638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63110918 LIMIT 2 [ RunTime:0.008755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63110918 ORDER BY `minOrder` ASC [ RunTime:0.007169s ]
select * from pdf where partno='1505790000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1505790000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001780s ]
SELECT `id` FROM `stock` WHERE `id` <> 63110918 AND `partno` = '1505790000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16416802 [ RunTime:0.019868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63110904 LIMIT 5 [ RunTime:0.003067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63110904 ORDER BY `minOrder` ASC [ RunTime:0.000937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63110904 ORDER BY `unit` DESC [ RunTime:0.002573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63110904 LIMIT 2 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63110904 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='1505760000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1505760000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001435s ]
SELECT `id` FROM `stock` WHERE `id` <> 63110904 AND `partno` = '1505760000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14402580 [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63110656 LIMIT 5 [ RunTime:0.003573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63110656 ORDER BY `minOrder` ASC [ RunTime:0.013526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63110656 ORDER BY `unit` DESC [ RunTime:0.003076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63110656 LIMIT 2 [ RunTime:0.006122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63110656 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='1505780000' and brandshort='Weidmüller' limit 1 [ RunTime:0.006610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1505780000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010798s ]
SELECT `id` FROM `stock` WHERE `id` <> 63110656 AND `partno` = '1505780000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14402584 [ RunTime:0.004128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63462596 LIMIT 5 [ RunTime:0.009347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63462596 ORDER BY `minOrder` ASC [ RunTime:0.005646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63462596 ORDER BY `unit` DESC [ RunTime:0.001956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63462596 LIMIT 2 [ RunTime:0.018985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63462596 ORDER BY `minOrder` ASC [ RunTime:0.009139s ]
select * from pdf where partno='1505730000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1505730000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009975s ]
SELECT `id` FROM `stock` WHERE `id` <> 63462596 AND `partno` = '1505730000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63133963 LIMIT 5 [ RunTime:0.003317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63133963 ORDER BY `minOrder` ASC [ RunTime:0.023756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63133963 ORDER BY `unit` DESC [ RunTime:0.025874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63133963 LIMIT 2 [ RunTime:0.006342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63133963 ORDER BY `minOrder` ASC [ RunTime:0.006398s ]
select * from pdf where partno='15057' and brandshort='Essentra Components' limit 1 [ RunTime:0.012147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15057' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.013716s ]
SELECT `id` FROM `stock` WHERE `id` <> 63133963 AND `partno` = '15057' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.002754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62982362 LIMIT 5 [ RunTime:0.019357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62982362 ORDER BY `minOrder` ASC [ RunTime:0.015682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62982362 ORDER BY `unit` DESC [ RunTime:0.010638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62982362 LIMIT 2 [ RunTime:0.009084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62982362 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
select * from pdf where partno='150579-01' and brandshort='NI' limit 1 [ RunTime:0.006345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150579-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.014845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640783 LIMIT 5 [ RunTime:0.011305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640783 ORDER BY `minOrder` ASC [ RunTime:0.019818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640783 ORDER BY `unit` DESC [ RunTime:0.012321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640783 LIMIT 2 [ RunTime:0.015883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640783 ORDER BY `minOrder` ASC [ RunTime:0.009110s ]
select * from pdf where partno='150571-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150571-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016329s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640783 AND `partno` = '150571-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517003 [ RunTime:0.006477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60549106 LIMIT 5 [ RunTime:0.013406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60549106 ORDER BY `minOrder` ASC [ RunTime:0.004966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60549106 ORDER BY `unit` DESC [ RunTime:0.007005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60549106 LIMIT 2 [ RunTime:0.004852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60549106 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
select * from pdf where partno='1505740000' and brandshort='Weidmüller' limit 1 [ RunTime:0.028851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1505740000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.046987s ]
SELECT `id` FROM `stock` WHERE `id` <> 60549106 AND `partno` = '1505740000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.044932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149725 [ RunTime:0.031413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350947 LIMIT 5 [ RunTime:0.026199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350947 ORDER BY `minOrder` ASC [ RunTime:0.025654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350947 ORDER BY `unit` DESC [ RunTime:0.023611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350947 LIMIT 2 [ RunTime:0.025236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350947 ORDER BY `minOrder` ASC [ RunTime:0.041968s ]
select * from pdf where partno='15057' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.005678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15057' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.031200s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350947 AND `partno` = '15057' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.011751s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020582s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014287s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011554s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026723s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018943s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003576s ]
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 '15057%' OR `brand` LIKE '15057%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017084s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15057%' OR `brand` LIKE '15057%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019272s ]