SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001472s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.231' , `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=11091&search=1' [ RunTime:0.004386s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001726s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001632s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001351s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.231' ) [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001493s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003258s ]
SELECT * FROM `stock_search` WHERE `partno` = '11091' LIMIT 1 [ RunTime:0.000620s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-09-27 07:49:00' WHERE `partno` = '11091' [ RunTime:0.002639s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002753s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006327s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474123 LIMIT 5 [ RunTime:0.000772s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474123 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474123 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474123 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474123 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474122 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474122 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474122 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474122 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474122 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474691 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474691 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13474691 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13474691 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13474691 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19141472 LIMIT 5 [ RunTime:0.001400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141472 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19141472 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19141472 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141472 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980529 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980529 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980529 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980529 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980529 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980408 LIMIT 5 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980408 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980408 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980408 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980408 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979823 LIMIT 5 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979823 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979823 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979823 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979823 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18978892 LIMIT 5 [ RunTime:0.001167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978892 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18978892 ORDER BY `unit` DESC [ RunTime:0.000516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18978892 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18978892 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837334 LIMIT 5 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837334 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837334 ORDER BY `unit` DESC [ RunTime:0.000482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837334 LIMIT 2 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837334 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837064 LIMIT 5 [ RunTime:0.001479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837064 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837064 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837064 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837064 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836776 LIMIT 5 [ RunTime:0.000937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836776 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836776 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836776 LIMIT 2 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836776 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18796883 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18796883 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18796883 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18796883 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18796883 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786624 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786624 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786624 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786624 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786624 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784102 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784102 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784102 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784102 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784102 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772200 LIMIT 5 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772200 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772200 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772200 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772200 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049245 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049245 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049245 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049245 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049245 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048892 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048892 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17048892 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17048892 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048892 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013688 LIMIT 5 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013688 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013688 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013688 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013688 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012575 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012575 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012575 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012575 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012575 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266540 LIMIT 5 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266540 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266540 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266540 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266540 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000725s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71259473 LIMIT 5 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71259473 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71259473 ORDER BY `unit` DESC [ RunTime:0.000698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71259473 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71259473 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='1109130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000645s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109130000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000712s ]
SELECT `id` FROM `stock` WHERE `id` <> 71259473 AND `partno` = '1109130000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474693 [ RunTime:0.000707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71260291 LIMIT 5 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71260291 ORDER BY `minOrder` ASC [ RunTime:0.000742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71260291 ORDER BY `unit` DESC [ RunTime:0.000306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71260291 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71260291 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='1109180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001008s ]
SELECT `id` FROM `stock` WHERE `id` <> 71260291 AND `partno` = '1109180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474123 [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71259935 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71259935 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71259935 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71259935 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71259935 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='1109150000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109150000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000951s ]
SELECT `id` FROM `stock` WHERE `id` <> 71259935 AND `partno` = '1109150000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474122 [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71260891 LIMIT 5 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71260891 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71260891 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71260891 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71260891 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='1109140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000963s ]
SELECT `id` FROM `stock` WHERE `id` <> 71260891 AND `partno` = '1109140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13474691 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71228878 LIMIT 5 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71228878 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71228878 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71228878 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71228878 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='1109160' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109160' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000473s ]
SELECT `id` FROM `stock` WHERE `id` <> 71228878 AND `partno` = '1109160' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15235818 [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71228867 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71228867 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71228867 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71228867 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71228867 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='1109152' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109152' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000468s ]
SELECT `id` FROM `stock` WHERE `id` <> 71228867 AND `partno` = '1109152' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012575 [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71565611 LIMIT 5 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71565611 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71565611 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71565611 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71565611 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='1109139' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109139' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000364s ]
SELECT `id` FROM `stock` WHERE `id` <> 71565611 AND `partno` = '1109139' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223801 [ RunTime:0.001548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71561619 LIMIT 5 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71561619 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71561619 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71561619 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71561619 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='1109140' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109140' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000319s ]
SELECT `id` FROM `stock` WHERE `id` <> 71561619 AND `partno` = '1109140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772200 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71551136 LIMIT 5 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71551136 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71551136 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71551136 LIMIT 2 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71551136 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='1109130' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109130' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000333s ]
SELECT `id` FROM `stock` WHERE `id` <> 71551136 AND `partno` = '1109130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18796883 [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71232644 LIMIT 5 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71232644 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71232644 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71232644 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71232644 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='1109102' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109102' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000363s ]
SELECT `id` FROM `stock` WHERE `id` <> 71232644 AND `partno` = '1109102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837334 [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71232387 LIMIT 5 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71232387 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71232387 ORDER BY `unit` DESC [ RunTime:0.000238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71232387 LIMIT 2 [ RunTime:0.000230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71232387 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='1109101' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109101' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000318s ]
SELECT `id` FROM `stock` WHERE `id` <> 71232387 AND `partno` = '1109101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013688 [ RunTime:0.000273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71232175 LIMIT 5 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71232175 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71232175 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71232175 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71232175 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='1109105' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109105' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000304s ]
SELECT `id` FROM `stock` WHERE `id` <> 71232175 AND `partno` = '1109105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837064 [ RunTime:0.000260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71231715 LIMIT 5 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71231715 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71231715 ORDER BY `unit` DESC [ RunTime:0.000240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71231715 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71231715 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='1109104' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109104' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000295s ]
SELECT `id` FROM `stock` WHERE `id` <> 71231715 AND `partno` = '1109104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836776 [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71216437 LIMIT 5 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71216437 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71216437 ORDER BY `unit` DESC [ RunTime:0.000240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71216437 LIMIT 2 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71216437 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
select * from pdf where partno='1109110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109110000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT `id` FROM `stock` WHERE `id` <> 71216437 AND `partno` = '1109110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19141472 [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70125207 LIMIT 5 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70125207 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70125207 ORDER BY `unit` DESC [ RunTime:0.000239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70125207 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70125207 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
select * from pdf where partno='1109135' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109135' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000312s ]
SELECT `id` FROM `stock` WHERE `id` <> 70125207 AND `partno` = '1109135' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224701 [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70122110 LIMIT 5 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70122110 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70122110 ORDER BY `unit` DESC [ RunTime:0.000240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70122110 LIMIT 2 [ RunTime:0.000227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70122110 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='1109100' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109100' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000362s ]
SELECT `id` FROM `stock` WHERE `id` <> 70122110 AND `partno` = '1109100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786624 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70081248 LIMIT 5 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70081248 ORDER BY `minOrder` ASC [ RunTime:0.001266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70081248 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70081248 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70081248 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='1109177' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109177' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000527s ]
SELECT `id` FROM `stock` WHERE `id` <> 70081248 AND `partno` = '1109177' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419341 [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69982439 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69982439 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69982439 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69982439 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69982439 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='1109128' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109128' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000488s ]
SELECT `id` FROM `stock` WHERE `id` <> 69982439 AND `partno` = '1109128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266540 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69982147 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69982147 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69982147 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69982147 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69982147 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='1109113' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109113' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000510s ]
SELECT `id` FROM `stock` WHERE `id` <> 69982147 AND `partno` = '1109113' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049245 [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69980801 LIMIT 5 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69980801 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69980801 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69980801 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69980801 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='1109180' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1109180' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000404s ]
SELECT `id` FROM `stock` WHERE `id` <> 69980801 AND `partno` = '1109180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266169 [ RunTime:0.000624s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000694s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000628s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000661s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000603s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000681s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000589s ]
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 '11091%' OR `brand` LIKE '11091%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000647s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '11091%' OR `brand` LIKE '11091%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001055s ]