SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001461s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=7614&search=1' [ RunTime:0.005271s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001470s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002171s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001281s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.021238s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001649s ]
SELECT * FROM `stock_search` WHERE `partno` = '7614' LIMIT 1 [ RunTime:0.021201s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-24 02:08:57' WHERE `partno` = '7614' [ RunTime:0.007874s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002764s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041627s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386181 LIMIT 5 [ RunTime:0.014211s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386181 ORDER BY `minOrder` ASC [ RunTime:0.029350s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386181 ORDER BY `unit` DESC [ RunTime:0.028233s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386181 LIMIT 2 [ RunTime:0.010412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386181 ORDER BY `minOrder` ASC [ RunTime:0.019798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596704 LIMIT 5 [ RunTime:0.007507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596704 ORDER BY `minOrder` ASC [ RunTime:0.019333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596704 ORDER BY `unit` DESC [ RunTime:0.044375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596704 LIMIT 2 [ RunTime:0.024308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596704 ORDER BY `minOrder` ASC [ RunTime:0.012128s ]
select * from pdf where partno='7614-0-31-15-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.047161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596560 LIMIT 5 [ RunTime:0.017296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596560 ORDER BY `minOrder` ASC [ RunTime:0.005910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596560 ORDER BY `unit` DESC [ RunTime:0.021610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596560 LIMIT 2 [ RunTime:0.018442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596560 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
select * from pdf where partno='7614-0-31-15-47-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.022545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596206 LIMIT 5 [ RunTime:0.024478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596206 ORDER BY `minOrder` ASC [ RunTime:0.022661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596206 ORDER BY `unit` DESC [ RunTime:0.028030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596206 LIMIT 2 [ RunTime:0.026330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596206 ORDER BY `minOrder` ASC [ RunTime:0.002849s ]
select * from pdf where partno='7614-0-31-80-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.019920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596204 LIMIT 5 [ RunTime:0.007091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596204 ORDER BY `minOrder` ASC [ RunTime:0.019266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596204 ORDER BY `unit` DESC [ RunTime:0.018585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596204 LIMIT 2 [ RunTime:0.014599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596204 ORDER BY `minOrder` ASC [ RunTime:0.023533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595007 LIMIT 5 [ RunTime:0.010218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595007 ORDER BY `minOrder` ASC [ RunTime:0.011561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595007 ORDER BY `unit` DESC [ RunTime:0.010365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595007 LIMIT 2 [ RunTime:0.006931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595007 ORDER BY `minOrder` ASC [ RunTime:0.006778s ]
select * from pdf where partno='7614-0-31-80-47-80-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.047081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595006 LIMIT 5 [ RunTime:0.019236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595006 ORDER BY `minOrder` ASC [ RunTime:0.032307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595006 ORDER BY `unit` DESC [ RunTime:0.011214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595006 LIMIT 2 [ RunTime:0.026988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595006 ORDER BY `minOrder` ASC [ RunTime:0.021547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16409926 LIMIT 5 [ RunTime:0.013331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16409926 ORDER BY `minOrder` ASC [ RunTime:0.009152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16409926 ORDER BY `unit` DESC [ RunTime:0.021617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16409926 LIMIT 2 [ RunTime:0.015462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16409926 ORDER BY `minOrder` ASC [ RunTime:0.019186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443072 LIMIT 5 [ RunTime:0.026135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443072 ORDER BY `minOrder` ASC [ RunTime:0.012668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443072 ORDER BY `unit` DESC [ RunTime:0.027178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443072 LIMIT 2 [ RunTime:0.015922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443072 ORDER BY `minOrder` ASC [ RunTime:0.014431s ]
select * from pdf where partno='7614-0-31-80-47-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.020591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443070 LIMIT 5 [ RunTime:0.045350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443070 ORDER BY `minOrder` ASC [ RunTime:0.020586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443070 ORDER BY `unit` DESC [ RunTime:0.042080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443070 LIMIT 2 [ RunTime:0.035432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443070 ORDER BY `minOrder` ASC [ RunTime:0.016120s ]
select * from pdf where partno='7614-0-31-01-47-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.037661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14383023 LIMIT 5 [ RunTime:0.048938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14383023 ORDER BY `minOrder` ASC [ RunTime:0.018596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14383023 ORDER BY `unit` DESC [ RunTime:0.014815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14383023 LIMIT 2 [ RunTime:0.027710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14383023 ORDER BY `minOrder` ASC [ RunTime:0.011927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378672 LIMIT 5 [ RunTime:0.013165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378672 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14378672 ORDER BY `unit` DESC [ RunTime:0.004611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14378672 LIMIT 2 [ RunTime:0.015783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14378672 ORDER BY `minOrder` ASC [ RunTime:0.021170s ]
select * from pdf where partno='7614/6 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.015055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345093 LIMIT 5 [ RunTime:0.017806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345093 ORDER BY `minOrder` ASC [ RunTime:0.008285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345093 ORDER BY `unit` DESC [ RunTime:0.027669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345093 LIMIT 2 [ RunTime:0.013383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345093 ORDER BY `minOrder` ASC [ RunTime:0.005284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345090 LIMIT 5 [ RunTime:0.007554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345090 ORDER BY `minOrder` ASC [ RunTime:0.006420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345090 ORDER BY `unit` DESC [ RunTime:0.013250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345090 LIMIT 2 [ RunTime:0.016062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345090 ORDER BY `minOrder` ASC [ RunTime:0.014644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13510849 LIMIT 5 [ RunTime:0.016133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510849 ORDER BY `minOrder` ASC [ RunTime:0.009721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13510849 ORDER BY `unit` DESC [ RunTime:0.020853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13510849 LIMIT 2 [ RunTime:0.010754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510849 ORDER BY `minOrder` ASC [ RunTime:0.008514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13509536 LIMIT 5 [ RunTime:0.015180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509536 ORDER BY `minOrder` ASC [ RunTime:0.014026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13509536 ORDER BY `unit` DESC [ RunTime:0.035462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13509536 LIMIT 2 [ RunTime:0.033931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13509536 ORDER BY `minOrder` ASC [ RunTime:0.021167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458579 LIMIT 5 [ RunTime:0.021327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458579 ORDER BY `minOrder` ASC [ RunTime:0.019225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458579 ORDER BY `unit` DESC [ RunTime:0.016052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458579 LIMIT 2 [ RunTime:0.021413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458579 ORDER BY `minOrder` ASC [ RunTime:0.012900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458534 LIMIT 5 [ RunTime:0.018743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458534 ORDER BY `minOrder` ASC [ RunTime:0.009855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458534 ORDER BY `unit` DESC [ RunTime:0.020485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458534 LIMIT 2 [ RunTime:0.019081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458534 ORDER BY `minOrder` ASC [ RunTime:0.008615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12264251 LIMIT 5 [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12264251 ORDER BY `minOrder` ASC [ RunTime:0.004781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12264251 ORDER BY `unit` DESC [ RunTime:0.011896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12264251 LIMIT 2 [ RunTime:0.009778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12264251 ORDER BY `minOrder` ASC [ RunTime:0.010975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995406 LIMIT 5 [ RunTime:0.015036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995406 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11995406 ORDER BY `unit` DESC [ RunTime:0.015873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11995406 LIMIT 2 [ RunTime:0.012293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995406 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270485 LIMIT 5 [ RunTime:0.015417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270485 ORDER BY `minOrder` ASC [ RunTime:0.017293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270485 ORDER BY `unit` DESC [ RunTime:0.034473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270485 LIMIT 2 [ RunTime:0.022646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270485 ORDER BY `minOrder` ASC [ RunTime:0.003501s ]
select * from pdf where partno='76145-3107' and brandshort='molex' limit 1 [ RunTime:0.005490s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76145-3107' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.022861s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52578620 LIMIT 5 [ RunTime:0.018155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52578620 ORDER BY `minOrder` ASC [ RunTime:0.015310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52578620 ORDER BY `unit` DESC [ RunTime:0.004236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52578620 LIMIT 2 [ RunTime:0.003881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52578620 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='7614-6002PL' and brandshort='3M' limit 1 [ RunTime:0.002920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-6002PL' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.014726s ]
SELECT `id` FROM `stock` WHERE `id` <> 52578620 AND `partno` = '7614-6002PL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.010364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51269251 LIMIT 5 [ RunTime:0.013163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51269251 ORDER BY `minOrder` ASC [ RunTime:0.022607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51269251 ORDER BY `unit` DESC [ RunTime:0.002564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51269251 LIMIT 2 [ RunTime:0.011900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51269251 ORDER BY `minOrder` ASC [ RunTime:0.005560s ]
select * from pdf where partno='7614E-3Z-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.013432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614E-3Z-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.006717s ]
SELECT `id` FROM `stock` WHERE `id` <> 51269251 AND `partno` = '7614E-3Z-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.011393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56205559 LIMIT 5 [ RunTime:0.011054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56205559 ORDER BY `minOrder` ASC [ RunTime:0.003716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56205559 ORDER BY `unit` DESC [ RunTime:0.003786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56205559 LIMIT 2 [ RunTime:0.004530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56205559 ORDER BY `minOrder` ASC [ RunTime:0.002951s ]
select * from pdf where partno='7614/6 BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.017867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614/6 BK199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.025143s ]
SELECT `id` FROM `stock` WHERE `id` <> 56205559 AND `partno` = '7614/6 BK199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14378672 [ RunTime:0.005705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56202104 LIMIT 5 [ RunTime:0.003721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56202104 ORDER BY `minOrder` ASC [ RunTime:0.017289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56202104 ORDER BY `unit` DESC [ RunTime:0.016823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56202104 LIMIT 2 [ RunTime:0.005572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56202104 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
select * from pdf where partno='761404' and brandshort='LAPP' limit 1 [ RunTime:0.005807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '761404' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.009355s ]
SELECT `id` FROM `stock` WHERE `id` <> 56202104 AND `partno` = '761404' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.015666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13509536 [ RunTime:0.001048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54555006 LIMIT 5 [ RunTime:0.003817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54555006 ORDER BY `minOrder` ASC [ RunTime:0.021438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54555006 ORDER BY `unit` DESC [ RunTime:0.004974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54555006 LIMIT 2 [ RunTime:0.004360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54555006 ORDER BY `minOrder` ASC [ RunTime:0.016422s ]
select * from pdf where partno='76144000' and brandshort='LAPP' limit 1 [ RunTime:0.025429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76144000' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.007281s ]
SELECT `id` FROM `stock` WHERE `id` <> 54555006 AND `partno` = '76144000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.011059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10833347 [ RunTime:0.013537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54536017 LIMIT 5 [ RunTime:0.008653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54536017 ORDER BY `minOrder` ASC [ RunTime:0.013118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54536017 ORDER BY `unit` DESC [ RunTime:0.005779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54536017 LIMIT 2 [ RunTime:0.010537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54536017 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
select * from pdf where partno='76143000' and brandshort='LAPP' limit 1 [ RunTime:0.010656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76143000' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.002489s ]
SELECT `id` FROM `stock` WHERE `id` <> 54536017 AND `partno` = '76143000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.006975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10824788 [ RunTime:0.009064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53499294 LIMIT 5 [ RunTime:0.006938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53499294 ORDER BY `minOrder` ASC [ RunTime:0.005728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53499294 ORDER BY `unit` DESC [ RunTime:0.007141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53499294 LIMIT 2 [ RunTime:0.014573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53499294 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='7614-0-31-15-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-15-47-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.011733s ]
SELECT `id` FROM `stock` WHERE `id` <> 53499294 AND `partno` = '7614-0-31-15-47-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.013438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596704 [ RunTime:0.003753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53499114 LIMIT 5 [ RunTime:0.023883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53499114 ORDER BY `minOrder` ASC [ RunTime:0.008314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53499114 ORDER BY `unit` DESC [ RunTime:0.010410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53499114 LIMIT 2 [ RunTime:0.020446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53499114 ORDER BY `minOrder` ASC [ RunTime:0.012330s ]
select * from pdf where partno='7614-0-31-15-47-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.004305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-15-47-14-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.038613s ]
SELECT `id` FROM `stock` WHERE `id` <> 53499114 AND `partno` = '7614-0-31-15-47-14-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.025466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596560 [ RunTime:0.017298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53498768 LIMIT 5 [ RunTime:0.046093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498768 ORDER BY `minOrder` ASC [ RunTime:0.030057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53498768 ORDER BY `unit` DESC [ RunTime:0.011873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53498768 LIMIT 2 [ RunTime:0.017740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498768 ORDER BY `minOrder` ASC [ RunTime:0.035087s ]
select * from pdf where partno='7614-0-31-80-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.026963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-80-47-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.006236s ]
SELECT `id` FROM `stock` WHERE `id` <> 53498768 AND `partno` = '7614-0-31-80-47-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.038529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596206 [ RunTime:0.043389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53498766 LIMIT 5 [ RunTime:0.056200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498766 ORDER BY `minOrder` ASC [ RunTime:0.023158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53498766 ORDER BY `unit` DESC [ RunTime:0.063761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53498766 LIMIT 2 [ RunTime:0.074868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498766 ORDER BY `minOrder` ASC [ RunTime:0.019425s ]
select * from pdf where partno='7614-0-31-01-47-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.022797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-01-47-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.021696s ]
SELECT `id` FROM `stock` WHERE `id` <> 53498766 AND `partno` = '7614-0-31-01-47-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.016823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596204 [ RunTime:0.016481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53498258 LIMIT 5 [ RunTime:0.033425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498258 ORDER BY `minOrder` ASC [ RunTime:0.034148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53498258 ORDER BY `unit` DESC [ RunTime:0.025568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53498258 LIMIT 2 [ RunTime:0.009956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498258 ORDER BY `minOrder` ASC [ RunTime:0.018169s ]
select * from pdf where partno='7614-0-31-80-47-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.015342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-80-47-14-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.036139s ]
SELECT `id` FROM `stock` WHERE `id` <> 53498258 AND `partno` = '7614-0-31-80-47-14-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.041770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443072 [ RunTime:0.022134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53498257 LIMIT 5 [ RunTime:0.025802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498257 ORDER BY `minOrder` ASC [ RunTime:0.023157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53498257 ORDER BY `unit` DESC [ RunTime:0.029425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53498257 LIMIT 2 [ RunTime:0.015162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53498257 ORDER BY `minOrder` ASC [ RunTime:0.011445s ]
select * from pdf where partno='7614-0-31-01-47-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.005114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-01-47-14-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.022838s ]
SELECT `id` FROM `stock` WHERE `id` <> 53498257 AND `partno` = '7614-0-31-01-47-14-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.022932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443070 [ RunTime:0.002793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53497868 LIMIT 5 [ RunTime:0.008514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53497868 ORDER BY `minOrder` ASC [ RunTime:0.007061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53497868 ORDER BY `unit` DESC [ RunTime:0.010064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53497868 LIMIT 2 [ RunTime:0.012534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53497868 ORDER BY `minOrder` ASC [ RunTime:0.018251s ]
select * from pdf where partno='7614-0-31-80-47-80-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-80-47-80-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.015811s ]
SELECT `id` FROM `stock` WHERE `id` <> 53497868 AND `partno` = '7614-0-31-80-47-80-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.020088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595007 [ RunTime:0.011869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53497863 LIMIT 5 [ RunTime:0.038518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53497863 ORDER BY `minOrder` ASC [ RunTime:0.031649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53497863 ORDER BY `unit` DESC [ RunTime:0.013271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53497863 LIMIT 2 [ RunTime:0.016908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53497863 ORDER BY `minOrder` ASC [ RunTime:0.004911s ]
select * from pdf where partno='7614-0-31-01-47-01-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.010487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-0-31-01-47-01-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.029305s ]
SELECT `id` FROM `stock` WHERE `id` <> 53497863 AND `partno` = '7614-0-31-01-47-01-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.012340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595006 [ RunTime:0.014632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50703546 LIMIT 5 [ RunTime:0.008534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703546 ORDER BY `minOrder` ASC [ RunTime:0.019522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50703546 ORDER BY `unit` DESC [ RunTime:0.023875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50703546 LIMIT 2 [ RunTime:0.010218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703546 ORDER BY `minOrder` ASC [ RunTime:0.007089s ]
select * from pdf where partno='76143' and brandshort='Brady Corporation' limit 1 [ RunTime:0.018273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76143' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008832s ]
SELECT `id` FROM `stock` WHERE `id` <> 50703546 AND `partno` = '76143' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458579 [ RunTime:0.003325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50703489 LIMIT 5 [ RunTime:0.015642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703489 ORDER BY `minOrder` ASC [ RunTime:0.011827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50703489 ORDER BY `unit` DESC [ RunTime:0.002157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50703489 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703489 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='76144' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76144' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003117s ]
SELECT `id` FROM `stock` WHERE `id` <> 50703489 AND `partno` = '76144' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458534 [ RunTime:0.015799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50703482 LIMIT 5 [ RunTime:0.008902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703482 ORDER BY `minOrder` ASC [ RunTime:0.031447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50703482 ORDER BY `unit` DESC [ RunTime:0.005686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50703482 LIMIT 2 [ RunTime:0.026231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703482 ORDER BY `minOrder` ASC [ RunTime:0.015819s ]
select * from pdf where partno='76142' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76142' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007572s ]
SELECT `id` FROM `stock` WHERE `id` <> 50703482 AND `partno` = '76142' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345093 [ RunTime:0.001943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50703479 LIMIT 5 [ RunTime:0.005568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703479 ORDER BY `minOrder` ASC [ RunTime:0.009739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50703479 ORDER BY `unit` DESC [ RunTime:0.036622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50703479 LIMIT 2 [ RunTime:0.011856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50703479 ORDER BY `minOrder` ASC [ RunTime:0.087718s ]
select * from pdf where partno='76141' and brandshort='Brady Corporation' limit 1 [ RunTime:0.067149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76141' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.051094s ]
SELECT `id` FROM `stock` WHERE `id` <> 50703479 AND `partno` = '76141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.051887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345090 [ RunTime:0.051316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50478448 LIMIT 5 [ RunTime:0.051191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50478448 ORDER BY `minOrder` ASC [ RunTime:0.050051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50478448 ORDER BY `unit` DESC [ RunTime:0.054157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50478448 LIMIT 2 [ RunTime:0.105654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50478448 ORDER BY `minOrder` ASC [ RunTime:0.059417s ]
select * from pdf where partno='7614-XR' and brandshort='3M' limit 1 [ RunTime:0.058222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614-XR' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.043851s ]
SELECT `id` FROM `stock` WHERE `id` <> 50478448 AND `partno` = '7614-XR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.041804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12264251 [ RunTime:0.019472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50369969 LIMIT 5 [ RunTime:0.057209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50369969 ORDER BY `minOrder` ASC [ RunTime:0.028986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50369969 ORDER BY `unit` DESC [ RunTime:0.022285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50369969 LIMIT 2 [ RunTime:0.013555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50369969 ORDER BY `minOrder` ASC [ RunTime:0.023313s ]
select * from pdf where partno='7614' and brandshort='3M' limit 1 [ RunTime:0.028101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7614' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.016629s ]
SELECT `id` FROM `stock` WHERE `id` <> 50369969 AND `partno` = '7614' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.011280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995406 [ RunTime:0.008111s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010261s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006664s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011688s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012320s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012639s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003159s ]
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 '7614%' OR `brand` LIKE '7614%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006667s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7614%' OR `brand` LIKE '7614%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001079s ]