SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002206s ]
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=10375&search=1' [ RunTime:0.003477s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002308s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002219s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000432s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002051s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002708s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002676s ]
SELECT * FROM `stock_search` WHERE `partno` = '10375' LIMIT 1 [ RunTime:0.002946s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 14:16:14' WHERE `partno` = '10375' [ RunTime:0.009883s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002263s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030755s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066185 LIMIT 5 [ RunTime:0.008521s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066185 ORDER BY `minOrder` ASC [ RunTime:0.011781s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066185 ORDER BY `unit` DESC [ RunTime:0.011550s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066185 LIMIT 2 [ RunTime:0.013539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066185 ORDER BY `minOrder` ASC [ RunTime:0.016742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13367694 LIMIT 5 [ RunTime:0.004546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13367694 ORDER BY `minOrder` ASC [ RunTime:0.011952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13367694 ORDER BY `unit` DESC [ RunTime:0.012081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13367694 LIMIT 2 [ RunTime:0.008598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13367694 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549968 LIMIT 5 [ RunTime:0.005240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549968 ORDER BY `minOrder` ASC [ RunTime:0.005989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13549968 ORDER BY `unit` DESC [ RunTime:0.012082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13549968 LIMIT 2 [ RunTime:0.002964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549968 ORDER BY `minOrder` ASC [ RunTime:0.007235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11191308 LIMIT 5 [ RunTime:0.008479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11191308 ORDER BY `minOrder` ASC [ RunTime:0.013175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11191308 ORDER BY `unit` DESC [ RunTime:0.004688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11191308 LIMIT 2 [ RunTime:0.006924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11191308 ORDER BY `minOrder` ASC [ RunTime:0.006660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19645098 LIMIT 5 [ RunTime:0.006361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645098 ORDER BY `minOrder` ASC [ RunTime:0.010566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19645098 ORDER BY `unit` DESC [ RunTime:0.012695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19645098 LIMIT 2 [ RunTime:0.008963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19645098 ORDER BY `minOrder` ASC [ RunTime:0.007399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642193 LIMIT 5 [ RunTime:0.010745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642193 ORDER BY `minOrder` ASC [ RunTime:0.019891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642193 ORDER BY `unit` DESC [ RunTime:0.012337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642193 LIMIT 2 [ RunTime:0.014892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642193 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640372 LIMIT 5 [ RunTime:0.002333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640372 ORDER BY `minOrder` ASC [ RunTime:0.031513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19640372 ORDER BY `unit` DESC [ RunTime:0.016037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19640372 LIMIT 2 [ RunTime:0.028334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19640372 ORDER BY `minOrder` ASC [ RunTime:0.002474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638508 LIMIT 5 [ RunTime:0.013526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638508 ORDER BY `minOrder` ASC [ RunTime:0.011470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638508 ORDER BY `unit` DESC [ RunTime:0.014365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638508 LIMIT 2 [ RunTime:0.014821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638508 ORDER BY `minOrder` ASC [ RunTime:0.008906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19633060 LIMIT 5 [ RunTime:0.034472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633060 ORDER BY `minOrder` ASC [ RunTime:0.037682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19633060 ORDER BY `unit` DESC [ RunTime:0.020160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19633060 LIMIT 2 [ RunTime:0.027147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633060 ORDER BY `minOrder` ASC [ RunTime:0.009927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19624293 LIMIT 5 [ RunTime:0.024838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19624293 ORDER BY `minOrder` ASC [ RunTime:0.014741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19624293 ORDER BY `unit` DESC [ RunTime:0.054602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19624293 LIMIT 2 [ RunTime:0.025429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19624293 ORDER BY `minOrder` ASC [ RunTime:0.029016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982589 LIMIT 5 [ RunTime:0.038762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982589 ORDER BY `minOrder` ASC [ RunTime:0.014265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982589 ORDER BY `unit` DESC [ RunTime:0.007238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982589 LIMIT 2 [ RunTime:0.023019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982589 ORDER BY `minOrder` ASC [ RunTime:0.005162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982159 LIMIT 5 [ RunTime:0.011383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982159 ORDER BY `minOrder` ASC [ RunTime:0.007435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982159 ORDER BY `unit` DESC [ RunTime:0.011616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982159 LIMIT 2 [ RunTime:0.020287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982159 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981353 LIMIT 5 [ RunTime:0.008236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981353 ORDER BY `minOrder` ASC [ RunTime:0.010148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981353 ORDER BY `unit` DESC [ RunTime:0.016946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981353 LIMIT 2 [ RunTime:0.011719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981353 ORDER BY `minOrder` ASC [ RunTime:0.004834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980981 LIMIT 5 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980981 ORDER BY `minOrder` ASC [ RunTime:0.004970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980981 ORDER BY `unit` DESC [ RunTime:0.001133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980981 LIMIT 2 [ RunTime:0.005194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980981 ORDER BY `minOrder` ASC [ RunTime:0.003315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980919 LIMIT 5 [ RunTime:0.005478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980919 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980919 ORDER BY `unit` DESC [ RunTime:0.002255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980919 LIMIT 2 [ RunTime:0.004363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980919 ORDER BY `minOrder` ASC [ RunTime:0.005636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980772 LIMIT 5 [ RunTime:0.010450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980772 ORDER BY `minOrder` ASC [ RunTime:0.018389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980772 ORDER BY `unit` DESC [ RunTime:0.004966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980772 LIMIT 2 [ RunTime:0.009476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980772 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980717 LIMIT 5 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980717 ORDER BY `minOrder` ASC [ RunTime:0.003399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980717 ORDER BY `unit` DESC [ RunTime:0.002432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980717 LIMIT 2 [ RunTime:0.012051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980717 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980635 LIMIT 5 [ RunTime:0.009498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980635 ORDER BY `minOrder` ASC [ RunTime:0.013457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980635 ORDER BY `unit` DESC [ RunTime:0.017819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980635 LIMIT 2 [ RunTime:0.010075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980635 ORDER BY `minOrder` ASC [ RunTime:0.029143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980491 LIMIT 5 [ RunTime:0.012712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980491 ORDER BY `minOrder` ASC [ RunTime:0.005217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980491 ORDER BY `unit` DESC [ RunTime:0.001495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980491 LIMIT 2 [ RunTime:0.017208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980491 ORDER BY `minOrder` ASC [ RunTime:0.003053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980380 LIMIT 5 [ RunTime:0.006571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980380 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980380 ORDER BY `unit` DESC [ RunTime:0.007405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980380 LIMIT 2 [ RunTime:0.007113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980380 ORDER BY `minOrder` ASC [ RunTime:0.009983s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017535s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526179 LIMIT 5 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526179 ORDER BY `minOrder` ASC [ RunTime:0.003588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526179 ORDER BY `unit` DESC [ RunTime:0.002299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526179 LIMIT 2 [ RunTime:0.004000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526179 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='10375' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.002928s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10375' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.001798s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526179 AND `partno` = '10375' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.002661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13367694 [ RunTime:0.003886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57737873 LIMIT 5 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737873 ORDER BY `minOrder` ASC [ RunTime:0.007983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57737873 ORDER BY `unit` DESC [ RunTime:0.008793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57737873 LIMIT 2 [ RunTime:0.003416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737873 ORDER BY `minOrder` ASC [ RunTime:0.008848s ]
select * from pdf where partno='10375CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10375CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013753s ]
SELECT `id` FROM `stock` WHERE `id` <> 57737873 AND `partno` = '10375CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066185 [ RunTime:0.003223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57705468 LIMIT 5 [ RunTime:0.005843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57705468 ORDER BY `minOrder` ASC [ RunTime:0.021211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57705468 ORDER BY `unit` DESC [ RunTime:0.002188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57705468 LIMIT 2 [ RunTime:0.005435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57705468 ORDER BY `minOrder` ASC [ RunTime:0.007589s ]
select * from pdf where partno='103753' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103753' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010478s ]
SELECT `id` FROM `stock` WHERE `id` <> 57705468 AND `partno` = '103753' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549968 [ RunTime:0.004465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58569662 LIMIT 5 [ RunTime:0.004750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58569662 ORDER BY `minOrder` ASC [ RunTime:0.010848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58569662 ORDER BY `unit` DESC [ RunTime:0.008093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58569662 LIMIT 2 [ RunTime:0.011291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58569662 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
select * from pdf where partno='10375' and brandshort='Aven Tools' limit 1 [ RunTime:0.003106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10375' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.014081s ]
SELECT `id` FROM `stock` WHERE `id` <> 58569662 AND `partno` = '10375' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.002092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11191308 [ RunTime:0.004797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380707 LIMIT 5 [ RunTime:0.002573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380707 ORDER BY `minOrder` ASC [ RunTime:0.013214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380707 ORDER BY `unit` DESC [ RunTime:0.003827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380707 LIMIT 2 [ RunTime:0.009824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380707 ORDER BY `minOrder` ASC [ RunTime:0.002397s ]
select * from pdf where partno='10375F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10375F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.017180s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380707 AND `partno` = '10375F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.011221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380049 LIMIT 5 [ RunTime:0.027415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380049 ORDER BY `minOrder` ASC [ RunTime:0.009286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380049 ORDER BY `unit` DESC [ RunTime:0.015348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380049 LIMIT 2 [ RunTime:0.003223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380049 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='10375' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10375' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.005275s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380049 AND `partno` = '10375' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.012466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200840 LIMIT 5 [ RunTime:0.003670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200840 ORDER BY `minOrder` ASC [ RunTime:0.015484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200840 ORDER BY `unit` DESC [ RunTime:0.003810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200840 LIMIT 2 [ RunTime:0.002261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200840 ORDER BY `minOrder` ASC [ RunTime:0.003272s ]
select * from pdf where partno='1037521' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037521' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013114s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200840 AND `partno` = '1037521' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974895 [ RunTime:0.004149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200784 LIMIT 5 [ RunTime:0.001530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200784 ORDER BY `minOrder` ASC [ RunTime:0.001224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200784 ORDER BY `unit` DESC [ RunTime:0.003446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200784 LIMIT 2 [ RunTime:0.007918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200784 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
select * from pdf where partno='1037522' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037522' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004509s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200784 AND `partno` = '1037522' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974985 [ RunTime:0.003022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200783 LIMIT 5 [ RunTime:0.010505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200783 ORDER BY `minOrder` ASC [ RunTime:0.002485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200783 ORDER BY `unit` DESC [ RunTime:0.003303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200783 LIMIT 2 [ RunTime:0.009062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200783 ORDER BY `minOrder` ASC [ RunTime:0.004911s ]
select * from pdf where partno='1037512' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037512' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005249s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200783 AND `partno` = '1037512' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974984 [ RunTime:0.022746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200716 LIMIT 5 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200716 ORDER BY `minOrder` ASC [ RunTime:0.005690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200716 ORDER BY `unit` DESC [ RunTime:0.002379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200716 LIMIT 2 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200716 ORDER BY `minOrder` ASC [ RunTime:0.003802s ]
select * from pdf where partno='1037511' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037511' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002577s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200716 AND `partno` = '1037511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974897 [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200695 LIMIT 5 [ RunTime:0.009598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200695 ORDER BY `minOrder` ASC [ RunTime:0.007925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200695 ORDER BY `unit` DESC [ RunTime:0.006722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200695 LIMIT 2 [ RunTime:0.008576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200695 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
select * from pdf where partno='1037508' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037508' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006631s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200695 AND `partno` = '1037508' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974869 [ RunTime:0.019067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200692 LIMIT 5 [ RunTime:0.008999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200692 ORDER BY `minOrder` ASC [ RunTime:0.005397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200692 ORDER BY `unit` DESC [ RunTime:0.011405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200692 LIMIT 2 [ RunTime:0.003805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200692 ORDER BY `minOrder` ASC [ RunTime:0.011630s ]
select * from pdf where partno='1037509' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037509' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011461s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200692 AND `partno` = '1037509' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974868 [ RunTime:0.011590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200690 LIMIT 5 [ RunTime:0.039850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200690 ORDER BY `minOrder` ASC [ RunTime:0.040521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200690 ORDER BY `unit` DESC [ RunTime:0.051091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200690 LIMIT 2 [ RunTime:0.016808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200690 ORDER BY `minOrder` ASC [ RunTime:0.021833s ]
select * from pdf where partno='1037510' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037510' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008759s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200690 AND `partno` = '1037510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974867 [ RunTime:0.016186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200688 LIMIT 5 [ RunTime:0.031858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200688 ORDER BY `minOrder` ASC [ RunTime:0.017192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200688 ORDER BY `unit` DESC [ RunTime:0.012093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200688 LIMIT 2 [ RunTime:0.024657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200688 ORDER BY `minOrder` ASC [ RunTime:0.017464s ]
select * from pdf where partno='1037520' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037520' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002347s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200688 AND `partno` = '1037520' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974866 [ RunTime:0.004288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200686 LIMIT 5 [ RunTime:0.010457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200686 ORDER BY `minOrder` ASC [ RunTime:0.010392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200686 ORDER BY `unit` DESC [ RunTime:0.007759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200686 LIMIT 2 [ RunTime:0.021032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200686 ORDER BY `minOrder` ASC [ RunTime:0.001563s ]
select * from pdf where partno='1037518' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037518' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001384s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200686 AND `partno` = '1037518' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974865 [ RunTime:0.012151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200685 LIMIT 5 [ RunTime:0.004018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200685 ORDER BY `minOrder` ASC [ RunTime:0.005647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200685 ORDER BY `unit` DESC [ RunTime:0.005193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200685 LIMIT 2 [ RunTime:0.008058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200685 ORDER BY `minOrder` ASC [ RunTime:0.001327s ]
select * from pdf where partno='1037519' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037519' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012254s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200685 AND `partno` = '1037519' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265181 [ RunTime:0.027519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200650 LIMIT 5 [ RunTime:0.027620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200650 ORDER BY `minOrder` ASC [ RunTime:0.016556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200650 ORDER BY `unit` DESC [ RunTime:0.014062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200650 LIMIT 2 [ RunTime:0.028179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200650 ORDER BY `minOrder` ASC [ RunTime:0.016905s ]
select * from pdf where partno='1037507' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037507' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021370s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200650 AND `partno` = '1037507' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974619 [ RunTime:0.027568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200648 LIMIT 5 [ RunTime:0.041619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200648 ORDER BY `minOrder` ASC [ RunTime:0.027540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200648 ORDER BY `unit` DESC [ RunTime:0.025139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200648 LIMIT 2 [ RunTime:0.013733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200648 ORDER BY `minOrder` ASC [ RunTime:0.005705s ]
select * from pdf where partno='1037517' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037517' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004810s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200648 AND `partno` = '1037517' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265131 [ RunTime:0.017894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200613 LIMIT 5 [ RunTime:0.006732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200613 ORDER BY `minOrder` ASC [ RunTime:0.004258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200613 ORDER BY `unit` DESC [ RunTime:0.006171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200613 LIMIT 2 [ RunTime:0.005349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200613 ORDER BY `minOrder` ASC [ RunTime:0.010915s ]
select * from pdf where partno='1037506' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037506' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001373s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200613 AND `partno` = '1037506' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048108 [ RunTime:0.016828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200612 LIMIT 5 [ RunTime:0.014400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200612 ORDER BY `minOrder` ASC [ RunTime:0.007379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200612 ORDER BY `unit` DESC [ RunTime:0.005711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200612 LIMIT 2 [ RunTime:0.006433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200612 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
select * from pdf where partno='1037516' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1037516' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008373s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200612 AND `partno` = '1037516' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048106 [ RunTime:0.004416s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027665s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032287s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002939s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015685s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013240s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026350s ]
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 '10375%' OR `brand` LIKE '10375%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009194s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10375%' OR `brand` LIKE '10375%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009108s ]