SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001986s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=5296&search=1' [ RunTime:0.010942s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003537s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010764s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004215s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.009941s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001094s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009583s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001411s ]
SELECT * FROM `stock_search` WHERE `partno` = '5296' LIMIT 1 [ RunTime:0.009526s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-17 19:39:54' WHERE `partno` = '5296' [ RunTime:0.028738s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001416s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049925s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298669 LIMIT 5 [ RunTime:0.030956s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298669 ORDER BY `minOrder` ASC [ RunTime:0.028077s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298669 ORDER BY `unit` DESC [ RunTime:0.010291s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298669 LIMIT 2 [ RunTime:0.024058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298669 ORDER BY `minOrder` ASC [ RunTime:0.029707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298650 LIMIT 5 [ RunTime:0.063154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298650 ORDER BY `minOrder` ASC [ RunTime:0.045347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298650 ORDER BY `unit` DESC [ RunTime:0.037111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298650 LIMIT 2 [ RunTime:0.010067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298650 ORDER BY `minOrder` ASC [ RunTime:0.016828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582659 LIMIT 5 [ RunTime:0.010472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582659 ORDER BY `minOrder` ASC [ RunTime:0.038950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582659 ORDER BY `unit` DESC [ RunTime:0.017075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582659 LIMIT 2 [ RunTime:0.021436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582659 ORDER BY `minOrder` ASC [ RunTime:0.004797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582974 LIMIT 5 [ RunTime:0.009059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582974 ORDER BY `minOrder` ASC [ RunTime:0.072052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582974 ORDER BY `unit` DESC [ RunTime:0.058403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582974 LIMIT 2 [ RunTime:0.035934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582974 ORDER BY `minOrder` ASC [ RunTime:0.014744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441274 LIMIT 5 [ RunTime:0.041668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441274 ORDER BY `minOrder` ASC [ RunTime:0.041296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441274 ORDER BY `unit` DESC [ RunTime:0.029087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441274 LIMIT 2 [ RunTime:0.034997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441274 ORDER BY `minOrder` ASC [ RunTime:0.018394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298665 LIMIT 5 [ RunTime:0.016429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298665 ORDER BY `minOrder` ASC [ RunTime:0.021716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298665 ORDER BY `unit` DESC [ RunTime:0.020910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298665 LIMIT 2 [ RunTime:0.004241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298665 ORDER BY `minOrder` ASC [ RunTime:0.029815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582785 LIMIT 5 [ RunTime:0.020536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582785 ORDER BY `minOrder` ASC [ RunTime:0.061467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582785 ORDER BY `unit` DESC [ RunTime:0.025719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582785 LIMIT 2 [ RunTime:0.022294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582785 ORDER BY `minOrder` ASC [ RunTime:0.006788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298670 LIMIT 5 [ RunTime:0.015772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298670 ORDER BY `minOrder` ASC [ RunTime:0.034586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298670 ORDER BY `unit` DESC [ RunTime:0.012583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298670 LIMIT 2 [ RunTime:0.015100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298670 ORDER BY `minOrder` ASC [ RunTime:0.002337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298649 LIMIT 5 [ RunTime:0.007569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298649 ORDER BY `minOrder` ASC [ RunTime:0.021346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298649 ORDER BY `unit` DESC [ RunTime:0.022133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298649 LIMIT 2 [ RunTime:0.026385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298649 ORDER BY `minOrder` ASC [ RunTime:0.019719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582809 LIMIT 5 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582809 ORDER BY `minOrder` ASC [ RunTime:0.038721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582809 ORDER BY `unit` DESC [ RunTime:0.014758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582809 LIMIT 2 [ RunTime:0.003557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582809 ORDER BY `minOrder` ASC [ RunTime:0.012537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441256 LIMIT 5 [ RunTime:0.014527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441256 ORDER BY `minOrder` ASC [ RunTime:0.008919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441256 ORDER BY `unit` DESC [ RunTime:0.005245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441256 LIMIT 2 [ RunTime:0.005767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441256 ORDER BY `minOrder` ASC [ RunTime:0.004499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511286 LIMIT 5 [ RunTime:0.006280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511286 ORDER BY `minOrder` ASC [ RunTime:0.005263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19511286 ORDER BY `unit` DESC [ RunTime:0.011135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19511286 LIMIT 2 [ RunTime:0.004565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511286 ORDER BY `minOrder` ASC [ RunTime:0.011632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392717 LIMIT 5 [ RunTime:0.011534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392717 ORDER BY `minOrder` ASC [ RunTime:0.009892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392717 ORDER BY `unit` DESC [ RunTime:0.016049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392717 LIMIT 2 [ RunTime:0.021006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392717 ORDER BY `minOrder` ASC [ RunTime:0.022176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381354 LIMIT 5 [ RunTime:0.008547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381354 ORDER BY `minOrder` ASC [ RunTime:0.013329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381354 ORDER BY `unit` DESC [ RunTime:0.014613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381354 LIMIT 2 [ RunTime:0.009778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381354 ORDER BY `minOrder` ASC [ RunTime:0.011536s ]
select * from pdf where partno='5296C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.028783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381352 LIMIT 5 [ RunTime:0.008733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381352 ORDER BY `minOrder` ASC [ RunTime:0.021859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14381352 ORDER BY `unit` DESC [ RunTime:0.001562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14381352 LIMIT 2 [ RunTime:0.025812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14381352 ORDER BY `minOrder` ASC [ RunTime:0.008689s ]
select * from pdf where partno='5296C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.044584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517024 LIMIT 5 [ RunTime:0.011171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517024 ORDER BY `minOrder` ASC [ RunTime:0.008750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13517024 ORDER BY `unit` DESC [ RunTime:0.019104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13517024 LIMIT 2 [ RunTime:0.029406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13517024 ORDER BY `minOrder` ASC [ RunTime:0.010961s ]
select * from pdf where partno='5296C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507421 LIMIT 5 [ RunTime:0.007623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13507421 ORDER BY `minOrder` ASC [ RunTime:0.028875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13507421 ORDER BY `unit` DESC [ RunTime:0.046667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13507421 LIMIT 2 [ RunTime:0.010900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13507421 ORDER BY `minOrder` ASC [ RunTime:0.025421s ]
select * from pdf where partno='5296C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.033295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506248 LIMIT 5 [ RunTime:0.023454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506248 ORDER BY `minOrder` ASC [ RunTime:0.042233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13506248 ORDER BY `unit` DESC [ RunTime:0.029098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13506248 LIMIT 2 [ RunTime:0.021256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13506248 ORDER BY `minOrder` ASC [ RunTime:0.017386s ]
select * from pdf where partno='5296C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.017202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12033548 LIMIT 5 [ RunTime:0.028196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12033548 ORDER BY `minOrder` ASC [ RunTime:0.049967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12033548 ORDER BY `unit` DESC [ RunTime:0.033043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12033548 LIMIT 2 [ RunTime:0.102795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12033548 ORDER BY `minOrder` ASC [ RunTime:0.038295s ]
select * from pdf where partno='52969' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.072320s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32282224 LIMIT 5 [ RunTime:0.129619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282224 ORDER BY `minOrder` ASC [ RunTime:0.037699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32282224 ORDER BY `unit` DESC [ RunTime:0.037322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32282224 LIMIT 2 [ RunTime:0.051346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32282224 ORDER BY `minOrder` ASC [ RunTime:0.014398s ]
select * from pdf where partno='52961' and brandshort='te connectivity' limit 1 [ RunTime:0.020626s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52961' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.070738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281979 LIMIT 5 [ RunTime:0.045700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281979 ORDER BY `minOrder` ASC [ RunTime:0.074811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281979 ORDER BY `unit` DESC [ RunTime:0.060972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281979 LIMIT 2 [ RunTime:0.017010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281979 ORDER BY `minOrder` ASC [ RunTime:0.018530s ]
select * from pdf where partno='52963-5' and brandshort='te connectivity' limit 1 [ RunTime:0.086528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.037765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281569 LIMIT 5 [ RunTime:0.062896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281569 ORDER BY `minOrder` ASC [ RunTime:0.073993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281569 ORDER BY `unit` DESC [ RunTime:0.018540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281569 LIMIT 2 [ RunTime:0.043966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281569 ORDER BY `minOrder` ASC [ RunTime:0.042243s ]
select * from pdf where partno='52963-5' and brandshort='te connectivity' limit 1 [ RunTime:0.005714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.016820s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637168 LIMIT 5 [ RunTime:0.014055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637168 ORDER BY `minOrder` ASC [ RunTime:0.040452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637168 ORDER BY `unit` DESC [ RunTime:0.018148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637168 LIMIT 2 [ RunTime:0.030883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637168 ORDER BY `minOrder` ASC [ RunTime:0.041995s ]
select * from pdf where partno='52963-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.099040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.029512s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637168 AND `partno` = '52963-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.033200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298669 [ RunTime:0.043981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637298 LIMIT 5 [ RunTime:0.007048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637298 ORDER BY `minOrder` ASC [ RunTime:0.009385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637298 ORDER BY `unit` DESC [ RunTime:0.012253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637298 LIMIT 2 [ RunTime:0.043752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637298 ORDER BY `minOrder` ASC [ RunTime:0.019010s ]
select * from pdf where partno='52961-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52961-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016261s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637298 AND `partno` = '52961-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.030842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582659 [ RunTime:0.042351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637094 LIMIT 5 [ RunTime:0.009787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637094 ORDER BY `minOrder` ASC [ RunTime:0.016821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637094 ORDER BY `unit` DESC [ RunTime:0.038353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637094 LIMIT 2 [ RunTime:0.037200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637094 ORDER BY `minOrder` ASC [ RunTime:0.006133s ]
select * from pdf where partno='52963-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.047167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016103s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637094 AND `partno` = '52963-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.031838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582785 [ RunTime:0.036126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637129 LIMIT 5 [ RunTime:0.030740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637129 ORDER BY `minOrder` ASC [ RunTime:0.068527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637129 ORDER BY `unit` DESC [ RunTime:0.044080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637129 LIMIT 2 [ RunTime:0.039794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637129 ORDER BY `minOrder` ASC [ RunTime:0.026375s ]
select * from pdf where partno='52962-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52962-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.059048s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637129 AND `partno` = '52962-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.021452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298650 [ RunTime:0.042234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637272 LIMIT 5 [ RunTime:0.030567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637272 ORDER BY `minOrder` ASC [ RunTime:0.055791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637272 ORDER BY `unit` DESC [ RunTime:0.041274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637272 LIMIT 2 [ RunTime:0.032082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637272 ORDER BY `minOrder` ASC [ RunTime:0.009793s ]
select * from pdf where partno='52963-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.034322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.026923s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637272 AND `partno` = '52963-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441274 [ RunTime:0.024283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637265 LIMIT 5 [ RunTime:0.030028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637265 ORDER BY `minOrder` ASC [ RunTime:0.011601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637265 ORDER BY `unit` DESC [ RunTime:0.020084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637265 LIMIT 2 [ RunTime:0.050995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637265 ORDER BY `minOrder` ASC [ RunTime:0.003012s ]
select * from pdf where partno='52963-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.036304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024895s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637265 AND `partno` = '52963-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298665 [ RunTime:0.000771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637263 LIMIT 5 [ RunTime:0.025203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637263 ORDER BY `minOrder` ASC [ RunTime:0.034401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637263 ORDER BY `unit` DESC [ RunTime:0.041513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637263 LIMIT 2 [ RunTime:0.014466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637263 ORDER BY `minOrder` ASC [ RunTime:0.008842s ]
select * from pdf where partno='52963' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52963' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013607s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637263 AND `partno` = '52963' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.045709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582974 [ RunTime:0.019099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637299 LIMIT 5 [ RunTime:0.029176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637299 ORDER BY `minOrder` ASC [ RunTime:0.046625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637299 ORDER BY `unit` DESC [ RunTime:0.048706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637299 LIMIT 2 [ RunTime:0.120749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637299 ORDER BY `minOrder` ASC [ RunTime:0.042986s ]
select * from pdf where partno='52962-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.033577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52962-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.037173s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637299 AND `partno` = '52962-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.023500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298670 [ RunTime:0.048557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637169 LIMIT 5 [ RunTime:0.030310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637169 ORDER BY `minOrder` ASC [ RunTime:0.014603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637169 ORDER BY `unit` DESC [ RunTime:0.007962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637169 LIMIT 2 [ RunTime:0.032883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637169 ORDER BY `minOrder` ASC [ RunTime:0.008567s ]
select * from pdf where partno='52962-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52962-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011512s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637169 AND `partno` = '52962-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.024321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441256 [ RunTime:0.054794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637131 LIMIT 5 [ RunTime:0.003161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637131 ORDER BY `minOrder` ASC [ RunTime:0.017620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637131 ORDER BY `unit` DESC [ RunTime:0.029945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637131 LIMIT 2 [ RunTime:0.023368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637131 ORDER BY `minOrder` ASC [ RunTime:0.011855s ]
select * from pdf where partno='52962' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52962' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023729s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637131 AND `partno` = '52962' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.029897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298649 [ RunTime:0.051960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64045301 LIMIT 5 [ RunTime:0.050747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64045301 ORDER BY `minOrder` ASC [ RunTime:0.035576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64045301 ORDER BY `unit` DESC [ RunTime:0.022158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64045301 LIMIT 2 [ RunTime:0.070265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64045301 ORDER BY `minOrder` ASC [ RunTime:0.017286s ]
select * from pdf where partno='5296' and brandshort='Pololu' limit 1 [ RunTime:0.039184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.041876s ]
SELECT `id` FROM `stock` WHERE `id` <> 64045301 AND `partno` = '5296' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.010449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511286 [ RunTime:0.020925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64049700 LIMIT 5 [ RunTime:0.020567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049700 ORDER BY `minOrder` ASC [ RunTime:0.026994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64049700 ORDER BY `unit` DESC [ RunTime:0.034150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64049700 LIMIT 2 [ RunTime:0.016934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64049700 ORDER BY `minOrder` ASC [ RunTime:0.028288s ]
select * from pdf where partno='5296' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.047180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.050234s ]
SELECT `id` FROM `stock` WHERE `id` <> 64049700 AND `partno` = '5296' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.054880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392717 [ RunTime:0.012432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000241 LIMIT 5 [ RunTime:0.018314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000241 ORDER BY `minOrder` ASC [ RunTime:0.032938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000241 ORDER BY `unit` DESC [ RunTime:0.008178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000241 LIMIT 2 [ RunTime:0.030464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000241 ORDER BY `minOrder` ASC [ RunTime:0.025062s ]
select * from pdf where partno='5296C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.032509s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000241 AND `partno` = '5296C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.011272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517024 [ RunTime:0.009282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63029012 LIMIT 5 [ RunTime:0.015618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63029012 ORDER BY `minOrder` ASC [ RunTime:0.023811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63029012 ORDER BY `unit` DESC [ RunTime:0.025420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63029012 LIMIT 2 [ RunTime:0.030085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63029012 ORDER BY `minOrder` ASC [ RunTime:0.016635s ]
select * from pdf where partno='5296C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296C SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.032537s ]
SELECT `id` FROM `stock` WHERE `id` <> 63029012 AND `partno` = '5296C SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.043919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381354 [ RunTime:0.031084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63028960 LIMIT 5 [ RunTime:0.010129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63028960 ORDER BY `minOrder` ASC [ RunTime:0.023005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63028960 ORDER BY `unit` DESC [ RunTime:0.016371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63028960 LIMIT 2 [ RunTime:0.009114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63028960 ORDER BY `minOrder` ASC [ RunTime:0.018195s ]
select * from pdf where partno='5296C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296C BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.026615s ]
SELECT `id` FROM `stock` WHERE `id` <> 63028960 AND `partno` = '5296C BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.055337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14381352 [ RunTime:0.017583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63005988 LIMIT 5 [ RunTime:0.022951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63005988 ORDER BY `minOrder` ASC [ RunTime:0.009905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63005988 ORDER BY `unit` DESC [ RunTime:0.019144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63005988 LIMIT 2 [ RunTime:0.036323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63005988 ORDER BY `minOrder` ASC [ RunTime:0.025443s ]
select * from pdf where partno='5296C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.036025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.016745s ]
SELECT `id` FROM `stock` WHERE `id` <> 63005988 AND `partno` = '5296C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.016988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13506248 [ RunTime:0.003615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63005679 LIMIT 5 [ RunTime:0.006379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63005679 ORDER BY `minOrder` ASC [ RunTime:0.006191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63005679 ORDER BY `unit` DESC [ RunTime:0.016495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63005679 LIMIT 2 [ RunTime:0.013918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63005679 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
select * from pdf where partno='5296C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.012508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5296C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.017933s ]
SELECT `id` FROM `stock` WHERE `id` <> 63005679 AND `partno` = '5296C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.008543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13507421 [ RunTime:0.034516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60637408 LIMIT 5 [ RunTime:0.023607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637408 ORDER BY `minOrder` ASC [ RunTime:0.037183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60637408 ORDER BY `unit` DESC [ RunTime:0.015178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60637408 LIMIT 2 [ RunTime:0.029096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60637408 ORDER BY `minOrder` ASC [ RunTime:0.015353s ]
select * from pdf where partno='52961' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.045757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52961' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.044370s ]
SELECT `id` FROM `stock` WHERE `id` <> 60637408 AND `partno` = '52961' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.076789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582809 [ RunTime:0.045529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32329893 LIMIT 5 [ RunTime:0.019521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32329893 ORDER BY `minOrder` ASC [ RunTime:0.033540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32329893 ORDER BY `unit` DESC [ RunTime:0.024465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32329893 LIMIT 2 [ RunTime:0.014062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32329893 ORDER BY `minOrder` ASC [ RunTime:0.014788s ]
select * from pdf where partno='52969' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.002817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52969' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.002037s ]
SELECT `id` FROM `stock` WHERE `id` <> 32329893 AND `partno` = '52969' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.000950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12033548 [ RunTime:0.017683s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069107s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082571s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042091s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044185s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065887s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033367s ]
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 '5296%' OR `brand` LIKE '5296%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019656s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5296%' OR `brand` LIKE '5296%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041130s ]