SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001463s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.48' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=4134&search=1' [ RunTime:0.016240s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002097s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001606s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.48' ) [ RunTime:0.033181s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001180s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008494s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001980s ]
SELECT * FROM `stock_search` WHERE `partno` = '4134' LIMIT 1 [ RunTime:0.028974s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-30 16:38:17' WHERE `partno` = '4134' [ RunTime:0.008155s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004027s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039839s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581256 LIMIT 5 [ RunTime:0.049938s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581256 ORDER BY `minOrder` ASC [ RunTime:0.029285s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19581256 ORDER BY `unit` DESC [ RunTime:0.027629s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19581256 LIMIT 2 [ RunTime:0.045768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581256 ORDER BY `minOrder` ASC [ RunTime:0.040145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513125 LIMIT 5 [ RunTime:0.051443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513125 ORDER BY `minOrder` ASC [ RunTime:0.042939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513125 ORDER BY `unit` DESC [ RunTime:0.045020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513125 LIMIT 2 [ RunTime:0.019366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513125 ORDER BY `minOrder` ASC [ RunTime:0.003394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400674 LIMIT 5 [ RunTime:0.077355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400674 ORDER BY `minOrder` ASC [ RunTime:0.077541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400674 ORDER BY `unit` DESC [ RunTime:0.020896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400674 LIMIT 2 [ RunTime:0.090233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400674 ORDER BY `minOrder` ASC [ RunTime:0.019467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16416322 LIMIT 5 [ RunTime:0.064836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16416322 ORDER BY `minOrder` ASC [ RunTime:0.055463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16416322 ORDER BY `unit` DESC [ RunTime:0.037330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16416322 LIMIT 2 [ RunTime:0.065422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16416322 ORDER BY `minOrder` ASC [ RunTime:0.043162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348020 LIMIT 5 [ RunTime:0.036329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348020 ORDER BY `minOrder` ASC [ RunTime:0.032089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348020 ORDER BY `unit` DESC [ RunTime:0.035318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348020 LIMIT 2 [ RunTime:0.028488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348020 ORDER BY `minOrder` ASC [ RunTime:0.013701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968949 LIMIT 5 [ RunTime:0.015577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16968949 ORDER BY `minOrder` ASC [ RunTime:0.036561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16968949 ORDER BY `unit` DESC [ RunTime:0.023555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16968949 LIMIT 2 [ RunTime:0.003162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16968949 ORDER BY `minOrder` ASC [ RunTime:0.002299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989042 LIMIT 5 [ RunTime:0.017439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989042 ORDER BY `minOrder` ASC [ RunTime:0.014132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989042 ORDER BY `unit` DESC [ RunTime:0.003806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989042 LIMIT 2 [ RunTime:0.015653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989042 ORDER BY `minOrder` ASC [ RunTime:0.012666s ]
select * from pdf where partno='4134PA51H01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.011416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425916 LIMIT 5 [ RunTime:0.005535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425916 ORDER BY `minOrder` ASC [ RunTime:0.002006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14425916 ORDER BY `unit` DESC [ RunTime:0.024671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14425916 LIMIT 2 [ RunTime:0.008519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14425916 ORDER BY `minOrder` ASC [ RunTime:0.003654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424533 LIMIT 5 [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424533 ORDER BY `minOrder` ASC [ RunTime:0.009996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424533 ORDER BY `unit` DESC [ RunTime:0.012452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424533 LIMIT 2 [ RunTime:0.014651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424533 ORDER BY `minOrder` ASC [ RunTime:0.004306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344768 LIMIT 5 [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344768 ORDER BY `minOrder` ASC [ RunTime:0.004448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14344768 ORDER BY `unit` DESC [ RunTime:0.008900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14344768 LIMIT 2 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14344768 ORDER BY `minOrder` ASC [ RunTime:0.004838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459814 LIMIT 5 [ RunTime:0.004958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459814 ORDER BY `minOrder` ASC [ RunTime:0.007331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459814 ORDER BY `unit` DESC [ RunTime:0.009082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459814 LIMIT 2 [ RunTime:0.017108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459814 ORDER BY `minOrder` ASC [ RunTime:0.002853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459659 LIMIT 5 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459659 ORDER BY `minOrder` ASC [ RunTime:0.004188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459659 ORDER BY `unit` DESC [ RunTime:0.001821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459659 LIMIT 2 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459659 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459480 LIMIT 5 [ RunTime:0.002522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459480 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459480 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459480 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459480 ORDER BY `minOrder` ASC [ RunTime:0.002846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457824 LIMIT 5 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457824 ORDER BY `minOrder` ASC [ RunTime:0.006095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457824 ORDER BY `unit` DESC [ RunTime:0.010239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457824 LIMIT 2 [ RunTime:0.008469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457824 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457634 LIMIT 5 [ RunTime:0.009784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457634 ORDER BY `minOrder` ASC [ RunTime:0.009187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457634 ORDER BY `unit` DESC [ RunTime:0.000909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457634 LIMIT 2 [ RunTime:0.006604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457634 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262618 LIMIT 5 [ RunTime:0.001269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262618 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13262618 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13262618 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262618 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
select * from pdf where partno='4134PA51H01200' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.002009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262434 LIMIT 5 [ RunTime:0.002950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262434 ORDER BY `minOrder` ASC [ RunTime:0.005389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13262434 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13262434 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13262434 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12873317 LIMIT 5 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873317 ORDER BY `minOrder` ASC [ RunTime:0.003381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12873317 ORDER BY `unit` DESC [ RunTime:0.008780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12873317 LIMIT 2 [ RunTime:0.002907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873317 ORDER BY `minOrder` ASC [ RunTime:0.006728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514694 LIMIT 5 [ RunTime:0.001706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514694 ORDER BY `minOrder` ASC [ RunTime:0.007541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12514694 ORDER BY `unit` DESC [ RunTime:0.000497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12514694 LIMIT 2 [ RunTime:0.005165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514694 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989724 LIMIT 5 [ RunTime:0.007406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989724 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989724 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989724 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989724 ORDER BY `minOrder` ASC [ RunTime:0.001899s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131299 LIMIT 5 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131299 ORDER BY `minOrder` ASC [ RunTime:0.016168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131299 ORDER BY `unit` DESC [ RunTime:0.007082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131299 LIMIT 2 [ RunTime:0.005598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131299 ORDER BY `minOrder` ASC [ RunTime:0.000870s ]
select * from pdf where partno='4134pa51h01800' and brandshort='laird technologies' limit 1 [ RunTime:0.010726s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134pa51h01800' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.000513s ]
SELECT `id` FROM `stock` WHERE `id` <> 51131299 AND `partno` = '4134pa51h01800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.003407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989042 [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131192 LIMIT 5 [ RunTime:0.003522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131192 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131192 ORDER BY `unit` DESC [ RunTime:0.010290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131192 LIMIT 2 [ RunTime:0.005481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131192 ORDER BY `minOrder` ASC [ RunTime:0.007091s ]
select * from pdf where partno='4134pa51h09600' and brandshort='laird technologies' limit 1 [ RunTime:0.001832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134pa51h09600' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.000516s ]
SELECT `id` FROM `stock` WHERE `id` <> 51131192 AND `partno` = '4134pa51h09600' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.006755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262434 [ RunTime:0.000242s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60644229 LIMIT 5 [ RunTime:0.005982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644229 ORDER BY `minOrder` ASC [ RunTime:0.007759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60644229 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60644229 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60644229 ORDER BY `minOrder` ASC [ RunTime:0.004112s ]
select * from pdf where partno='41346' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41346' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003700s ]
SELECT `id` FROM `stock` WHERE `id` <> 60644229 AND `partno` = '41346' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513125 [ RunTime:0.007069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60636690 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636690 ORDER BY `minOrder` ASC [ RunTime:0.011222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60636690 ORDER BY `unit` DESC [ RunTime:0.004583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60636690 LIMIT 2 [ RunTime:0.004426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60636690 ORDER BY `minOrder` ASC [ RunTime:0.001421s ]
select * from pdf where partno='41343' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41343' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007987s ]
SELECT `id` FROM `stock` WHERE `id` <> 60636690 AND `partno` = '41343' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581256 [ RunTime:0.002663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63155117 LIMIT 5 [ RunTime:0.006491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63155117 ORDER BY `minOrder` ASC [ RunTime:0.001316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63155117 ORDER BY `unit` DESC [ RunTime:0.009880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63155117 LIMIT 2 [ RunTime:0.006517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63155117 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
select * from pdf where partno='413464-000' and brandshort='TE Connectivity' limit 1 [ RunTime:0.017141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '413464-000' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.020698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58341262 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58341262 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58341262 ORDER BY `unit` DESC [ RunTime:0.006739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58341262 LIMIT 2 [ RunTime:0.015807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58341262 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
select * from pdf where partno='413402000' and brandshort='C&K' limit 1 [ RunTime:0.003115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '413402000' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.019974s ]
SELECT `id` FROM `stock` WHERE `id` <> 58341262 AND `partno` = '413402000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.014104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64415861 LIMIT 5 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415861 ORDER BY `minOrder` ASC [ RunTime:0.004799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64415861 ORDER BY `unit` DESC [ RunTime:0.009463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64415861 LIMIT 2 [ RunTime:0.013991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64415861 ORDER BY `minOrder` ASC [ RunTime:0.018002s ]
select * from pdf where partno='4134PA51H01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.004640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134PA51H01800' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.017235s ]
SELECT `id` FROM `stock` WHERE `id` <> 64415861 AND `partno` = '4134PA51H01800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.029642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989042 [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64557834 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64557834 ORDER BY `minOrder` ASC [ RunTime:0.001280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64557834 ORDER BY `unit` DESC [ RunTime:0.003632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64557834 LIMIT 2 [ RunTime:0.003594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64557834 ORDER BY `minOrder` ASC [ RunTime:0.019187s ]
select * from pdf where partno='4134CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001181s ]
SELECT `id` FROM `stock` WHERE `id` <> 64557834 AND `partno` = '4134CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348020 [ RunTime:0.017843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60993482 LIMIT 5 [ RunTime:0.027901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60993482 ORDER BY `minOrder` ASC [ RunTime:0.017185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60993482 ORDER BY `unit` DESC [ RunTime:0.027409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60993482 LIMIT 2 [ RunTime:0.018165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60993482 ORDER BY `minOrder` ASC [ RunTime:0.010829s ]
select * from pdf where partno='413468-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.002227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '413468-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.027238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64534731 LIMIT 5 [ RunTime:0.010394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64534731 ORDER BY `minOrder` ASC [ RunTime:0.024109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64534731 ORDER BY `unit` DESC [ RunTime:0.026338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64534731 LIMIT 2 [ RunTime:0.007021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64534731 ORDER BY `minOrder` ASC [ RunTime:0.021027s ]
select * from pdf where partno='41349' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41349' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.034398s ]
SELECT `id` FROM `stock` WHERE `id` <> 64534731 AND `partno` = '41349' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.042663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14425916 [ RunTime:0.017940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64532213 LIMIT 5 [ RunTime:0.032273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64532213 ORDER BY `minOrder` ASC [ RunTime:0.047372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64532213 ORDER BY `unit` DESC [ RunTime:0.023671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64532213 LIMIT 2 [ RunTime:0.023174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64532213 ORDER BY `minOrder` ASC [ RunTime:0.018270s ]
select * from pdf where partno='41348' and brandshort='Brady Corporation' limit 1 [ RunTime:0.041184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41348' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.041317s ]
SELECT `id` FROM `stock` WHERE `id` <> 64532213 AND `partno` = '41348' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424533 [ RunTime:0.027081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520622 LIMIT 5 [ RunTime:0.020757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520622 ORDER BY `minOrder` ASC [ RunTime:0.041015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520622 ORDER BY `unit` DESC [ RunTime:0.078182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520622 LIMIT 2 [ RunTime:0.012652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520622 ORDER BY `minOrder` ASC [ RunTime:0.023097s ]
select * from pdf where partno='4134-G' and brandshort='Brady Corporation' limit 1 [ RunTime:0.043481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-G' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017518s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520622 AND `partno` = '4134-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457824 [ RunTime:0.051646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520470 LIMIT 5 [ RunTime:0.028505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520470 ORDER BY `minOrder` ASC [ RunTime:0.024513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520470 ORDER BY `unit` DESC [ RunTime:0.025175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520470 LIMIT 2 [ RunTime:0.033355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520470 ORDER BY `minOrder` ASC [ RunTime:0.021700s ]
select * from pdf where partno='4134-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.049538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.065868s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520470 AND `partno` = '4134-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344768 [ RunTime:0.021393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520242 LIMIT 5 [ RunTime:0.016439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520242 ORDER BY `minOrder` ASC [ RunTime:0.034556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520242 ORDER BY `unit` DESC [ RunTime:0.014724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520242 LIMIT 2 [ RunTime:0.015412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520242 ORDER BY `minOrder` ASC [ RunTime:0.024886s ]
select * from pdf where partno='4134-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.020782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.025722s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520242 AND `partno` = '4134-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.027374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457634 [ RunTime:0.016215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520081 LIMIT 5 [ RunTime:0.056607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520081 ORDER BY `minOrder` ASC [ RunTime:0.019317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520081 ORDER BY `unit` DESC [ RunTime:0.017977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520081 LIMIT 2 [ RunTime:0.025270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520081 ORDER BY `minOrder` ASC [ RunTime:0.005418s ]
select * from pdf where partno='4134-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.020550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015655s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520081 AND `partno` = '4134-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459814 [ RunTime:0.024412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64519934 LIMIT 5 [ RunTime:0.062398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64519934 ORDER BY `minOrder` ASC [ RunTime:0.035187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64519934 ORDER BY `unit` DESC [ RunTime:0.020157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64519934 LIMIT 2 [ RunTime:0.019118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64519934 ORDER BY `minOrder` ASC [ RunTime:0.011499s ]
select * from pdf where partno='4134-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.057365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.038307s ]
SELECT `id` FROM `stock` WHERE `id` <> 64519934 AND `partno` = '4134-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.066402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459659 [ RunTime:0.031312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64519664 LIMIT 5 [ RunTime:0.040198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64519664 ORDER BY `minOrder` ASC [ RunTime:0.055738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64519664 ORDER BY `unit` DESC [ RunTime:0.019271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64519664 LIMIT 2 [ RunTime:0.037426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64519664 ORDER BY `minOrder` ASC [ RunTime:0.046645s ]
select * from pdf where partno='4134-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.071738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016403s ]
SELECT `id` FROM `stock` WHERE `id` <> 64519664 AND `partno` = '4134-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.032433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459480 [ RunTime:0.079062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64418909 LIMIT 5 [ RunTime:0.031005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418909 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64418909 ORDER BY `unit` DESC [ RunTime:0.009207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64418909 LIMIT 2 [ RunTime:0.012579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418909 ORDER BY `minOrder` ASC [ RunTime:0.011267s ]
select * from pdf where partno='4134PA51H09600' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.016001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134PA51H09600' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.012083s ]
SELECT `id` FROM `stock` WHERE `id` <> 64418909 AND `partno` = '4134PA51H09600' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.009422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13262434 [ RunTime:0.014894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64418650 LIMIT 5 [ RunTime:0.019033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418650 ORDER BY `minOrder` ASC [ RunTime:0.047680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64418650 ORDER BY `unit` DESC [ RunTime:0.024521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64418650 LIMIT 2 [ RunTime:0.029458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418650 ORDER BY `minOrder` ASC [ RunTime:0.008814s ]
select * from pdf where partno='4134PAX1R03937' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.038428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134PAX1R03937' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.054741s ]
SELECT `id` FROM `stock` WHERE `id` <> 64418650 AND `partno` = '4134PAX1R03937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.053377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989724 [ RunTime:0.028684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64418541 LIMIT 5 [ RunTime:0.028376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418541 ORDER BY `minOrder` ASC [ RunTime:0.022487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64418541 ORDER BY `unit` DESC [ RunTime:0.024764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64418541 LIMIT 2 [ RunTime:0.016302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418541 ORDER BY `minOrder` ASC [ RunTime:0.003074s ]
select * from pdf where partno='4134PA51H03937' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.005301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134PA51H03937' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.016027s ]
SELECT `id` FROM `stock` WHERE `id` <> 64418541 AND `partno` = '4134PA51H03937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.037319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989648 [ RunTime:0.025491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64418265 LIMIT 5 [ RunTime:0.061098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418265 ORDER BY `minOrder` ASC [ RunTime:0.015040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64418265 ORDER BY `unit` DESC [ RunTime:0.003953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64418265 LIMIT 2 [ RunTime:0.027909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64418265 ORDER BY `minOrder` ASC [ RunTime:0.023795s ]
select * from pdf where partno='4134PA51G01800' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.024051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134PA51G01800' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.017478s ]
SELECT `id` FROM `stock` WHERE `id` <> 64418265 AND `partno` = '4134PA51G01800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.026360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989565 [ RunTime:0.017314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63412853 LIMIT 5 [ RunTime:0.012605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63412853 ORDER BY `minOrder` ASC [ RunTime:0.010790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63412853 ORDER BY `unit` DESC [ RunTime:0.017907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63412853 LIMIT 2 [ RunTime:0.013956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63412853 ORDER BY `minOrder` ASC [ RunTime:0.020464s ]
select * from pdf where partno='4134-BLACK-HW' and brandshort='80/20, LLC' limit 1 [ RunTime:0.018932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4134-BLACK-HW' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.015552s ]
SELECT `id` FROM `stock` WHERE `id` <> 63412853 AND `partno` = '4134-BLACK-HW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.008122s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014170s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012468s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001992s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001486s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015418s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011019s ]
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 '4134%' OR `brand` LIKE '4134%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027945s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4134%' OR `brand` LIKE '4134%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003054s ]