SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002497s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.110' , `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=4420&search=1' [ RunTime:0.001855s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002176s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000573s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001756s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.110' ) [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001280s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001093s ]
SELECT * FROM `stock_search` WHERE `partno` = '4420' LIMIT 1 [ RunTime:0.003736s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-29 20:15:01' WHERE `partno` = '4420' [ RunTime:0.002846s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001328s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012390s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408403 LIMIT 5 [ RunTime:0.006366s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408403 ORDER BY `minOrder` ASC [ RunTime:0.001022s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408403 ORDER BY `unit` DESC [ RunTime:0.008040s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408403 LIMIT 2 [ RunTime:0.007181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408403 ORDER BY `minOrder` ASC [ RunTime:0.012950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538072 LIMIT 5 [ RunTime:0.008587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538072 ORDER BY `minOrder` ASC [ RunTime:0.010109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538072 ORDER BY `unit` DESC [ RunTime:0.028009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538072 LIMIT 2 [ RunTime:0.014733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538072 ORDER BY `minOrder` ASC [ RunTime:0.030075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13842517 LIMIT 5 [ RunTime:0.020254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842517 ORDER BY `minOrder` ASC [ RunTime:0.017306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13842517 ORDER BY `unit` DESC [ RunTime:0.029681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13842517 LIMIT 2 [ RunTime:0.010800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842517 ORDER BY `minOrder` ASC [ RunTime:0.011597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724887 LIMIT 5 [ RunTime:0.043240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724887 ORDER BY `minOrder` ASC [ RunTime:0.012070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724887 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724887 LIMIT 2 [ RunTime:0.018111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724887 ORDER BY `minOrder` ASC [ RunTime:0.033609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13842983 LIMIT 5 [ RunTime:0.045795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842983 ORDER BY `minOrder` ASC [ RunTime:0.004781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13842983 ORDER BY `unit` DESC [ RunTime:0.026634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13842983 LIMIT 2 [ RunTime:0.061692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13842983 ORDER BY `minOrder` ASC [ RunTime:0.017974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178682 LIMIT 5 [ RunTime:0.030014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178682 ORDER BY `minOrder` ASC [ RunTime:0.038364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11178682 ORDER BY `unit` DESC [ RunTime:0.014609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11178682 LIMIT 2 [ RunTime:0.030638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178682 ORDER BY `minOrder` ASC [ RunTime:0.026323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159458 LIMIT 5 [ RunTime:0.046905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159458 ORDER BY `minOrder` ASC [ RunTime:0.027948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159458 ORDER BY `unit` DESC [ RunTime:0.022591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159458 LIMIT 2 [ RunTime:0.045562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159458 ORDER BY `minOrder` ASC [ RunTime:0.027585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159438 LIMIT 5 [ RunTime:0.022981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159438 ORDER BY `minOrder` ASC [ RunTime:0.069860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159438 ORDER BY `unit` DESC [ RunTime:0.032576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159438 LIMIT 2 [ RunTime:0.039156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159438 ORDER BY `minOrder` ASC [ RunTime:0.012451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846461 LIMIT 5 [ RunTime:0.025013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846461 ORDER BY `minOrder` ASC [ RunTime:0.030684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846461 ORDER BY `unit` DESC [ RunTime:0.016045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846461 LIMIT 2 [ RunTime:0.016225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846461 ORDER BY `minOrder` ASC [ RunTime:0.005254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846457 LIMIT 5 [ RunTime:0.013978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846457 ORDER BY `minOrder` ASC [ RunTime:0.035369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846457 ORDER BY `unit` DESC [ RunTime:0.014446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846457 LIMIT 2 [ RunTime:0.021546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846457 ORDER BY `minOrder` ASC [ RunTime:0.003924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846456 LIMIT 5 [ RunTime:0.016824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846456 ORDER BY `minOrder` ASC [ RunTime:0.018423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846456 ORDER BY `unit` DESC [ RunTime:0.006161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846456 LIMIT 2 [ RunTime:0.019108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846456 ORDER BY `minOrder` ASC [ RunTime:0.015494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702755 LIMIT 5 [ RunTime:0.008365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702755 ORDER BY `minOrder` ASC [ RunTime:0.022555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702755 ORDER BY `unit` DESC [ RunTime:0.015531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702755 LIMIT 2 [ RunTime:0.032771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702755 ORDER BY `minOrder` ASC [ RunTime:0.010458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702754 LIMIT 5 [ RunTime:0.011660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702754 ORDER BY `minOrder` ASC [ RunTime:0.033017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702754 ORDER BY `unit` DESC [ RunTime:0.029463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702754 LIMIT 2 [ RunTime:0.012712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702754 ORDER BY `minOrder` ASC [ RunTime:0.011695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701483 LIMIT 5 [ RunTime:0.012365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701483 ORDER BY `minOrder` ASC [ RunTime:0.017250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701483 ORDER BY `unit` DESC [ RunTime:0.008668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701483 LIMIT 2 [ RunTime:0.012317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701483 ORDER BY `minOrder` ASC [ RunTime:0.009087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910366 LIMIT 5 [ RunTime:0.007659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910366 ORDER BY `minOrder` ASC [ RunTime:0.034026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910366 ORDER BY `unit` DESC [ RunTime:0.009693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910366 LIMIT 2 [ RunTime:0.001938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910366 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910263 LIMIT 5 [ RunTime:0.015770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910263 ORDER BY `minOrder` ASC [ RunTime:0.005713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910263 ORDER BY `unit` DESC [ RunTime:0.010601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910263 LIMIT 2 [ RunTime:0.016906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910263 ORDER BY `minOrder` ASC [ RunTime:0.002931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910262 LIMIT 5 [ RunTime:0.015976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910262 ORDER BY `minOrder` ASC [ RunTime:0.024261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910262 ORDER BY `unit` DESC [ RunTime:0.009101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910262 LIMIT 2 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910262 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910261 LIMIT 5 [ RunTime:0.011335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910261 ORDER BY `minOrder` ASC [ RunTime:0.015450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910261 ORDER BY `unit` DESC [ RunTime:0.013858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910261 LIMIT 2 [ RunTime:0.008102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910261 ORDER BY `minOrder` ASC [ RunTime:0.003262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910260 LIMIT 5 [ RunTime:0.005712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910260 ORDER BY `minOrder` ASC [ RunTime:0.014157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910260 ORDER BY `unit` DESC [ RunTime:0.005670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910260 LIMIT 2 [ RunTime:0.007671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910260 ORDER BY `minOrder` ASC [ RunTime:0.007568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910259 LIMIT 5 [ RunTime:0.012897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910259 ORDER BY `minOrder` ASC [ RunTime:0.003537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910259 ORDER BY `unit` DESC [ RunTime:0.016636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910259 LIMIT 2 [ RunTime:0.013672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910259 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026368s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126776 LIMIT 5 [ RunTime:0.013358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126776 ORDER BY `minOrder` ASC [ RunTime:0.018391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126776 ORDER BY `unit` DESC [ RunTime:0.030767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126776 LIMIT 2 [ RunTime:0.019774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126776 ORDER BY `minOrder` ASC [ RunTime:0.030503s ]
select * from pdf where partno='4420' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.023108s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.023477s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126776 AND `partno` = '4420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.011606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408403 [ RunTime:0.023819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126769 LIMIT 5 [ RunTime:0.016324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126769 ORDER BY `minOrder` ASC [ RunTime:0.005898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126769 ORDER BY `unit` DESC [ RunTime:0.023329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126769 LIMIT 2 [ RunTime:0.030097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126769 ORDER BY `minOrder` ASC [ RunTime:0.043541s ]
select * from pdf where partno='4420B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.004227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.011985s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126769 AND `partno` = '4420B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.036186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538072 [ RunTime:0.044704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41868993 LIMIT 5 [ RunTime:0.004406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41868993 ORDER BY `minOrder` ASC [ RunTime:0.029968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41868993 ORDER BY `unit` DESC [ RunTime:0.016507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41868993 LIMIT 2 [ RunTime:0.008783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41868993 ORDER BY `minOrder` ASC [ RunTime:0.010803s ]
select * from pdf where partno='4420.0262' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.018113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420.0262' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.016131s ]
SELECT `id` FROM `stock` WHERE `id` <> 41868993 AND `partno` = '4420.0262' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.038388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13842517 [ RunTime:0.020672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41937348 LIMIT 5 [ RunTime:0.029619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41937348 ORDER BY `minOrder` ASC [ RunTime:0.038667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41937348 ORDER BY `unit` DESC [ RunTime:0.022844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41937348 LIMIT 2 [ RunTime:0.026314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41937348 ORDER BY `minOrder` ASC [ RunTime:0.010108s ]
select * from pdf where partno='4420.0228' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.016727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420.0228' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.010900s ]
SELECT `id` FROM `stock` WHERE `id` <> 41937348 AND `partno` = '4420.0228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.012099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724887 [ RunTime:0.018278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508152 LIMIT 5 [ RunTime:0.017704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508152 ORDER BY `minOrder` ASC [ RunTime:0.013082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508152 ORDER BY `unit` DESC [ RunTime:0.007373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508152 LIMIT 2 [ RunTime:0.014478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508152 ORDER BY `minOrder` ASC [ RunTime:0.005485s ]
select * from pdf where partno='44207' and brandshort='Brady Corporation' limit 1 [ RunTime:0.025332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44207' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022508s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508152 AND `partno` = '44207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.054759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396308 [ RunTime:0.022835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508151 LIMIT 5 [ RunTime:0.021966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508151 ORDER BY `minOrder` ASC [ RunTime:0.029302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508151 ORDER BY `unit` DESC [ RunTime:0.044919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508151 LIMIT 2 [ RunTime:0.009464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508151 ORDER BY `minOrder` ASC [ RunTime:0.004983s ]
select * from pdf where partno='44206' and brandshort='Brady Corporation' limit 1 [ RunTime:0.031858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44206' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.006526s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508151 AND `partno` = '44206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.027046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396307 [ RunTime:0.044935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452014 LIMIT 5 [ RunTime:0.010633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452014 ORDER BY `minOrder` ASC [ RunTime:0.005632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452014 ORDER BY `unit` DESC [ RunTime:0.008113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452014 LIMIT 2 [ RunTime:0.012134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452014 ORDER BY `minOrder` ASC [ RunTime:0.003283s ]
select * from pdf where partno='44203068' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.015157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44203068' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.009750s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452014 AND `partno` = '44203068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.008964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238374 [ RunTime:0.007853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452010 LIMIT 5 [ RunTime:0.007527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452010 ORDER BY `minOrder` ASC [ RunTime:0.015108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452010 ORDER BY `unit` DESC [ RunTime:0.012913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452010 LIMIT 2 [ RunTime:0.029199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452010 ORDER BY `minOrder` ASC [ RunTime:0.002936s ]
select * from pdf where partno='44201068' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.020432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44201068' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.024469s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452010 AND `partno` = '44201068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.023322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846461 [ RunTime:0.024955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452000 LIMIT 5 [ RunTime:0.025034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452000 ORDER BY `minOrder` ASC [ RunTime:0.045365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452000 ORDER BY `unit` DESC [ RunTime:0.012468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452000 LIMIT 2 [ RunTime:0.021948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452000 ORDER BY `minOrder` ASC [ RunTime:0.004488s ]
select * from pdf where partno='44203055' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.007427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44203055' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.044076s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452000 AND `partno` = '44203055' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.012152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846457 [ RunTime:0.038397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451999 LIMIT 5 [ RunTime:0.038457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451999 ORDER BY `minOrder` ASC [ RunTime:0.025994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451999 ORDER BY `unit` DESC [ RunTime:0.031055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451999 LIMIT 2 [ RunTime:0.011980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451999 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='44201055' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.024953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44201055' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.002621s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451999 AND `partno` = '44201055' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.055850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846456 [ RunTime:0.056267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127424 LIMIT 5 [ RunTime:0.004320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127424 ORDER BY `minOrder` ASC [ RunTime:0.012613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127424 ORDER BY `unit` DESC [ RunTime:0.019757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127424 LIMIT 2 [ RunTime:0.047820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127424 ORDER BY `minOrder` ASC [ RunTime:0.004470s ]
select * from pdf where partno='4420P-601-470/201L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.036985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-470/201L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.019208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127423 LIMIT 5 [ RunTime:0.013234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127423 ORDER BY `minOrder` ASC [ RunTime:0.032317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127423 ORDER BY `unit` DESC [ RunTime:0.023299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127423 LIMIT 2 [ RunTime:0.066864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127423 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
select * from pdf where partno='4420P-601-250/201L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.013797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-250/201L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.010979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127422 LIMIT 5 [ RunTime:0.056195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127422 ORDER BY `minOrder` ASC [ RunTime:0.031566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127422 ORDER BY `unit` DESC [ RunTime:0.044986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127422 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127422 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
select * from pdf where partno='4420P-601-101/101L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.013963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-101/101L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.023304s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127422 AND `partno` = '4420P-601-101/101L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.009855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13214504 [ RunTime:0.039198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127393 LIMIT 5 [ RunTime:0.007351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127393 ORDER BY `minOrder` ASC [ RunTime:0.028399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127393 ORDER BY `unit` DESC [ RunTime:0.031850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127393 LIMIT 2 [ RunTime:0.083582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127393 ORDER BY `minOrder` ASC [ RunTime:0.002524s ]
select * from pdf where partno='4420P-601-820/201' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.031831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-820/201' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.053807s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127393 AND `partno` = '4420P-601-820/201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.073389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13214499 [ RunTime:0.033927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127392 LIMIT 5 [ RunTime:0.029271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127392 ORDER BY `minOrder` ASC [ RunTime:0.032331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127392 ORDER BY `unit` DESC [ RunTime:0.029101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127392 LIMIT 2 [ RunTime:0.016813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127392 ORDER BY `minOrder` ASC [ RunTime:0.001774s ]
select * from pdf where partno='4420P-601-250/181' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-250/181' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005563s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127392 AND `partno` = '4420P-601-250/181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.017105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13214498 [ RunTime:0.019299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127391 LIMIT 5 [ RunTime:0.011510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127391 ORDER BY `minOrder` ASC [ RunTime:0.018931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127391 ORDER BY `unit` DESC [ RunTime:0.017542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127391 LIMIT 2 [ RunTime:0.023134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127391 ORDER BY `minOrder` ASC [ RunTime:0.005580s ]
select * from pdf where partno='4420P-601-250/101' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-250/101' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.019702s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127391 AND `partno` = '4420P-601-250/101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.026429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13214497 [ RunTime:0.009778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127390 LIMIT 5 [ RunTime:0.012461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127390 ORDER BY `minOrder` ASC [ RunTime:0.006791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127390 ORDER BY `unit` DESC [ RunTime:0.006170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127390 LIMIT 2 [ RunTime:0.017739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127390 ORDER BY `minOrder` ASC [ RunTime:0.004566s ]
select * from pdf where partno='4420P-601-101/101' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.006693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-101/101' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.025840s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127390 AND `partno` = '4420P-601-101/101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.031677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13214496 [ RunTime:0.016296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127389 LIMIT 5 [ RunTime:0.006899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127389 ORDER BY `minOrder` ASC [ RunTime:0.013960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127389 ORDER BY `unit` DESC [ RunTime:0.047212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127389 LIMIT 2 [ RunTime:0.008773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127389 ORDER BY `minOrder` ASC [ RunTime:0.008963s ]
select * from pdf where partno='4420P-601-250/201' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.012485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-250/201' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.023476s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127389 AND `partno` = '4420P-601-250/201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.029997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13214495 [ RunTime:0.015593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64127388 LIMIT 5 [ RunTime:0.028922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127388 ORDER BY `minOrder` ASC [ RunTime:0.023311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64127388 ORDER BY `unit` DESC [ RunTime:0.008472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64127388 LIMIT 2 [ RunTime:0.005114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64127388 ORDER BY `minOrder` ASC [ RunTime:0.011414s ]
select * from pdf where partno='4420P-601-101/201' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.031047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420P-601-101/201' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.013907s ]
SELECT `id` FROM `stock` WHERE `id` <> 64127388 AND `partno` = '4420P-601-101/201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.033491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63413515 LIMIT 5 [ RunTime:0.011102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63413515 ORDER BY `minOrder` ASC [ RunTime:0.028037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63413515 ORDER BY `unit` DESC [ RunTime:0.036517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63413515 LIMIT 2 [ RunTime:0.023038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63413515 ORDER BY `minOrder` ASC [ RunTime:0.006395s ]
select * from pdf where partno='4420-HW' and brandshort='80/20, LLC' limit 1 [ RunTime:0.036235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4420-HW' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.028850s ]
SELECT `id` FROM `stock` WHERE `id` <> 63413515 AND `partno` = '4420-HW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.033843s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035558s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039055s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010091s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042721s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026767s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053817s ]
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 '4420%' OR `brand` LIKE '4420%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023343s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4420%' OR `brand` LIKE '4420%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.043169s ]