SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004790s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=10922&search=1' [ RunTime:0.009969s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002856s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013621s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002733s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.019173s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002150s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009336s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001860s ]
SELECT * FROM `stock_search` WHERE `partno` = '10922' LIMIT 1 [ RunTime:0.008491s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 09:23:00' WHERE `partno` = '10922' [ RunTime:0.008630s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002119s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011947s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807452 LIMIT 5 [ RunTime:0.008282s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807452 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807452 ORDER BY `unit` DESC [ RunTime:0.001191s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807452 LIMIT 2 [ RunTime:0.011336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807452 ORDER BY `minOrder` ASC [ RunTime:0.008091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998026 LIMIT 5 [ RunTime:0.008077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998026 ORDER BY `minOrder` ASC [ RunTime:0.011379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998026 ORDER BY `unit` DESC [ RunTime:0.003309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998026 LIMIT 2 [ RunTime:0.017117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998026 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982895 LIMIT 5 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982895 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982895 ORDER BY `unit` DESC [ RunTime:0.011167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982895 LIMIT 2 [ RunTime:0.015599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982895 ORDER BY `minOrder` ASC [ RunTime:0.001469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981348 LIMIT 5 [ RunTime:0.002504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981348 ORDER BY `minOrder` ASC [ RunTime:0.010698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981348 ORDER BY `unit` DESC [ RunTime:0.009734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981348 LIMIT 2 [ RunTime:0.005402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981348 ORDER BY `minOrder` ASC [ RunTime:0.003607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975321 LIMIT 5 [ RunTime:0.030960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975321 ORDER BY `minOrder` ASC [ RunTime:0.011433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975321 ORDER BY `unit` DESC [ RunTime:0.005695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975321 LIMIT 2 [ RunTime:0.016081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975321 ORDER BY `minOrder` ASC [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778927 LIMIT 5 [ RunTime:0.010139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778927 ORDER BY `minOrder` ASC [ RunTime:0.012720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778927 ORDER BY `unit` DESC [ RunTime:0.028375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778927 LIMIT 2 [ RunTime:0.044924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778927 ORDER BY `minOrder` ASC [ RunTime:0.003548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778531 LIMIT 5 [ RunTime:0.015122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778531 ORDER BY `minOrder` ASC [ RunTime:0.005932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778531 ORDER BY `unit` DESC [ RunTime:0.008108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778531 LIMIT 2 [ RunTime:0.007487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778531 ORDER BY `minOrder` ASC [ RunTime:0.004837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705703 LIMIT 5 [ RunTime:0.026602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705703 ORDER BY `minOrder` ASC [ RunTime:0.026009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705703 ORDER BY `unit` DESC [ RunTime:0.005625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705703 LIMIT 2 [ RunTime:0.017789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705703 ORDER BY `minOrder` ASC [ RunTime:0.014574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049127 LIMIT 5 [ RunTime:0.040979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049127 ORDER BY `minOrder` ASC [ RunTime:0.009560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049127 ORDER BY `unit` DESC [ RunTime:0.019108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049127 LIMIT 2 [ RunTime:0.043825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049127 ORDER BY `minOrder` ASC [ RunTime:0.005362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011886 LIMIT 5 [ RunTime:0.018270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011886 ORDER BY `minOrder` ASC [ RunTime:0.037256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011886 ORDER BY `unit` DESC [ RunTime:0.028872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011886 LIMIT 2 [ RunTime:0.021151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011886 ORDER BY `minOrder` ASC [ RunTime:0.014640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010638 LIMIT 5 [ RunTime:0.008712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010638 ORDER BY `minOrder` ASC [ RunTime:0.012586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010638 ORDER BY `unit` DESC [ RunTime:0.081749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010638 LIMIT 2 [ RunTime:0.043600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010638 ORDER BY `minOrder` ASC [ RunTime:0.027252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226131 LIMIT 5 [ RunTime:0.020993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226131 ORDER BY `minOrder` ASC [ RunTime:0.024260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226131 ORDER BY `unit` DESC [ RunTime:0.041862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226131 LIMIT 2 [ RunTime:0.030381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226131 ORDER BY `minOrder` ASC [ RunTime:0.017388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224641 LIMIT 5 [ RunTime:0.013229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224641 ORDER BY `minOrder` ASC [ RunTime:0.013052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224641 ORDER BY `unit` DESC [ RunTime:0.021953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224641 LIMIT 2 [ RunTime:0.011483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224641 ORDER BY `minOrder` ASC [ RunTime:0.020064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14691989 LIMIT 5 [ RunTime:0.036853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14691989 ORDER BY `minOrder` ASC [ RunTime:0.020283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14691989 ORDER BY `unit` DESC [ RunTime:0.025679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14691989 LIMIT 2 [ RunTime:0.071827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14691989 ORDER BY `minOrder` ASC [ RunTime:0.017119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14397067 LIMIT 5 [ RunTime:0.042370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14397067 ORDER BY `minOrder` ASC [ RunTime:0.038905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14397067 ORDER BY `unit` DESC [ RunTime:0.067767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14397067 LIMIT 2 [ RunTime:0.019070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14397067 ORDER BY `minOrder` ASC [ RunTime:0.004566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396012 LIMIT 5 [ RunTime:0.042182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396012 ORDER BY `minOrder` ASC [ RunTime:0.031636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396012 ORDER BY `unit` DESC [ RunTime:0.069333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396012 LIMIT 2 [ RunTime:0.022648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396012 ORDER BY `minOrder` ASC [ RunTime:0.034390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394995 LIMIT 5 [ RunTime:0.039493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394995 ORDER BY `minOrder` ASC [ RunTime:0.049517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394995 ORDER BY `unit` DESC [ RunTime:0.108467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394995 LIMIT 2 [ RunTime:0.056329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394995 ORDER BY `minOrder` ASC [ RunTime:0.025152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13525658 LIMIT 5 [ RunTime:0.027538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525658 ORDER BY `minOrder` ASC [ RunTime:0.050218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13525658 ORDER BY `unit` DESC [ RunTime:0.028081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13525658 LIMIT 2 [ RunTime:0.047186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525658 ORDER BY `minOrder` ASC [ RunTime:0.029142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171560 LIMIT 5 [ RunTime:0.030299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171560 ORDER BY `minOrder` ASC [ RunTime:0.015430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12171560 ORDER BY `unit` DESC [ RunTime:0.026012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12171560 LIMIT 2 [ RunTime:0.040284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171560 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958379 LIMIT 5 [ RunTime:0.015021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11958379 ORDER BY `minOrder` ASC [ RunTime:0.040454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11958379 ORDER BY `unit` DESC [ RunTime:0.027792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11958379 LIMIT 2 [ RunTime:0.072737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11958379 ORDER BY `minOrder` ASC [ RunTime:0.046437s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098400s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62137195 LIMIT 5 [ RunTime:0.031064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62137195 ORDER BY `minOrder` ASC [ RunTime:0.068016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62137195 ORDER BY `unit` DESC [ RunTime:0.102753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62137195 LIMIT 2 [ RunTime:0.070380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62137195 ORDER BY `minOrder` ASC [ RunTime:0.051229s ]
select * from pdf where partno='109224' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.052617s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109224' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.051473s ]
SELECT `id` FROM `stock` WHERE `id` <> 62137195 AND `partno` = '109224' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.051703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807452 [ RunTime:0.051511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63462489 LIMIT 5 [ RunTime:0.051106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63462489 ORDER BY `minOrder` ASC [ RunTime:0.051900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63462489 ORDER BY `unit` DESC [ RunTime:0.051258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63462489 LIMIT 2 [ RunTime:0.051187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63462489 ORDER BY `minOrder` ASC [ RunTime:0.051142s ]
select * from pdf where partno='1092241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.051931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092241' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.133888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63348840 LIMIT 5 [ RunTime:0.069413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63348840 ORDER BY `minOrder` ASC [ RunTime:0.051394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63348840 ORDER BY `unit` DESC [ RunTime:0.066246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63348840 LIMIT 2 [ RunTime:0.095416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63348840 ORDER BY `minOrder` ASC [ RunTime:0.047058s ]
select * from pdf where partno='1092231' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.078168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092231' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037987s ]
SELECT `id` FROM `stock` WHERE `id` <> 63348840 AND `partno` = '1092231' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011886 [ RunTime:0.050549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63343574 LIMIT 5 [ RunTime:0.032633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343574 ORDER BY `minOrder` ASC [ RunTime:0.052139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63343574 ORDER BY `unit` DESC [ RunTime:0.052750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63343574 LIMIT 2 [ RunTime:0.056728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343574 ORDER BY `minOrder` ASC [ RunTime:0.020999s ]
select * from pdf where partno='1092299' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.074496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092299' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.082692s ]
SELECT `id` FROM `stock` WHERE `id` <> 63343574 AND `partno` = '1092299' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778927 [ RunTime:0.084936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63342954 LIMIT 5 [ RunTime:0.087949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342954 ORDER BY `minOrder` ASC [ RunTime:0.023010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63342954 ORDER BY `unit` DESC [ RunTime:0.023922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63342954 LIMIT 2 [ RunTime:0.069717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342954 ORDER BY `minOrder` ASC [ RunTime:0.073630s ]
select * from pdf where partno='1092292' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.087653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092292' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.071605s ]
SELECT `id` FROM `stock` WHERE `id` <> 63342954 AND `partno` = '1092292' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778531 [ RunTime:0.048829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63342871 LIMIT 5 [ RunTime:0.026588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342871 ORDER BY `minOrder` ASC [ RunTime:0.033745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63342871 ORDER BY `unit` DESC [ RunTime:0.038632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63342871 LIMIT 2 [ RunTime:0.035872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342871 ORDER BY `minOrder` ASC [ RunTime:0.038964s ]
select * from pdf where partno='1092210' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.042148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092210' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.053844s ]
SELECT `id` FROM `stock` WHERE `id` <> 63342871 AND `partno` = '1092210' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.042971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224641 [ RunTime:0.012864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340074 LIMIT 5 [ RunTime:0.021846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340074 ORDER BY `minOrder` ASC [ RunTime:0.008961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340074 ORDER BY `unit` DESC [ RunTime:0.013621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340074 LIMIT 2 [ RunTime:0.023139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340074 ORDER BY `minOrder` ASC [ RunTime:0.029257s ]
select * from pdf where partno='1092209' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092209' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023700s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340074 AND `partno` = '1092209' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226131 [ RunTime:0.005354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63314200 LIMIT 5 [ RunTime:0.020901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314200 ORDER BY `minOrder` ASC [ RunTime:0.005780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63314200 ORDER BY `unit` DESC [ RunTime:0.029248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63314200 LIMIT 2 [ RunTime:0.025691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314200 ORDER BY `minOrder` ASC [ RunTime:0.019191s ]
select * from pdf where partno='1092259' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092259' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.042652s ]
SELECT `id` FROM `stock` WHERE `id` <> 63314200 AND `partno` = '1092259' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958379 [ RunTime:0.032552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63201329 LIMIT 5 [ RunTime:0.017098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201329 ORDER BY `minOrder` ASC [ RunTime:0.015209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63201329 ORDER BY `unit` DESC [ RunTime:0.010944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63201329 LIMIT 2 [ RunTime:0.007745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201329 ORDER BY `minOrder` ASC [ RunTime:0.002202s ]
select * from pdf where partno='1092257' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092257' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002468s ]
SELECT `id` FROM `stock` WHERE `id` <> 63201329 AND `partno` = '1092257' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975321 [ RunTime:0.003602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200132 LIMIT 5 [ RunTime:0.014621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200132 ORDER BY `minOrder` ASC [ RunTime:0.015079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200132 ORDER BY `unit` DESC [ RunTime:0.011376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200132 LIMIT 2 [ RunTime:0.012436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200132 ORDER BY `minOrder` ASC [ RunTime:0.007976s ]
select * from pdf where partno='1092202' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092202' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020089s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200132 AND `partno` = '1092202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982895 [ RunTime:0.007044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198464 LIMIT 5 [ RunTime:0.010921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198464 ORDER BY `minOrder` ASC [ RunTime:0.007985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198464 ORDER BY `unit` DESC [ RunTime:0.016268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198464 LIMIT 2 [ RunTime:0.019501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198464 ORDER BY `minOrder` ASC [ RunTime:0.009734s ]
select * from pdf where partno='1092266' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092266' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018854s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198464 AND `partno` = '1092266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049127 [ RunTime:0.012534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198455 LIMIT 5 [ RunTime:0.013926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198455 ORDER BY `minOrder` ASC [ RunTime:0.013599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198455 ORDER BY `unit` DESC [ RunTime:0.009170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198455 LIMIT 2 [ RunTime:0.017032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198455 ORDER BY `minOrder` ASC [ RunTime:0.008763s ]
select * from pdf where partno='1092265' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092265' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009951s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198455 AND `partno` = '1092265' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981348 [ RunTime:0.008294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62196831 LIMIT 5 [ RunTime:0.016330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62196831 ORDER BY `minOrder` ASC [ RunTime:0.013838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62196831 ORDER BY `unit` DESC [ RunTime:0.006099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62196831 LIMIT 2 [ RunTime:0.012396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62196831 ORDER BY `minOrder` ASC [ RunTime:0.008982s ]
select * from pdf where partno='109223' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.006949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109223' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.014887s ]
SELECT `id` FROM `stock` WHERE `id` <> 62196831 AND `partno` = '109223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.012919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14691989 [ RunTime:0.011166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58525461 LIMIT 5 [ RunTime:0.011731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525461 ORDER BY `minOrder` ASC [ RunTime:0.007152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58525461 ORDER BY `unit` DESC [ RunTime:0.007524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58525461 LIMIT 2 [ RunTime:0.009386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525461 ORDER BY `minOrder` ASC [ RunTime:0.023406s ]
select * from pdf where partno='10922' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.013110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10922' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.020262s ]
SELECT `id` FROM `stock` WHERE `id` <> 58525461 AND `partno` = '10922' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.003694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171560 [ RunTime:0.010626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57984670 LIMIT 5 [ RunTime:0.018773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984670 ORDER BY `minOrder` ASC [ RunTime:0.003591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57984670 ORDER BY `unit` DESC [ RunTime:0.002992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57984670 LIMIT 2 [ RunTime:0.002323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984670 ORDER BY `minOrder` ASC [ RunTime:0.004186s ]
select * from pdf where partno='1092207' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092207' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006373s ]
SELECT `id` FROM `stock` WHERE `id` <> 57984670 AND `partno` = '1092207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010638 [ RunTime:0.001732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57701229 LIMIT 5 [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701229 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57701229 ORDER BY `unit` DESC [ RunTime:0.001515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57701229 LIMIT 2 [ RunTime:0.003624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57701229 ORDER BY `minOrder` ASC [ RunTime:0.001751s ]
select * from pdf where partno='109220' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109220' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.051174s ]
SELECT `id` FROM `stock` WHERE `id` <> 57701229 AND `partno` = '109220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.051134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14397067 [ RunTime:0.008127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700177 LIMIT 5 [ RunTime:0.043189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700177 ORDER BY `minOrder` ASC [ RunTime:0.030603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700177 ORDER BY `unit` DESC [ RunTime:0.046907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700177 LIMIT 2 [ RunTime:0.029369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700177 ORDER BY `minOrder` ASC [ RunTime:0.030517s ]
select * from pdf where partno='109222' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109222' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.033123s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700177 AND `partno` = '109222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13525658 [ RunTime:0.020448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57698993 LIMIT 5 [ RunTime:0.021925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57698993 ORDER BY `minOrder` ASC [ RunTime:0.028781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57698993 ORDER BY `unit` DESC [ RunTime:0.037079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57698993 LIMIT 2 [ RunTime:0.051202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57698993 ORDER BY `minOrder` ASC [ RunTime:0.018637s ]
select * from pdf where partno='109221' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109221' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.025268s ]
SELECT `id` FROM `stock` WHERE `id` <> 57698993 AND `partno` = '109221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396012 [ RunTime:0.000820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696532 LIMIT 5 [ RunTime:0.005351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696532 ORDER BY `minOrder` ASC [ RunTime:0.005892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696532 ORDER BY `unit` DESC [ RunTime:0.000558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696532 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696532 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='109223-PK' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109223-PK' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001773s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696532 AND `partno` = '109223-PK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394995 [ RunTime:0.002247s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001452s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000618s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000591s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002931s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000598s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000593s ]
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 '10922%' OR `brand` LIKE '10922%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000876s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10922%' OR `brand` LIKE '10922%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000992s ]