SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001387s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=69190&search=1' [ RunTime:0.001808s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001075s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001413s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000286s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001498s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001345s ]
SELECT * FROM `stock_search` WHERE `partno` = '69190' LIMIT 1 [ RunTime:0.000669s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-30 07:23:49' WHERE `partno` = '69190' [ RunTime:0.002185s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001611s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026451s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19813623 LIMIT 5 [ RunTime:0.002206s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19813623 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19813623 ORDER BY `unit` DESC [ RunTime:0.001470s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19813623 LIMIT 2 [ RunTime:0.000967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19813623 ORDER BY `minOrder` ASC [ RunTime:0.003768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847962 LIMIT 5 [ RunTime:0.002901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19847962 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19847962 ORDER BY `unit` DESC [ RunTime:0.014760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19847962 LIMIT 2 [ RunTime:0.001177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19847962 ORDER BY `minOrder` ASC [ RunTime:0.003325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234609 LIMIT 5 [ RunTime:0.001843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234609 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16234609 ORDER BY `unit` DESC [ RunTime:0.007952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16234609 LIMIT 2 [ RunTime:0.007374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16234609 ORDER BY `minOrder` ASC [ RunTime:0.002012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16233844 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16233844 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16233844 ORDER BY `unit` DESC [ RunTime:0.014284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16233844 LIMIT 2 [ RunTime:0.007232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16233844 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485282 LIMIT 5 [ RunTime:0.002531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485282 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15485282 ORDER BY `unit` DESC [ RunTime:0.006293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15485282 LIMIT 2 [ RunTime:0.002639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485282 ORDER BY `minOrder` ASC [ RunTime:0.007944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772398 LIMIT 5 [ RunTime:0.004730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772398 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19772398 ORDER BY `unit` DESC [ RunTime:0.000893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19772398 LIMIT 2 [ RunTime:0.004517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772398 ORDER BY `minOrder` ASC [ RunTime:0.004968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15493658 LIMIT 5 [ RunTime:0.003607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15493658 ORDER BY `minOrder` ASC [ RunTime:0.003214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15493658 ORDER BY `unit` DESC [ RunTime:0.007656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15493658 LIMIT 2 [ RunTime:0.002720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15493658 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773259 LIMIT 5 [ RunTime:0.005844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773259 ORDER BY `minOrder` ASC [ RunTime:0.006693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773259 ORDER BY `unit` DESC [ RunTime:0.002608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773259 LIMIT 2 [ RunTime:0.003156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773259 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237253 LIMIT 5 [ RunTime:0.005981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237253 ORDER BY `minOrder` ASC [ RunTime:0.012010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16237253 ORDER BY `unit` DESC [ RunTime:0.010198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16237253 LIMIT 2 [ RunTime:0.015551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237253 ORDER BY `minOrder` ASC [ RunTime:0.009363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14176269 LIMIT 5 [ RunTime:0.015421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14176269 ORDER BY `minOrder` ASC [ RunTime:0.012262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14176269 ORDER BY `unit` DESC [ RunTime:0.016861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14176269 LIMIT 2 [ RunTime:0.017165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14176269 ORDER BY `minOrder` ASC [ RunTime:0.008165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17033169 LIMIT 5 [ RunTime:0.008633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17033169 ORDER BY `minOrder` ASC [ RunTime:0.014767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17033169 ORDER BY `unit` DESC [ RunTime:0.014743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17033169 LIMIT 2 [ RunTime:0.005073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17033169 ORDER BY `minOrder` ASC [ RunTime:0.006229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192887 LIMIT 5 [ RunTime:0.006779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192887 ORDER BY `minOrder` ASC [ RunTime:0.003887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192887 ORDER BY `unit` DESC [ RunTime:0.003227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192887 LIMIT 2 [ RunTime:0.012112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192887 ORDER BY `minOrder` ASC [ RunTime:0.005651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19778571 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19778571 ORDER BY `minOrder` ASC [ RunTime:0.008711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19778571 ORDER BY `unit` DESC [ RunTime:0.012442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19778571 LIMIT 2 [ RunTime:0.001552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19778571 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771177 LIMIT 5 [ RunTime:0.002465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771177 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19771177 ORDER BY `unit` DESC [ RunTime:0.006291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19771177 LIMIT 2 [ RunTime:0.001839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771177 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770889 LIMIT 5 [ RunTime:0.001002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770889 ORDER BY `minOrder` ASC [ RunTime:0.002965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19770889 ORDER BY `unit` DESC [ RunTime:0.009285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19770889 LIMIT 2 [ RunTime:0.001294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770889 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770035 LIMIT 5 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770035 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19770035 ORDER BY `unit` DESC [ RunTime:0.004891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19770035 LIMIT 2 [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770035 ORDER BY `minOrder` ASC [ RunTime:0.001551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769992 LIMIT 5 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769992 ORDER BY `minOrder` ASC [ RunTime:0.005498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769992 ORDER BY `unit` DESC [ RunTime:0.003780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769992 LIMIT 2 [ RunTime:0.003116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769992 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769870 LIMIT 5 [ RunTime:0.003980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769870 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769870 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769870 LIMIT 2 [ RunTime:0.002399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769870 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769775 LIMIT 5 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769775 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769775 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769775 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769775 ORDER BY `minOrder` ASC [ RunTime:0.004443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769659 LIMIT 5 [ RunTime:0.000985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769659 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769659 ORDER BY `unit` DESC [ RunTime:0.003328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769659 LIMIT 2 [ RunTime:0.004736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769659 ORDER BY `minOrder` ASC [ RunTime:0.006436s ]
select * from pdf where partno='69190-210H' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002000s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277141 LIMIT 5 [ RunTime:0.000819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277141 ORDER BY `minOrder` ASC [ RunTime:0.009494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277141 ORDER BY `unit` DESC [ RunTime:0.003704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277141 LIMIT 2 [ RunTime:0.006660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277141 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='69190-210hlf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001307s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-210hlf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.003709s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277141 AND `partno` = '69190-210hlf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.005576s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52580719 LIMIT 5 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52580719 ORDER BY `minOrder` ASC [ RunTime:0.004777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52580719 ORDER BY `unit` DESC [ RunTime:0.005438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52580719 LIMIT 2 [ RunTime:0.003847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52580719 ORDER BY `minOrder` ASC [ RunTime:0.005051s ]
select * from pdf where partno='69190-402HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-402HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004499s ]
SELECT `id` FROM `stock` WHERE `id` <> 52580719 AND `partno` = '69190-402HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485282 [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52574731 LIMIT 5 [ RunTime:0.002731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52574731 ORDER BY `minOrder` ASC [ RunTime:0.007168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52574731 ORDER BY `unit` DESC [ RunTime:0.000827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52574731 LIMIT 2 [ RunTime:0.003282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52574731 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='69190-403HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.008494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-403HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001605s ]
SELECT `id` FROM `stock` WHERE `id` <> 52574731 AND `partno` = '69190-403HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19813623 [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52580853 LIMIT 5 [ RunTime:0.001577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52580853 ORDER BY `minOrder` ASC [ RunTime:0.003867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52580853 ORDER BY `unit` DESC [ RunTime:0.001306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52580853 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52580853 ORDER BY `minOrder` ASC [ RunTime:0.001444s ]
select * from pdf where partno='69190-202HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-202HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003074s ]
SELECT `id` FROM `stock` WHERE `id` <> 52580853 AND `partno` = '69190-202HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16234609 [ RunTime:0.000792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52575018 LIMIT 5 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52575018 ORDER BY `minOrder` ASC [ RunTime:0.001253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52575018 ORDER BY `unit` DESC [ RunTime:0.000698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52575018 LIMIT 2 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52575018 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='69190-102HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-102HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002574s ]
SELECT `id` FROM `stock` WHERE `id` <> 52575018 AND `partno` = '69190-102HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.006357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16233844 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52580899 LIMIT 5 [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52580899 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52580899 ORDER BY `unit` DESC [ RunTime:0.001187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52580899 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52580899 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='69190-203HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.008225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-203HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001113s ]
SELECT `id` FROM `stock` WHERE `id` <> 52580899 AND `partno` = '69190-203HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.009766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19847962 [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52586754 LIMIT 5 [ RunTime:0.005725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52586754 ORDER BY `minOrder` ASC [ RunTime:0.001672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52586754 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52586754 LIMIT 2 [ RunTime:0.008282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52586754 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
select * from pdf where partno='69190-206HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-206HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000938s ]
SELECT `id` FROM `stock` WHERE `id` <> 52586754 AND `partno` = '69190-206HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237253 [ RunTime:0.005325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52586769 LIMIT 5 [ RunTime:0.002619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52586769 ORDER BY `minOrder` ASC [ RunTime:0.003786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52586769 ORDER BY `unit` DESC [ RunTime:0.013270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52586769 LIMIT 2 [ RunTime:0.007358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52586769 ORDER BY `minOrder` ASC [ RunTime:0.002778s ]
select * from pdf where partno='69190-105HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.013248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-105HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.010302s ]
SELECT `id` FROM `stock` WHERE `id` <> 52586769 AND `partno` = '69190-105HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772398 [ RunTime:0.008608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799630 LIMIT 5 [ RunTime:0.023977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799630 ORDER BY `minOrder` ASC [ RunTime:0.009284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799630 ORDER BY `unit` DESC [ RunTime:0.003438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799630 LIMIT 2 [ RunTime:0.022833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799630 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
select * from pdf where partno='691900110101' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900110101' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008671s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799630 AND `partno` = '691900110101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52586637 LIMIT 5 [ RunTime:0.005704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52586637 ORDER BY `minOrder` ASC [ RunTime:0.007380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52586637 ORDER BY `unit` DESC [ RunTime:0.001000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52586637 LIMIT 2 [ RunTime:0.010907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52586637 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='69190-405HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-405HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000649s ]
SELECT `id` FROM `stock` WHERE `id` <> 52586637 AND `partno` = '69190-405HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15493658 [ RunTime:0.013975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52583371 LIMIT 5 [ RunTime:0.002260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52583371 ORDER BY `minOrder` ASC [ RunTime:0.015858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52583371 ORDER BY `unit` DESC [ RunTime:0.001192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52583371 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52583371 ORDER BY `minOrder` ASC [ RunTime:0.003288s ]
select * from pdf where partno='69190-236HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.010445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69190-236HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004003s ]
SELECT `id` FROM `stock` WHERE `id` <> 52583371 AND `partno` = '69190-236HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.022835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773259 [ RunTime:0.012357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799677 LIMIT 5 [ RunTime:0.003598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799677 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799677 ORDER BY `unit` DESC [ RunTime:0.004682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799677 LIMIT 2 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799677 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
select * from pdf where partno='691900610303' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900610303' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001986s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799677 AND `partno` = '691900610303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799678 LIMIT 5 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799678 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799678 ORDER BY `unit` DESC [ RunTime:0.005320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799678 LIMIT 2 [ RunTime:0.002556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799678 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='691900610203' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900610203' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005648s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799678 AND `partno` = '691900610203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53800025 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800025 ORDER BY `minOrder` ASC [ RunTime:0.002065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53800025 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53800025 LIMIT 2 [ RunTime:0.002245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800025 ORDER BY `minOrder` ASC [ RunTime:0.006061s ]
select * from pdf where partno='691900110301' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900110301' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001171s ]
SELECT `id` FROM `stock` WHERE `id` <> 53800025 AND `partno` = '691900110301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53800021 LIMIT 5 [ RunTime:0.002137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800021 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53800021 ORDER BY `unit` DESC [ RunTime:0.003436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53800021 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800021 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='691900910301' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900910301' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006758s ]
SELECT `id` FROM `stock` WHERE `id` <> 53800021 AND `partno` = '691900910301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53800024 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800024 ORDER BY `minOrder` ASC [ RunTime:0.013511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53800024 ORDER BY `unit` DESC [ RunTime:0.002683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53800024 LIMIT 2 [ RunTime:0.004251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800024 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='691900310201' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900310201' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004668s ]
SELECT `id` FROM `stock` WHERE `id` <> 53800024 AND `partno` = '691900310201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799633 LIMIT 5 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799633 ORDER BY `minOrder` ASC [ RunTime:0.008229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799633 ORDER BY `unit` DESC [ RunTime:0.001144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799633 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799633 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='691900610103' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900610103' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001102s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799633 AND `partno` = '691900610103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799849 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799849 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799849 ORDER BY `unit` DESC [ RunTime:0.007210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799849 LIMIT 2 [ RunTime:0.003657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799849 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='691900910102' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900910102' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002468s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799849 AND `partno` = '691900910102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799846 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799846 ORDER BY `minOrder` ASC [ RunTime:0.005097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799846 ORDER BY `unit` DESC [ RunTime:0.005768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799846 LIMIT 2 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799846 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='691900510102' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900510102' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002778s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799846 AND `partno` = '691900510102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53799844 LIMIT 5 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799844 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53799844 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53799844 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53799844 ORDER BY `minOrder` ASC [ RunTime:0.002459s ]
select * from pdf where partno='691900710102' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900710102' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003146s ]
SELECT `id` FROM `stock` WHERE `id` <> 53799844 AND `partno` = '691900710102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53800383 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800383 ORDER BY `minOrder` ASC [ RunTime:0.001214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53800383 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53800383 LIMIT 2 [ RunTime:0.003200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53800383 ORDER BY `minOrder` ASC [ RunTime:0.003230s ]
select * from pdf where partno='691900310101' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691900310101' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000952s ]
SELECT `id` FROM `stock` WHERE `id` <> 53800383 AND `partno` = '691900310101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001756s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000943s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000674s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002331s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003965s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001148s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000778s ]
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 '69190%' OR `brand` LIKE '69190%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002231s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69190%' OR `brand` LIKE '69190%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004589s ]