SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001894s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=9631&search=1' [ RunTime:0.002063s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002120s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000483s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002206s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.001899s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002714s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004675s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002558s ]
SELECT * FROM `stock_search` WHERE `partno` = '9631' LIMIT 1 [ RunTime:0.003083s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-09 03:44:46' WHERE `partno` = '9631' [ RunTime:0.012230s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002462s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018838s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612886 LIMIT 5 [ RunTime:0.000827s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612886 ORDER BY `minOrder` ASC [ RunTime:0.008905s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612886 ORDER BY `unit` DESC [ RunTime:0.006146s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612886 LIMIT 2 [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612886 ORDER BY `minOrder` ASC [ RunTime:0.007846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613080 LIMIT 5 [ RunTime:0.001509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613080 ORDER BY `minOrder` ASC [ RunTime:0.002592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613080 ORDER BY `unit` DESC [ RunTime:0.001619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613080 LIMIT 2 [ RunTime:0.006333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613080 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484091 LIMIT 5 [ RunTime:0.010843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484091 ORDER BY `minOrder` ASC [ RunTime:0.023912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484091 ORDER BY `unit` DESC [ RunTime:0.025059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484091 LIMIT 2 [ RunTime:0.019364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484091 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313839 LIMIT 5 [ RunTime:0.004157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313839 ORDER BY `minOrder` ASC [ RunTime:0.013767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313839 ORDER BY `unit` DESC [ RunTime:0.024335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313839 LIMIT 2 [ RunTime:0.017948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313839 ORDER BY `minOrder` ASC [ RunTime:0.009621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995 LIMIT 5 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995 ORDER BY `minOrder` ASC [ RunTime:0.021145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11995 ORDER BY `unit` DESC [ RunTime:0.016641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11995 LIMIT 2 [ RunTime:0.024955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995 ORDER BY `minOrder` ASC [ RunTime:0.006790s ]
select * from pdf where partno='963142-2' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.024225s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963142-2' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.041625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13309465 LIMIT 5 [ RunTime:0.038223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13309465 ORDER BY `minOrder` ASC [ RunTime:0.021661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13309465 ORDER BY `unit` DESC [ RunTime:0.031101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13309465 LIMIT 2 [ RunTime:0.040390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13309465 ORDER BY `minOrder` ASC [ RunTime:0.012008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313356 LIMIT 5 [ RunTime:0.051234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313356 ORDER BY `minOrder` ASC [ RunTime:0.036569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13313356 ORDER BY `unit` DESC [ RunTime:0.049898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13313356 LIMIT 2 [ RunTime:0.002894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13313356 ORDER BY `minOrder` ASC [ RunTime:0.028186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13309449 LIMIT 5 [ RunTime:0.031878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13309449 ORDER BY `minOrder` ASC [ RunTime:0.030346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13309449 ORDER BY `unit` DESC [ RunTime:0.006787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13309449 LIMIT 2 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13309449 ORDER BY `minOrder` ASC [ RunTime:0.013481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316061 LIMIT 5 [ RunTime:0.018176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316061 ORDER BY `minOrder` ASC [ RunTime:0.004859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316061 ORDER BY `unit` DESC [ RunTime:0.008731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316061 LIMIT 2 [ RunTime:0.014288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316061 ORDER BY `minOrder` ASC [ RunTime:0.011676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316062 LIMIT 5 [ RunTime:0.016124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316062 ORDER BY `minOrder` ASC [ RunTime:0.026065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316062 ORDER BY `unit` DESC [ RunTime:0.010022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316062 LIMIT 2 [ RunTime:0.005992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316062 ORDER BY `minOrder` ASC [ RunTime:0.006396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042409 LIMIT 5 [ RunTime:0.014222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042409 ORDER BY `minOrder` ASC [ RunTime:0.010286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042409 ORDER BY `unit` DESC [ RunTime:0.007829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042409 LIMIT 2 [ RunTime:0.006721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042409 ORDER BY `minOrder` ASC [ RunTime:0.002998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039336 LIMIT 5 [ RunTime:0.012914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039336 ORDER BY `minOrder` ASC [ RunTime:0.005939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039336 ORDER BY `unit` DESC [ RunTime:0.015379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039336 LIMIT 2 [ RunTime:0.037346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039336 ORDER BY `minOrder` ASC [ RunTime:0.036507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316063 LIMIT 5 [ RunTime:0.005280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316063 ORDER BY `minOrder` ASC [ RunTime:0.037874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316063 ORDER BY `unit` DESC [ RunTime:0.009714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316063 LIMIT 2 [ RunTime:0.045249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316063 ORDER BY `minOrder` ASC [ RunTime:0.004933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314784 LIMIT 5 [ RunTime:0.026744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314784 ORDER BY `minOrder` ASC [ RunTime:0.015345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314784 ORDER BY `unit` DESC [ RunTime:0.036408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314784 LIMIT 2 [ RunTime:0.024965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314784 ORDER BY `minOrder` ASC [ RunTime:0.019570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629753 LIMIT 5 [ RunTime:0.035682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629753 ORDER BY `minOrder` ASC [ RunTime:0.063145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629753 ORDER BY `unit` DESC [ RunTime:0.042467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629753 LIMIT 2 [ RunTime:0.063334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629753 ORDER BY `minOrder` ASC [ RunTime:0.021585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495360 LIMIT 5 [ RunTime:0.059524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495360 ORDER BY `minOrder` ASC [ RunTime:0.037117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495360 ORDER BY `unit` DESC [ RunTime:0.049445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495360 LIMIT 2 [ RunTime:0.042518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495360 ORDER BY `minOrder` ASC [ RunTime:0.013835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996874 LIMIT 5 [ RunTime:0.027390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996874 ORDER BY `minOrder` ASC [ RunTime:0.103088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18996874 ORDER BY `unit` DESC [ RunTime:0.040254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18996874 LIMIT 2 [ RunTime:0.060419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996874 ORDER BY `minOrder` ASC [ RunTime:0.067686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996864 LIMIT 5 [ RunTime:0.014376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996864 ORDER BY `minOrder` ASC [ RunTime:0.046207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18996864 ORDER BY `unit` DESC [ RunTime:0.037278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18996864 LIMIT 2 [ RunTime:0.068220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996864 ORDER BY `minOrder` ASC [ RunTime:0.006351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165801 LIMIT 5 [ RunTime:0.029988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12165801 ORDER BY `minOrder` ASC [ RunTime:0.029542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12165801 ORDER BY `unit` DESC [ RunTime:0.032532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12165801 LIMIT 2 [ RunTime:0.015948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12165801 ORDER BY `minOrder` ASC [ RunTime:0.008669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165802 LIMIT 5 [ RunTime:0.042342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12165802 ORDER BY `minOrder` ASC [ RunTime:0.043907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12165802 ORDER BY `unit` DESC [ RunTime:0.031331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12165802 LIMIT 2 [ RunTime:0.100486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12165802 ORDER BY `minOrder` ASC [ RunTime:0.012596s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32214956 LIMIT 5 [ RunTime:0.018185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214956 ORDER BY `minOrder` ASC [ RunTime:0.058118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32214956 ORDER BY `unit` DESC [ RunTime:0.039309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32214956 LIMIT 2 [ RunTime:0.065658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32214956 ORDER BY `minOrder` ASC [ RunTime:0.055490s ]
select * from pdf where partno='963100174' and brandshort='wurth elektronik' limit 1 [ RunTime:0.022064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963100174' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.048367s ]
SELECT `id` FROM `stock` WHERE `id` <> 32214956 AND `partno` = '963100174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.035765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313839 [ RunTime:0.058346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32217796 LIMIT 5 [ RunTime:0.022587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32217796 ORDER BY `minOrder` ASC [ RunTime:0.052952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32217796 ORDER BY `unit` DESC [ RunTime:0.032493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32217796 LIMIT 2 [ RunTime:0.004805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32217796 ORDER BY `minOrder` ASC [ RunTime:0.003994s ]
select * from pdf where partno='96310203' and brandshort='bopla' limit 1 [ RunTime:0.049948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96310203' OR `brand` LIKE 'bopla%' ) ) LIMIT 1 [ RunTime:0.018860s ]
SELECT `id` FROM `stock` WHERE `id` <> 32217796 AND `partno` = '96310203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla%' ) [ RunTime:0.066835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997330 [ RunTime:0.035578s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.108686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361330 LIMIT 5 [ RunTime:0.037334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361330 ORDER BY `minOrder` ASC [ RunTime:0.018744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361330 ORDER BY `unit` DESC [ RunTime:0.053625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361330 LIMIT 2 [ RunTime:0.044072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361330 ORDER BY `minOrder` ASC [ RunTime:0.015940s ]
select * from pdf where partno='963142-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.025130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963142-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019817s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361330 AND `partno` = '963142-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.035414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612886 [ RunTime:0.027481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361396 LIMIT 5 [ RunTime:0.005446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361396 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361396 ORDER BY `unit` DESC [ RunTime:0.015564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361396 LIMIT 2 [ RunTime:0.066350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361396 ORDER BY `minOrder` ASC [ RunTime:0.006116s ]
select * from pdf where partno='963143-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.044325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963143-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.047274s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361396 AND `partno` = '963143-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.040947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613080 [ RunTime:0.035121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361356 LIMIT 5 [ RunTime:0.016875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361356 ORDER BY `minOrder` ASC [ RunTime:0.033599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361356 ORDER BY `unit` DESC [ RunTime:0.038151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361356 LIMIT 2 [ RunTime:0.061702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361356 ORDER BY `minOrder` ASC [ RunTime:0.015217s ]
select * from pdf where partno='963142-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963142-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015257s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361356 AND `partno` = '963142-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484091 [ RunTime:0.004931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63391360 LIMIT 5 [ RunTime:0.052791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63391360 ORDER BY `minOrder` ASC [ RunTime:0.038307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63391360 ORDER BY `unit` DESC [ RunTime:0.025904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63391360 LIMIT 2 [ RunTime:0.010654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63391360 ORDER BY `minOrder` ASC [ RunTime:0.001615s ]
select * from pdf where partno='963100174' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.023488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963100174' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.040210s ]
SELECT `id` FROM `stock` WHERE `id` <> 63391360 AND `partno` = '963100174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.023419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313839 [ RunTime:0.003617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63391363 LIMIT 5 [ RunTime:0.028611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63391363 ORDER BY `minOrder` ASC [ RunTime:0.020115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63391363 ORDER BY `unit` DESC [ RunTime:0.013472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63391363 LIMIT 2 [ RunTime:0.015007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63391363 ORDER BY `minOrder` ASC [ RunTime:0.008600s ]
select * from pdf where partno='963150174' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.026161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963150174' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015731s ]
SELECT `id` FROM `stock` WHERE `id` <> 63391363 AND `partno` = '963150174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.016443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63392241 LIMIT 5 [ RunTime:0.012889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392241 ORDER BY `minOrder` ASC [ RunTime:0.031586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63392241 ORDER BY `unit` DESC [ RunTime:0.022105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63392241 LIMIT 2 [ RunTime:0.023157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392241 ORDER BY `minOrder` ASC [ RunTime:0.003956s ]
select * from pdf where partno='963120042' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963120042' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.023889s ]
SELECT `id` FROM `stock` WHERE `id` <> 63392241 AND `partno` = '963120042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.026895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316062 [ RunTime:0.044648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63390293 LIMIT 5 [ RunTime:0.018636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390293 ORDER BY `minOrder` ASC [ RunTime:0.037464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63390293 ORDER BY `unit` DESC [ RunTime:0.108926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63390293 LIMIT 2 [ RunTime:0.024941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390293 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
select * from pdf where partno='963100042' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.025084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963100042' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015016s ]
SELECT `id` FROM `stock` WHERE `id` <> 63390293 AND `partno` = '963100042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.053078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13313356 [ RunTime:0.016249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395042 LIMIT 5 [ RunTime:0.030138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395042 ORDER BY `minOrder` ASC [ RunTime:0.077355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395042 ORDER BY `unit` DESC [ RunTime:0.027952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395042 LIMIT 2 [ RunTime:0.024085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395042 ORDER BY `minOrder` ASC [ RunTime:0.004828s ]
select * from pdf where partno='963120174' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963120174' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005895s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395042 AND `partno` = '963120174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.042404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395043 LIMIT 5 [ RunTime:0.014340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395043 ORDER BY `minOrder` ASC [ RunTime:0.017868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395043 ORDER BY `unit` DESC [ RunTime:0.022124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395043 LIMIT 2 [ RunTime:0.025958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395043 ORDER BY `minOrder` ASC [ RunTime:0.018609s ]
select * from pdf where partno='963150042' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.038823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963150042' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.046621s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395043 AND `partno` = '963150042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.045622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039336 [ RunTime:0.018901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395625 LIMIT 5 [ RunTime:0.027708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395625 ORDER BY `minOrder` ASC [ RunTime:0.016693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395625 ORDER BY `unit` DESC [ RunTime:0.013329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395625 LIMIT 2 [ RunTime:0.037678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395625 ORDER BY `minOrder` ASC [ RunTime:0.004912s ]
select * from pdf where partno='963130174' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963130174' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.013864s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395625 AND `partno` = '963130174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042409 [ RunTime:0.023676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395675 LIMIT 5 [ RunTime:0.020427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395675 ORDER BY `minOrder` ASC [ RunTime:0.035144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395675 ORDER BY `unit` DESC [ RunTime:0.022311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395675 LIMIT 2 [ RunTime:0.034417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395675 ORDER BY `minOrder` ASC [ RunTime:0.007170s ]
select * from pdf where partno='963170042' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.043243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963170042' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010885s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395675 AND `partno` = '963170042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316063 [ RunTime:0.023488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395047 LIMIT 5 [ RunTime:0.029070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395047 ORDER BY `minOrder` ASC [ RunTime:0.021938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395047 ORDER BY `unit` DESC [ RunTime:0.042463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395047 LIMIT 2 [ RunTime:0.042140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395047 ORDER BY `minOrder` ASC [ RunTime:0.030857s ]
select * from pdf where partno='963110042' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.038350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963110042' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.036037s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395047 AND `partno` = '963110042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316061 [ RunTime:0.038896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59939794 LIMIT 5 [ RunTime:0.028381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939794 ORDER BY `minOrder` ASC [ RunTime:0.044457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59939794 ORDER BY `unit` DESC [ RunTime:0.025433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59939794 LIMIT 2 [ RunTime:0.023441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939794 ORDER BY `minOrder` ASC [ RunTime:0.021358s ]
select * from pdf where partno='963121-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '963121-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008604s ]
SELECT `id` FROM `stock` WHERE `id` <> 59939794 AND `partno` = '963121-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.035800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629753 [ RunTime:0.001801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63459944 LIMIT 5 [ RunTime:0.013738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63459944 ORDER BY `minOrder` ASC [ RunTime:0.005518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63459944 ORDER BY `unit` DESC [ RunTime:0.012732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63459944 LIMIT 2 [ RunTime:0.021347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63459944 ORDER BY `minOrder` ASC [ RunTime:0.018619s ]
select * from pdf where partno='96310109' and brandshort='Bopla Enclosures' limit 1 [ RunTime:0.012567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96310109' OR `brand` LIKE 'Bopla Enclosures%' ) ) LIMIT 1 [ RunTime:0.006993s ]
SELECT `id` FROM `stock` WHERE `id` <> 63459944 AND `partno` = '96310109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla enclosures%' ) [ RunTime:0.014256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996864 [ RunTime:0.023733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460084 LIMIT 5 [ RunTime:0.011701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460084 ORDER BY `minOrder` ASC [ RunTime:0.020636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460084 ORDER BY `unit` DESC [ RunTime:0.002240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460084 LIMIT 2 [ RunTime:0.008741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460084 ORDER BY `minOrder` ASC [ RunTime:0.030003s ]
select * from pdf where partno='96310103' and brandshort='Bopla Enclosures' limit 1 [ RunTime:0.008529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96310103' OR `brand` LIKE 'Bopla Enclosures%' ) ) LIMIT 1 [ RunTime:0.016966s ]
SELECT `id` FROM `stock` WHERE `id` <> 63460084 AND `partno` = '96310103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla enclosures%' ) [ RunTime:0.019743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996874 [ RunTime:0.014410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58562977 LIMIT 5 [ RunTime:0.010470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562977 ORDER BY `minOrder` ASC [ RunTime:0.016385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58562977 ORDER BY `unit` DESC [ RunTime:0.009504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58562977 LIMIT 2 [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562977 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='96315' and brandshort='Wiha' limit 1 [ RunTime:0.012052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96315' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.007554s ]
SELECT `id` FROM `stock` WHERE `id` <> 58562977 AND `partno` = '96315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.018040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165802 [ RunTime:0.003536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58562978 LIMIT 5 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562978 ORDER BY `minOrder` ASC [ RunTime:0.008090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58562978 ORDER BY `unit` DESC [ RunTime:0.007055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58562978 LIMIT 2 [ RunTime:0.009683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562978 ORDER BY `minOrder` ASC [ RunTime:0.003608s ]
select * from pdf where partno='96313' and brandshort='Wiha' limit 1 [ RunTime:0.008400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96313' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.025415s ]
SELECT `id` FROM `stock` WHERE `id` <> 58562978 AND `partno` = '96313' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.019999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165801 [ RunTime:0.024486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58563287 LIMIT 5 [ RunTime:0.008926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58563287 ORDER BY `minOrder` ASC [ RunTime:0.016684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58563287 ORDER BY `unit` DESC [ RunTime:0.014066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58563287 LIMIT 2 [ RunTime:0.011552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58563287 ORDER BY `minOrder` ASC [ RunTime:0.001346s ]
select * from pdf where partno='96316' and brandshort='Wiha' limit 1 [ RunTime:0.009958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96316' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.012102s ]
SELECT `id` FROM `stock` WHERE `id` <> 58563287 AND `partno` = '96316' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.025559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11184081 [ RunTime:0.008311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461633 LIMIT 5 [ RunTime:0.012570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461633 ORDER BY `minOrder` ASC [ RunTime:0.021139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461633 ORDER BY `unit` DESC [ RunTime:0.026464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461633 LIMIT 2 [ RunTime:0.011676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461633 ORDER BY `minOrder` ASC [ RunTime:0.007352s ]
select * from pdf where partno='96310300' and brandshort='Bopla Enclosures' limit 1 [ RunTime:0.009128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96310300' OR `brand` LIKE 'Bopla Enclosures%' ) ) LIMIT 1 [ RunTime:0.005463s ]
SELECT `id` FROM `stock` WHERE `id` <> 63461633 AND `partno` = '96310300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla enclosures%' ) [ RunTime:0.001001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199453 [ RunTime:0.010800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461518 LIMIT 5 [ RunTime:0.035408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461518 ORDER BY `minOrder` ASC [ RunTime:0.030000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461518 ORDER BY `unit` DESC [ RunTime:0.018367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461518 LIMIT 2 [ RunTime:0.014191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461518 ORDER BY `minOrder` ASC [ RunTime:0.008609s ]
select * from pdf where partno='96310309' and brandshort='Bopla Enclosures' limit 1 [ RunTime:0.011539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96310309' OR `brand` LIKE 'Bopla Enclosures%' ) ) LIMIT 1 [ RunTime:0.005269s ]
SELECT `id` FROM `stock` WHERE `id` <> 63461518 AND `partno` = '96310309' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla enclosures%' ) [ RunTime:0.017893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997439 [ RunTime:0.021016s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015355s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031790s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013560s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018333s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008601s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006893s ]
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 '9631%' OR `brand` LIKE '9631%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015651s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9631%' OR `brand` LIKE '9631%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018776s ]