SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001454s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=10779&search=1' [ RunTime:0.002095s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002172s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001197s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001641s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003857s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001125s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005431s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002600s ]
SELECT * FROM `stock_search` WHERE `partno` = '10779' LIMIT 1 [ RunTime:0.000985s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-26 02:34:30' WHERE `partno` = '10779' [ RunTime:0.006530s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001736s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030714s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348650 LIMIT 5 [ RunTime:0.010884s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348650 ORDER BY `minOrder` ASC [ RunTime:0.029306s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348650 ORDER BY `unit` DESC [ RunTime:0.029165s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348650 LIMIT 2 [ RunTime:0.023100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348650 ORDER BY `minOrder` ASC [ RunTime:0.039938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430849 LIMIT 5 [ RunTime:0.043856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430849 ORDER BY `minOrder` ASC [ RunTime:0.024002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430849 ORDER BY `unit` DESC [ RunTime:0.029091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430849 LIMIT 2 [ RunTime:0.038675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430849 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406453 LIMIT 5 [ RunTime:0.010662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406453 ORDER BY `minOrder` ASC [ RunTime:0.017566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406453 ORDER BY `unit` DESC [ RunTime:0.034791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406453 LIMIT 2 [ RunTime:0.027605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406453 ORDER BY `minOrder` ASC [ RunTime:0.009564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526847 LIMIT 5 [ RunTime:0.014464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526847 ORDER BY `minOrder` ASC [ RunTime:0.011921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526847 ORDER BY `unit` DESC [ RunTime:0.014792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526847 LIMIT 2 [ RunTime:0.018222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526847 ORDER BY `minOrder` ASC [ RunTime:0.015227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526446 LIMIT 5 [ RunTime:0.040013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526446 ORDER BY `minOrder` ASC [ RunTime:0.009283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526446 ORDER BY `unit` DESC [ RunTime:0.060085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526446 LIMIT 2 [ RunTime:0.065764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526446 ORDER BY `minOrder` ASC [ RunTime:0.017678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981364 LIMIT 5 [ RunTime:0.036539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981364 ORDER BY `minOrder` ASC [ RunTime:0.058957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981364 ORDER BY `unit` DESC [ RunTime:0.044823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981364 LIMIT 2 [ RunTime:0.094864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981364 ORDER BY `minOrder` ASC [ RunTime:0.013584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979495 LIMIT 5 [ RunTime:0.009906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979495 ORDER BY `minOrder` ASC [ RunTime:0.010412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979495 ORDER BY `unit` DESC [ RunTime:0.033775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979495 LIMIT 2 [ RunTime:0.041151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979495 ORDER BY `minOrder` ASC [ RunTime:0.021489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18978948 LIMIT 5 [ RunTime:0.067295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978948 ORDER BY `minOrder` ASC [ RunTime:0.035218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18978948 ORDER BY `unit` DESC [ RunTime:0.014579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18978948 LIMIT 2 [ RunTime:0.028107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978948 ORDER BY `minOrder` ASC [ RunTime:0.022479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779179 LIMIT 5 [ RunTime:0.073182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779179 ORDER BY `minOrder` ASC [ RunTime:0.015348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779179 ORDER BY `unit` DESC [ RunTime:0.002535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779179 LIMIT 2 [ RunTime:0.004728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779179 ORDER BY `minOrder` ASC [ RunTime:0.010951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773655 LIMIT 5 [ RunTime:0.019178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773655 ORDER BY `minOrder` ASC [ RunTime:0.020455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773655 ORDER BY `unit` DESC [ RunTime:0.026000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773655 LIMIT 2 [ RunTime:0.021715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773655 ORDER BY `minOrder` ASC [ RunTime:0.010437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773300 LIMIT 5 [ RunTime:0.006729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773300 ORDER BY `minOrder` ASC [ RunTime:0.005366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773300 ORDER BY `unit` DESC [ RunTime:0.015796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773300 LIMIT 2 [ RunTime:0.011874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773300 ORDER BY `minOrder` ASC [ RunTime:0.011321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772463 LIMIT 5 [ RunTime:0.021396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772463 ORDER BY `minOrder` ASC [ RunTime:0.006038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772463 ORDER BY `unit` DESC [ RunTime:0.006946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772463 LIMIT 2 [ RunTime:0.012855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772463 ORDER BY `minOrder` ASC [ RunTime:0.002459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491521 LIMIT 5 [ RunTime:0.010117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491521 ORDER BY `minOrder` ASC [ RunTime:0.006402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17491521 ORDER BY `unit` DESC [ RunTime:0.011766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17491521 LIMIT 2 [ RunTime:0.013250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17491521 ORDER BY `minOrder` ASC [ RunTime:0.004750s ]
select * from pdf where partno='107799' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.018841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049130 LIMIT 5 [ RunTime:0.023689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049130 ORDER BY `minOrder` ASC [ RunTime:0.018791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049130 ORDER BY `unit` DESC [ RunTime:0.019927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049130 LIMIT 2 [ RunTime:0.002421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049130 ORDER BY `minOrder` ASC [ RunTime:0.003398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010270 LIMIT 5 [ RunTime:0.002353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010270 ORDER BY `minOrder` ASC [ RunTime:0.001560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010270 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010270 LIMIT 2 [ RunTime:0.001133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010270 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265885 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265885 ORDER BY `minOrder` ASC [ RunTime:0.008101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15265885 ORDER BY `unit` DESC [ RunTime:0.013587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15265885 LIMIT 2 [ RunTime:0.007091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265885 ORDER BY `minOrder` ASC [ RunTime:0.006445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265820 LIMIT 5 [ RunTime:0.012525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265820 ORDER BY `minOrder` ASC [ RunTime:0.009431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15265820 ORDER BY `unit` DESC [ RunTime:0.016648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15265820 LIMIT 2 [ RunTime:0.002446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265820 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13296613 LIMIT 5 [ RunTime:0.007945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13296613 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13296613 ORDER BY `unit` DESC [ RunTime:0.005881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13296613 LIMIT 2 [ RunTime:0.002815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13296613 ORDER BY `minOrder` ASC [ RunTime:0.007590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11449900 LIMIT 5 [ RunTime:0.005983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11449900 ORDER BY `minOrder` ASC [ RunTime:0.003820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11449900 ORDER BY `unit` DESC [ RunTime:0.018387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11449900 LIMIT 2 [ RunTime:0.018420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11449900 ORDER BY `minOrder` ASC [ RunTime:0.011098s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080421 LIMIT 5 [ RunTime:0.012606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080421 ORDER BY `minOrder` ASC [ RunTime:0.019076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080421 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080421 LIMIT 2 [ RunTime:0.015145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080421 ORDER BY `minOrder` ASC [ RunTime:0.012271s ]
select * from pdf where partno='107796' and brandshort='basler' limit 1 [ RunTime:0.016720s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '107796' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.021948s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558817 LIMIT 5 [ RunTime:0.020445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558817 ORDER BY `minOrder` ASC [ RunTime:0.018313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558817 ORDER BY `unit` DESC [ RunTime:0.021814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558817 LIMIT 2 [ RunTime:0.010593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558817 ORDER BY `minOrder` ASC [ RunTime:0.011999s ]
select * from pdf where partno='10779CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.019687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10779CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.020317s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558817 AND `partno` = '10779CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.028170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348650 [ RunTime:0.024585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64612629 LIMIT 5 [ RunTime:0.011514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612629 ORDER BY `minOrder` ASC [ RunTime:0.015937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64612629 ORDER BY `unit` DESC [ RunTime:0.028567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64612629 LIMIT 2 [ RunTime:0.005084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612629 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
select * from pdf where partno='1077943' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077943' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025473s ]
SELECT `id` FROM `stock` WHERE `id` <> 64612629 AND `partno` = '1077943' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526847 [ RunTime:0.019402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64612847 LIMIT 5 [ RunTime:0.013660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612847 ORDER BY `minOrder` ASC [ RunTime:0.012891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64612847 ORDER BY `unit` DESC [ RunTime:0.007628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64612847 LIMIT 2 [ RunTime:0.007572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612847 ORDER BY `minOrder` ASC [ RunTime:0.008302s ]
select * from pdf where partno='1077942' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077942' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005547s ]
SELECT `id` FROM `stock` WHERE `id` <> 64612847 AND `partno` = '1077942' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430849 [ RunTime:0.013471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64818510 LIMIT 5 [ RunTime:0.022802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64818510 ORDER BY `minOrder` ASC [ RunTime:0.021290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64818510 ORDER BY `unit` DESC [ RunTime:0.012963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64818510 LIMIT 2 [ RunTime:0.007134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64818510 ORDER BY `minOrder` ASC [ RunTime:0.013598s ]
select * from pdf where partno='107795-HMC356LP3' and brandshort='Analog Devices Inc.' limit 1 [ RunTime:0.008982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '107795-HMC356LP3' OR `brand` LIKE 'Analog Devices Inc.%' ) ) LIMIT 1 [ RunTime:0.011009s ]
SELECT `id` FROM `stock` WHERE `id` <> 64818510 AND `partno` = '107795-HMC356LP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc.%' ) [ RunTime:0.008110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406453 [ RunTime:0.020500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805118 LIMIT 5 [ RunTime:0.046207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805118 ORDER BY `minOrder` ASC [ RunTime:0.017273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805118 ORDER BY `unit` DESC [ RunTime:0.001049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805118 LIMIT 2 [ RunTime:0.018282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805118 ORDER BY `minOrder` ASC [ RunTime:0.009329s ]
select * from pdf where partno='1077948' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077948' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012190s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805118 AND `partno` = '1077948' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773655 [ RunTime:0.017358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804479 LIMIT 5 [ RunTime:0.001407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804479 ORDER BY `minOrder` ASC [ RunTime:0.008017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804479 ORDER BY `unit` DESC [ RunTime:0.013028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804479 LIMIT 2 [ RunTime:0.003508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804479 ORDER BY `minOrder` ASC [ RunTime:0.006310s ]
select * from pdf where partno='1077947' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077947' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011945s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804479 AND `partno` = '1077947' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773300 [ RunTime:0.016439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803069 LIMIT 5 [ RunTime:0.005896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803069 ORDER BY `minOrder` ASC [ RunTime:0.021459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803069 ORDER BY `unit` DESC [ RunTime:0.013193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803069 LIMIT 2 [ RunTime:0.026545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803069 ORDER BY `minOrder` ASC [ RunTime:0.008858s ]
select * from pdf where partno='1077926' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077926' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019589s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803069 AND `partno` = '1077926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772463 [ RunTime:0.019367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800845 LIMIT 5 [ RunTime:0.025277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800845 ORDER BY `minOrder` ASC [ RunTime:0.040290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800845 ORDER BY `unit` DESC [ RunTime:0.009359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800845 LIMIT 2 [ RunTime:0.029856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800845 ORDER BY `minOrder` ASC [ RunTime:0.017198s ]
select * from pdf where partno='1077930' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077930' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005457s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800845 AND `partno` = '1077930' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010270 [ RunTime:0.020348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64568212 LIMIT 5 [ RunTime:0.006590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64568212 ORDER BY `minOrder` ASC [ RunTime:0.028064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64568212 ORDER BY `unit` DESC [ RunTime:0.031166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64568212 LIMIT 2 [ RunTime:0.009548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64568212 ORDER BY `minOrder` ASC [ RunTime:0.009381s ]
select * from pdf where partno='107796' and brandshort='Basler Inc.' limit 1 [ RunTime:0.000823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '107796' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.011374s ]
SELECT `id` FROM `stock` WHERE `id` <> 64568212 AND `partno` = '107796' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.035496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11449900 [ RunTime:0.013394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381946 LIMIT 5 [ RunTime:0.021619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381946 ORDER BY `minOrder` ASC [ RunTime:0.004539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381946 ORDER BY `unit` DESC [ RunTime:0.012992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381946 LIMIT 2 [ RunTime:0.006975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381946 ORDER BY `minOrder` ASC [ RunTime:0.035221s ]
select * from pdf where partno='10779-P' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.041544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10779-P' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.014410s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381946 AND `partno` = '10779-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.027691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381939 LIMIT 5 [ RunTime:0.029721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381939 ORDER BY `minOrder` ASC [ RunTime:0.008612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381939 ORDER BY `unit` DESC [ RunTime:0.012436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381939 LIMIT 2 [ RunTime:0.028999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381939 ORDER BY `minOrder` ASC [ RunTime:0.012896s ]
select * from pdf where partno='10779' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.025988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10779' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.026378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63343930 LIMIT 5 [ RunTime:0.023818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343930 ORDER BY `minOrder` ASC [ RunTime:0.023595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63343930 ORDER BY `unit` DESC [ RunTime:0.010741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63343930 LIMIT 2 [ RunTime:0.025912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343930 ORDER BY `minOrder` ASC [ RunTime:0.022164s ]
select * from pdf where partno='1077945' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077945' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021737s ]
SELECT `id` FROM `stock` WHERE `id` <> 63343930 AND `partno` = '1077945' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779179 [ RunTime:0.004819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198477 LIMIT 5 [ RunTime:0.039571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198477 ORDER BY `minOrder` ASC [ RunTime:0.011138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198477 ORDER BY `unit` DESC [ RunTime:0.018062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198477 LIMIT 2 [ RunTime:0.026673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198477 ORDER BY `minOrder` ASC [ RunTime:0.007283s ]
select * from pdf where partno='1077973' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077973' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031884s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198477 AND `partno` = '1077973' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.044688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049130 [ RunTime:0.033150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198470 LIMIT 5 [ RunTime:0.028159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198470 ORDER BY `minOrder` ASC [ RunTime:0.021856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198470 ORDER BY `unit` DESC [ RunTime:0.017422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198470 LIMIT 2 [ RunTime:0.014721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198470 ORDER BY `minOrder` ASC [ RunTime:0.009906s ]
select * from pdf where partno='1077940' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077940' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016257s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198470 AND `partno` = '1077940' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981364 [ RunTime:0.018140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63196861 LIMIT 5 [ RunTime:0.014095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63196861 ORDER BY `minOrder` ASC [ RunTime:0.015456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63196861 ORDER BY `unit` DESC [ RunTime:0.002226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63196861 LIMIT 2 [ RunTime:0.020521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63196861 ORDER BY `minOrder` ASC [ RunTime:0.008978s ]
select * from pdf where partno='1077933' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077933' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021784s ]
SELECT `id` FROM `stock` WHERE `id` <> 63196861 AND `partno` = '1077933' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979495 [ RunTime:0.021830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63196756 LIMIT 5 [ RunTime:0.021708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63196756 ORDER BY `minOrder` ASC [ RunTime:0.015850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63196756 ORDER BY `unit` DESC [ RunTime:0.021603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63196756 LIMIT 2 [ RunTime:0.008129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63196756 ORDER BY `minOrder` ASC [ RunTime:0.008874s ]
select * from pdf where partno='1077989' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.057841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077989' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025138s ]
SELECT `id` FROM `stock` WHERE `id` <> 63196756 AND `partno` = '1077989' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265885 [ RunTime:0.038991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63196362 LIMIT 5 [ RunTime:0.042161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63196362 ORDER BY `minOrder` ASC [ RunTime:0.025502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63196362 ORDER BY `unit` DESC [ RunTime:0.018684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63196362 LIMIT 2 [ RunTime:0.041448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63196362 ORDER BY `minOrder` ASC [ RunTime:0.010143s ]
select * from pdf where partno='1077949' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077949' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020039s ]
SELECT `id` FROM `stock` WHERE `id` <> 63196362 AND `partno` = '1077949' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18978948 [ RunTime:0.054300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62182194 LIMIT 5 [ RunTime:0.021787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62182194 ORDER BY `minOrder` ASC [ RunTime:0.008271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62182194 ORDER BY `unit` DESC [ RunTime:0.009475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62182194 LIMIT 2 [ RunTime:0.012809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62182194 ORDER BY `minOrder` ASC [ RunTime:0.002573s ]
select * from pdf where partno='107799' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.006088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '107799' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.003717s ]
SELECT `id` FROM `stock` WHERE `id` <> 62182194 AND `partno` = '107799' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.048411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17491521 [ RunTime:0.036012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32708276 LIMIT 5 [ RunTime:0.037889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32708276 ORDER BY `minOrder` ASC [ RunTime:0.020719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32708276 ORDER BY `unit` DESC [ RunTime:0.002278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32708276 LIMIT 2 [ RunTime:0.009561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32708276 ORDER BY `minOrder` ASC [ RunTime:0.010711s ]
select * from pdf where partno='1077999' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1077999' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013695s ]
SELECT `id` FROM `stock` WHERE `id` <> 32708276 AND `partno` = '1077999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13296613 [ RunTime:0.021629s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011683s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012531s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014716s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014645s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025887s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009048s ]
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 '10779%' OR `brand` LIKE '10779%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026733s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10779%' OR `brand` LIKE '10779%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025966s ]