SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001174s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=7630&search=1' [ RunTime:0.002493s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001173s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001425s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002118s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001438s ]
SELECT * FROM `stock_search` WHERE `partno` = '7630' LIMIT 1 [ RunTime:0.000723s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-22 10:17:28' WHERE `partno` = '7630' [ RunTime:0.002503s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001983s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021554s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667364 LIMIT 5 [ RunTime:0.014207s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667364 ORDER BY `minOrder` ASC [ RunTime:0.006884s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12667364 ORDER BY `unit` DESC [ RunTime:0.001304s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12667364 LIMIT 2 [ RunTime:0.003506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667364 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498349 LIMIT 5 [ RunTime:0.008942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13498349 ORDER BY `minOrder` ASC [ RunTime:0.012876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13498349 ORDER BY `unit` DESC [ RunTime:0.012690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13498349 LIMIT 2 [ RunTime:0.020039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13498349 ORDER BY `minOrder` ASC [ RunTime:0.008307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408685 LIMIT 5 [ RunTime:0.006211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408685 ORDER BY `minOrder` ASC [ RunTime:0.016915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408685 ORDER BY `unit` DESC [ RunTime:0.015382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408685 LIMIT 2 [ RunTime:0.006709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408685 ORDER BY `minOrder` ASC [ RunTime:0.007402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501164 LIMIT 5 [ RunTime:0.023549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501164 ORDER BY `minOrder` ASC [ RunTime:0.002392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13501164 ORDER BY `unit` DESC [ RunTime:0.005826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13501164 LIMIT 2 [ RunTime:0.009876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501164 ORDER BY `minOrder` ASC [ RunTime:0.002528s ]
select * from pdf where partno='76303WS 008500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.026504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681748 LIMIT 5 [ RunTime:0.008904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681748 ORDER BY `minOrder` ASC [ RunTime:0.009113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681748 ORDER BY `unit` DESC [ RunTime:0.018635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681748 LIMIT 2 [ RunTime:0.029599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681748 ORDER BY `minOrder` ASC [ RunTime:0.006621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684396 LIMIT 5 [ RunTime:0.010442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684396 ORDER BY `minOrder` ASC [ RunTime:0.015709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684396 ORDER BY `unit` DESC [ RunTime:0.024150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684396 LIMIT 2 [ RunTime:0.027652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684396 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671156 LIMIT 5 [ RunTime:0.050983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671156 ORDER BY `minOrder` ASC [ RunTime:0.024879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12671156 ORDER BY `unit` DESC [ RunTime:0.000838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12671156 LIMIT 2 [ RunTime:0.001527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671156 ORDER BY `minOrder` ASC [ RunTime:0.002398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523382 LIMIT 5 [ RunTime:0.026926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523382 ORDER BY `minOrder` ASC [ RunTime:0.002392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11523382 ORDER BY `unit` DESC [ RunTime:0.006225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11523382 LIMIT 2 [ RunTime:0.049932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523382 ORDER BY `minOrder` ASC [ RunTime:0.029330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11530712 LIMIT 5 [ RunTime:0.029808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11530712 ORDER BY `minOrder` ASC [ RunTime:0.009070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11530712 ORDER BY `unit` DESC [ RunTime:0.037588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11530712 LIMIT 2 [ RunTime:0.031557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11530712 ORDER BY `minOrder` ASC [ RunTime:0.022314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697422 LIMIT 5 [ RunTime:0.008819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697422 ORDER BY `minOrder` ASC [ RunTime:0.026089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14697422 ORDER BY `unit` DESC [ RunTime:0.003588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14697422 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697422 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11521261 LIMIT 5 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11521261 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11521261 ORDER BY `unit` DESC [ RunTime:0.014394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11521261 LIMIT 2 [ RunTime:0.024125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11521261 ORDER BY `minOrder` ASC [ RunTime:0.004687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11521336 LIMIT 5 [ RunTime:0.001447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11521336 ORDER BY `minOrder` ASC [ RunTime:0.016075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11521336 ORDER BY `unit` DESC [ RunTime:0.024556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11521336 LIMIT 2 [ RunTime:0.018475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11521336 ORDER BY `minOrder` ASC [ RunTime:0.024211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697424 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697424 ORDER BY `minOrder` ASC [ RunTime:0.006592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14697424 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14697424 LIMIT 2 [ RunTime:0.011155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697424 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18899846 LIMIT 5 [ RunTime:0.001149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18899846 ORDER BY `minOrder` ASC [ RunTime:0.007768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18899846 ORDER BY `unit` DESC [ RunTime:0.002883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18899846 LIMIT 2 [ RunTime:0.014629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18899846 ORDER BY `minOrder` ASC [ RunTime:0.003210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16620835 LIMIT 5 [ RunTime:0.008425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620835 ORDER BY `minOrder` ASC [ RunTime:0.014875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16620835 ORDER BY `unit` DESC [ RunTime:0.032262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16620835 LIMIT 2 [ RunTime:0.004752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620835 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697445 LIMIT 5 [ RunTime:0.003893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697445 ORDER BY `minOrder` ASC [ RunTime:0.008247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14697445 ORDER BY `unit` DESC [ RunTime:0.000882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14697445 LIMIT 2 [ RunTime:0.003602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14697445 ORDER BY `minOrder` ASC [ RunTime:0.016710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16620838 LIMIT 5 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620838 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16620838 ORDER BY `unit` DESC [ RunTime:0.006308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16620838 LIMIT 2 [ RunTime:0.007430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620838 ORDER BY `minOrder` ASC [ RunTime:0.015545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514449 LIMIT 5 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514449 ORDER BY `minOrder` ASC [ RunTime:0.005673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514449 ORDER BY `unit` DESC [ RunTime:0.006673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514449 LIMIT 2 [ RunTime:0.014953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514449 ORDER BY `minOrder` ASC [ RunTime:0.009883s ]
select * from pdf where partno='76302WS 008100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18903137 LIMIT 5 [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903137 ORDER BY `minOrder` ASC [ RunTime:0.018443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18903137 ORDER BY `unit` DESC [ RunTime:0.016495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18903137 LIMIT 2 [ RunTime:0.006878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903137 ORDER BY `minOrder` ASC [ RunTime:0.015878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15248839 LIMIT 5 [ RunTime:0.002578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15248839 ORDER BY `minOrder` ASC [ RunTime:0.019660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15248839 ORDER BY `unit` DESC [ RunTime:0.009434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15248839 LIMIT 2 [ RunTime:0.007391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15248839 ORDER BY `minOrder` ASC [ RunTime:0.010849s ]
select * from pdf where partno='763071-01' and brandshort='NI' limit 1 [ RunTime:0.000614s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221351 LIMIT 5 [ RunTime:0.009306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221351 ORDER BY `minOrder` ASC [ RunTime:0.015731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221351 ORDER BY `unit` DESC [ RunTime:0.005681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221351 LIMIT 2 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221351 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
select * from pdf where partno='76305-01 flxt-4624 aluminum' and brandshort='pactec' limit 1 [ RunTime:0.011606s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76305-01 flxt-4624 aluminum' OR `brand` LIKE 'pactec%' ) ) LIMIT 1 [ RunTime:0.004490s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221351 AND `partno` = '76305-01 flxt-4624 aluminum' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pactec%' ) [ RunTime:0.002468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51087569 LIMIT 5 [ RunTime:0.005081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087569 ORDER BY `minOrder` ASC [ RunTime:0.014918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51087569 ORDER BY `unit` DESC [ RunTime:0.029709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51087569 LIMIT 2 [ RunTime:0.014944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087569 ORDER BY `minOrder` ASC [ RunTime:0.004907s ]
select * from pdf where partno='763020.0330' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.008153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763020.0330' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.008064s ]
SELECT `id` FROM `stock` WHERE `id` <> 51087569 AND `partno` = '763020.0330' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.023772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51087625 LIMIT 5 [ RunTime:0.025874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087625 ORDER BY `minOrder` ASC [ RunTime:0.011650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51087625 ORDER BY `unit` DESC [ RunTime:0.006698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51087625 LIMIT 2 [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087625 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='763020.0120' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.006791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763020.0120' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.003804s ]
SELECT `id` FROM `stock` WHERE `id` <> 51087625 AND `partno` = '763020.0120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.021103s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49174644 LIMIT 5 [ RunTime:0.030255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174644 ORDER BY `minOrder` ASC [ RunTime:0.067085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49174644 ORDER BY `unit` DESC [ RunTime:0.007273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49174644 LIMIT 2 [ RunTime:0.021815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49174644 ORDER BY `minOrder` ASC [ RunTime:0.021409s ]
select * from pdf where partno='76302WS 0081000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.026376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76302WS 0081000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.010319s ]
SELECT `id` FROM `stock` WHERE `id` <> 49174644 AND `partno` = '76302WS 0081000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.050815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498349 [ RunTime:0.032665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36378351 LIMIT 5 [ RunTime:0.020034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378351 ORDER BY `minOrder` ASC [ RunTime:0.035094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36378351 ORDER BY `unit` DESC [ RunTime:0.006407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36378351 LIMIT 2 [ RunTime:0.021636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36378351 ORDER BY `minOrder` ASC [ RunTime:0.003648s ]
select * from pdf where partno='76302WS 0081000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.015785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76302WS 0081000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000614s ]
SELECT `id` FROM `stock` WHERE `id` <> 36378351 AND `partno` = '76302WS 0081000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.005875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13498349 [ RunTime:0.002418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52892978 LIMIT 5 [ RunTime:0.006525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892978 ORDER BY `minOrder` ASC [ RunTime:0.023667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52892978 ORDER BY `unit` DESC [ RunTime:0.019612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52892978 LIMIT 2 [ RunTime:0.016856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892978 ORDER BY `minOrder` ASC [ RunTime:0.005774s ]
select * from pdf where partno='76308-204LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.024800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-204LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.006213s ]
SELECT `id` FROM `stock` WHERE `id` <> 52892978 AND `partno` = '76308-204LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.009371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671540 [ RunTime:0.011581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49306670 LIMIT 5 [ RunTime:0.005037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49306670 ORDER BY `minOrder` ASC [ RunTime:0.012517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49306670 ORDER BY `unit` DESC [ RunTime:0.003086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49306670 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49306670 ORDER BY `minOrder` ASC [ RunTime:0.011016s ]
select * from pdf where partno='7630' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.007070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7630' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.003514s ]
SELECT `id` FROM `stock` WHERE `id` <> 49306670 AND `partno` = '7630' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408685 [ RunTime:0.023678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36501830 LIMIT 5 [ RunTime:0.016131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36501830 ORDER BY `minOrder` ASC [ RunTime:0.009379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36501830 ORDER BY `unit` DESC [ RunTime:0.014078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36501830 LIMIT 2 [ RunTime:0.015732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36501830 ORDER BY `minOrder` ASC [ RunTime:0.018716s ]
select * from pdf where partno='7630' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.007116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7630' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000519s ]
SELECT `id` FROM `stock` WHERE `id` <> 36501830 AND `partno` = '7630' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.008429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408685 [ RunTime:0.004592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51267345 LIMIT 5 [ RunTime:0.008733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51267345 ORDER BY `minOrder` ASC [ RunTime:0.021239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51267345 ORDER BY `unit` DESC [ RunTime:0.015929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51267345 LIMIT 2 [ RunTime:0.025651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51267345 ORDER BY `minOrder` ASC [ RunTime:0.005311s ]
select * from pdf where partno='7630E-3-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.009389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7630E-3-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.017555s ]
SELECT `id` FROM `stock` WHERE `id` <> 51267345 AND `partno` = '7630E-3-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.012688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51269238 LIMIT 5 [ RunTime:0.048596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51269238 ORDER BY `minOrder` ASC [ RunTime:0.004987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51269238 ORDER BY `unit` DESC [ RunTime:0.006057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51269238 LIMIT 2 [ RunTime:0.007899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51269238 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='7630E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.015817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7630E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.009892s ]
SELECT `id` FROM `stock` WHERE `id` <> 51269238 AND `partno` = '7630E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.005260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52892971 LIMIT 5 [ RunTime:0.017879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892971 ORDER BY `minOrder` ASC [ RunTime:0.016847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52892971 ORDER BY `unit` DESC [ RunTime:0.024935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52892971 LIMIT 2 [ RunTime:0.021079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892971 ORDER BY `minOrder` ASC [ RunTime:0.018004s ]
select * from pdf where partno='76308-103LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.052108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-103LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.058145s ]
SELECT `id` FROM `stock` WHERE `id` <> 52892971 AND `partno` = '76308-103LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.031627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667364 [ RunTime:0.045894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893634 LIMIT 5 [ RunTime:0.041348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893634 ORDER BY `minOrder` ASC [ RunTime:0.061913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893634 ORDER BY `unit` DESC [ RunTime:0.048033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893634 LIMIT 2 [ RunTime:0.049908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893634 ORDER BY `minOrder` ASC [ RunTime:0.015348s ]
select * from pdf where partno='76308-120LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.015948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-120LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.014623s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893634 AND `partno` = '76308-120LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.034541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684396 [ RunTime:0.024486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893602 LIMIT 5 [ RunTime:0.050597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893602 ORDER BY `minOrder` ASC [ RunTime:0.070319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893602 ORDER BY `unit` DESC [ RunTime:0.003384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893602 LIMIT 2 [ RunTime:0.043855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893602 ORDER BY `minOrder` ASC [ RunTime:0.002694s ]
select * from pdf where partno='76308-111LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.005466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-111LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.032996s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893602 AND `partno` = '76308-111LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.033608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52891200 LIMIT 5 [ RunTime:0.048215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891200 ORDER BY `minOrder` ASC [ RunTime:0.027334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52891200 ORDER BY `unit` DESC [ RunTime:0.064234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52891200 LIMIT 2 [ RunTime:0.057622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891200 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
select * from pdf where partno='76308-107LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.006960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-107LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.016083s ]
SELECT `id` FROM `stock` WHERE `id` <> 52891200 AND `partno` = '76308-107LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523382 [ RunTime:0.031829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893201 LIMIT 5 [ RunTime:0.008693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893201 ORDER BY `minOrder` ASC [ RunTime:0.033902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893201 ORDER BY `unit` DESC [ RunTime:0.030122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893201 LIMIT 2 [ RunTime:0.024347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893201 ORDER BY `minOrder` ASC [ RunTime:0.026659s ]
select * from pdf where partno='76308-210LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.043524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-210LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.039565s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893201 AND `partno` = '76308-210LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.014542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681748 [ RunTime:0.009692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36366423 LIMIT 5 [ RunTime:0.023763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36366423 ORDER BY `minOrder` ASC [ RunTime:0.044155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36366423 ORDER BY `unit` DESC [ RunTime:0.018475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36366423 LIMIT 2 [ RunTime:0.012107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36366423 ORDER BY `minOrder` ASC [ RunTime:0.011365s ]
select * from pdf where partno='763061-005' and brandshort='NI' limit 1 [ RunTime:0.012481s ]
select foldpath,foldpath2,filename from pdf_file where id=1563797 limit 1 [ RunTime:0.013810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763061-005' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.045443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874963 LIMIT 5 [ RunTime:0.038119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874963 ORDER BY `minOrder` ASC [ RunTime:0.064685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874963 ORDER BY `unit` DESC [ RunTime:0.078908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874963 LIMIT 2 [ RunTime:0.005019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874963 ORDER BY `minOrder` ASC [ RunTime:0.013669s ]
select * from pdf where partno='763061-01' and brandshort='NI' limit 1 [ RunTime:0.043733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763061-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.038840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49162695 LIMIT 5 [ RunTime:0.058547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49162695 ORDER BY `minOrder` ASC [ RunTime:0.061451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49162695 ORDER BY `unit` DESC [ RunTime:0.043365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49162695 LIMIT 2 [ RunTime:0.040356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49162695 ORDER BY `minOrder` ASC [ RunTime:0.029208s ]
select * from pdf where partno='763061-005' and brandshort='NI' limit 1 [ RunTime:0.025329s ]
select foldpath,foldpath2,filename from pdf_file where id=1563797 limit 1 [ RunTime:0.015260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763061-005' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.015836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49681778 LIMIT 5 [ RunTime:0.034910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49681778 ORDER BY `minOrder` ASC [ RunTime:0.049926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49681778 ORDER BY `unit` DESC [ RunTime:0.061946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49681778 LIMIT 2 [ RunTime:0.030073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49681778 ORDER BY `minOrder` ASC [ RunTime:0.013305s ]
select * from pdf where partno='763061-01' and brandshort='NI' limit 1 [ RunTime:0.014589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763061-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.016357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52915060 LIMIT 5 [ RunTime:0.039303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52915060 ORDER BY `minOrder` ASC [ RunTime:0.077881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52915060 ORDER BY `unit` DESC [ RunTime:0.019723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52915060 LIMIT 2 [ RunTime:0.083605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52915060 ORDER BY `minOrder` ASC [ RunTime:0.011258s ]
select * from pdf where partno='76308-108LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.042606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-108LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.060848s ]
SELECT `id` FROM `stock` WHERE `id` <> 52915060 AND `partno` = '76308-108LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.040882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671156 [ RunTime:0.039819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52915265 LIMIT 5 [ RunTime:0.017086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52915265 ORDER BY `minOrder` ASC [ RunTime:0.030817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52915265 ORDER BY `unit` DESC [ RunTime:0.028306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52915265 LIMIT 2 [ RunTime:0.016883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52915265 ORDER BY `minOrder` ASC [ RunTime:0.005110s ]
select * from pdf where partno='76308-116LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.010588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76308-116LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.030214s ]
SELECT `id` FROM `stock` WHERE `id` <> 52915265 AND `partno` = '76308-116LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.028390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11521336 [ RunTime:0.020326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49162698 LIMIT 5 [ RunTime:0.010719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49162698 ORDER BY `minOrder` ASC [ RunTime:0.011441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49162698 ORDER BY `unit` DESC [ RunTime:0.022751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49162698 LIMIT 2 [ RunTime:0.043118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49162698 ORDER BY `minOrder` ASC [ RunTime:0.057164s ]
select * from pdf where partno='763061-02' and brandshort='NI' limit 1 [ RunTime:0.031521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763061-02' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.057696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36366445 LIMIT 5 [ RunTime:0.048163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36366445 ORDER BY `minOrder` ASC [ RunTime:0.030248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36366445 ORDER BY `unit` DESC [ RunTime:0.018084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36366445 LIMIT 2 [ RunTime:0.005260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36366445 ORDER BY `minOrder` ASC [ RunTime:0.007292s ]
select * from pdf where partno='763061-02' and brandshort='NI' limit 1 [ RunTime:0.004409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '763061-02' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.021611s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019220s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025609s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020524s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021030s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029866s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014884s ]
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 '7630%' OR `brand` LIKE '7630%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050425s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7630%' OR `brand` LIKE '7630%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031110s ]