SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002354s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=3248&search=1' [ RunTime:0.001934s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002535s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002137s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001472s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.001818s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001094s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002164s ]
SELECT * FROM `stock_search` WHERE `partno` = '3248' LIMIT 1 [ RunTime:0.001871s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 15:22:34' WHERE `partno` = '3248' [ RunTime:0.001584s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001222s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013143s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583136 LIMIT 5 [ RunTime:0.009897s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583136 ORDER BY `minOrder` ASC [ RunTime:0.001377s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583136 ORDER BY `unit` DESC [ RunTime:0.003166s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583136 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583136 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561377 LIMIT 5 [ RunTime:0.020010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561377 ORDER BY `minOrder` ASC [ RunTime:0.011432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561377 ORDER BY `unit` DESC [ RunTime:0.010631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561377 LIMIT 2 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561377 ORDER BY `minOrder` ASC [ RunTime:0.010556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561387 LIMIT 5 [ RunTime:0.006340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561387 ORDER BY `minOrder` ASC [ RunTime:0.013390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561387 ORDER BY `unit` DESC [ RunTime:0.006470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561387 LIMIT 2 [ RunTime:0.004125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561387 ORDER BY `minOrder` ASC [ RunTime:0.001877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561394 LIMIT 5 [ RunTime:0.007743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561394 ORDER BY `minOrder` ASC [ RunTime:0.003569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561394 ORDER BY `unit` DESC [ RunTime:0.010797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561394 LIMIT 2 [ RunTime:0.017393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561394 ORDER BY `minOrder` ASC [ RunTime:0.003106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446010 LIMIT 5 [ RunTime:0.022252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446010 ORDER BY `minOrder` ASC [ RunTime:0.015180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446010 ORDER BY `unit` DESC [ RunTime:0.010714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446010 LIMIT 2 [ RunTime:0.002057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446010 ORDER BY `minOrder` ASC [ RunTime:0.005170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583299 LIMIT 5 [ RunTime:0.014870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583299 ORDER BY `minOrder` ASC [ RunTime:0.020299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583299 ORDER BY `unit` DESC [ RunTime:0.006719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583299 LIMIT 2 [ RunTime:0.025688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583299 ORDER BY `minOrder` ASC [ RunTime:0.024855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563367 LIMIT 5 [ RunTime:0.029086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563367 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12563367 ORDER BY `unit` DESC [ RunTime:0.029710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12563367 LIMIT 2 [ RunTime:0.024637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563367 ORDER BY `minOrder` ASC [ RunTime:0.009651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563821 LIMIT 5 [ RunTime:0.022193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563821 ORDER BY `minOrder` ASC [ RunTime:0.011357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12563821 ORDER BY `unit` DESC [ RunTime:0.018973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12563821 LIMIT 2 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563821 ORDER BY `minOrder` ASC [ RunTime:0.004066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562796 LIMIT 5 [ RunTime:0.013542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562796 ORDER BY `minOrder` ASC [ RunTime:0.029836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562796 ORDER BY `unit` DESC [ RunTime:0.045751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562796 LIMIT 2 [ RunTime:0.037400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562796 ORDER BY `minOrder` ASC [ RunTime:0.015995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562088 LIMIT 5 [ RunTime:0.017363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562088 ORDER BY `minOrder` ASC [ RunTime:0.010491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562088 ORDER BY `unit` DESC [ RunTime:0.014462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562088 LIMIT 2 [ RunTime:0.016845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562088 ORDER BY `minOrder` ASC [ RunTime:0.020553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447200 LIMIT 5 [ RunTime:0.028082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447200 ORDER BY `minOrder` ASC [ RunTime:0.035029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447200 ORDER BY `unit` DESC [ RunTime:0.052562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447200 LIMIT 2 [ RunTime:0.005430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447200 ORDER BY `minOrder` ASC [ RunTime:0.016993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515405 LIMIT 5 [ RunTime:0.030728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515405 ORDER BY `minOrder` ASC [ RunTime:0.029661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13515405 ORDER BY `unit` DESC [ RunTime:0.027338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13515405 LIMIT 2 [ RunTime:0.037489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13515405 ORDER BY `minOrder` ASC [ RunTime:0.022918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447242 LIMIT 5 [ RunTime:0.050028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447242 ORDER BY `minOrder` ASC [ RunTime:0.054358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447242 ORDER BY `unit` DESC [ RunTime:0.025222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447242 LIMIT 2 [ RunTime:0.029889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447242 ORDER BY `minOrder` ASC [ RunTime:0.005650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562418 LIMIT 5 [ RunTime:0.049580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562418 ORDER BY `minOrder` ASC [ RunTime:0.042808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562418 ORDER BY `unit` DESC [ RunTime:0.007962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562418 LIMIT 2 [ RunTime:0.014207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562418 ORDER BY `minOrder` ASC [ RunTime:0.020156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562389 LIMIT 5 [ RunTime:0.059493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562389 ORDER BY `minOrder` ASC [ RunTime:0.041220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562389 ORDER BY `unit` DESC [ RunTime:0.061802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562389 LIMIT 2 [ RunTime:0.037327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562389 ORDER BY `minOrder` ASC [ RunTime:0.014067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19665070 LIMIT 5 [ RunTime:0.005875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19665070 ORDER BY `minOrder` ASC [ RunTime:0.017483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19665070 ORDER BY `unit` DESC [ RunTime:0.044665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19665070 LIMIT 2 [ RunTime:0.033222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19665070 ORDER BY `minOrder` ASC [ RunTime:0.022548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168352 LIMIT 5 [ RunTime:0.065579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168352 ORDER BY `minOrder` ASC [ RunTime:0.041051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12168352 ORDER BY `unit` DESC [ RunTime:0.023516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12168352 LIMIT 2 [ RunTime:0.038174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168352 ORDER BY `minOrder` ASC [ RunTime:0.004813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447231 LIMIT 5 [ RunTime:0.052315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447231 ORDER BY `minOrder` ASC [ RunTime:0.014865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447231 ORDER BY `unit` DESC [ RunTime:0.031655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447231 LIMIT 2 [ RunTime:0.014205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447231 ORDER BY `minOrder` ASC [ RunTime:0.002052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387816 LIMIT 5 [ RunTime:0.007791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387816 ORDER BY `minOrder` ASC [ RunTime:0.007030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387816 ORDER BY `unit` DESC [ RunTime:0.046705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387816 LIMIT 2 [ RunTime:0.051231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387816 ORDER BY `minOrder` ASC [ RunTime:0.029683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513959 LIMIT 5 [ RunTime:0.018013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513959 ORDER BY `minOrder` ASC [ RunTime:0.036759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513959 ORDER BY `unit` DESC [ RunTime:0.035626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513959 LIMIT 2 [ RunTime:0.043490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513959 ORDER BY `minOrder` ASC [ RunTime:0.015670s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258474 LIMIT 5 [ RunTime:0.043183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258474 ORDER BY `minOrder` ASC [ RunTime:0.042765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258474 ORDER BY `unit` DESC [ RunTime:0.012306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258474 LIMIT 2 [ RunTime:0.010129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258474 ORDER BY `minOrder` ASC [ RunTime:0.006443s ]
select * from pdf where partno='3248038' and brandshort='phoenix contact' limit 1 [ RunTime:0.012247s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248038' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.009796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086618 LIMIT 5 [ RunTime:0.014142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086618 ORDER BY `minOrder` ASC [ RunTime:0.005308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086618 ORDER BY `unit` DESC [ RunTime:0.021289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086618 LIMIT 2 [ RunTime:0.009367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086618 ORDER BY `minOrder` ASC [ RunTime:0.001448s ]
select * from pdf where partno='3248005' and brandshort='phoenix contact' limit 1 [ RunTime:0.002395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248005' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.027689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32258479 LIMIT 5 [ RunTime:0.017733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258479 ORDER BY `minOrder` ASC [ RunTime:0.009748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32258479 ORDER BY `unit` DESC [ RunTime:0.014949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32258479 LIMIT 2 [ RunTime:0.015238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32258479 ORDER BY `minOrder` ASC [ RunTime:0.014333s ]
select * from pdf where partno='3248027' and brandshort='phoenix contact' limit 1 [ RunTime:0.006469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248027' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.014374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137893 LIMIT 5 [ RunTime:0.014237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137893 ORDER BY `minOrder` ASC [ RunTime:0.041282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137893 ORDER BY `unit` DESC [ RunTime:0.007689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137893 LIMIT 2 [ RunTime:0.011611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137893 ORDER BY `minOrder` ASC [ RunTime:0.020083s ]
select * from pdf where partno='3248 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.009404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.008235s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137893 AND `partno` = '3248 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.009706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515405 [ RunTime:0.018805s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53645971 LIMIT 5 [ RunTime:0.051948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645971 ORDER BY `minOrder` ASC [ RunTime:0.038484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53645971 ORDER BY `unit` DESC [ RunTime:0.018970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53645971 LIMIT 2 [ RunTime:0.023647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645971 ORDER BY `minOrder` ASC [ RunTime:0.013757s ]
select * from pdf where partno='3248100' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.033657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248100' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53645980 LIMIT 5 [ RunTime:0.040342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645980 ORDER BY `minOrder` ASC [ RunTime:0.040498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53645980 ORDER BY `unit` DESC [ RunTime:0.007369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53645980 LIMIT 2 [ RunTime:0.034968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645980 ORDER BY `minOrder` ASC [ RunTime:0.024625s ]
select * from pdf where partno='3248030' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248030' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53645964 LIMIT 5 [ RunTime:0.021854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645964 ORDER BY `minOrder` ASC [ RunTime:0.042100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53645964 ORDER BY `unit` DESC [ RunTime:0.024094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53645964 LIMIT 2 [ RunTime:0.037819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645964 ORDER BY `minOrder` ASC [ RunTime:0.005135s ]
select * from pdf where partno='3248150' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248150' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53645977 LIMIT 5 [ RunTime:0.037461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645977 ORDER BY `minOrder` ASC [ RunTime:0.015552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53645977 ORDER BY `unit` DESC [ RunTime:0.051546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53645977 LIMIT 2 [ RunTime:0.042156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53645977 ORDER BY `minOrder` ASC [ RunTime:0.028145s ]
select * from pdf where partno='3248125' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248125' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.029240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384873 LIMIT 5 [ RunTime:0.031794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384873 ORDER BY `minOrder` ASC [ RunTime:0.027529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384873 ORDER BY `unit` DESC [ RunTime:0.038587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384873 LIMIT 2 [ RunTime:0.016785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384873 ORDER BY `minOrder` ASC [ RunTime:0.009487s ]
select * from pdf where partno='3248033' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248033' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53646411 LIMIT 5 [ RunTime:0.007822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646411 ORDER BY `minOrder` ASC [ RunTime:0.029735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53646411 ORDER BY `unit` DESC [ RunTime:0.006307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53646411 LIMIT 2 [ RunTime:0.017228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646411 ORDER BY `minOrder` ASC [ RunTime:0.004383s ]
select * from pdf where partno='3248035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53646395 LIMIT 5 [ RunTime:0.049305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646395 ORDER BY `minOrder` ASC [ RunTime:0.030418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53646395 ORDER BY `unit` DESC [ RunTime:0.012947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53646395 LIMIT 2 [ RunTime:0.015737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646395 ORDER BY `minOrder` ASC [ RunTime:0.004830s ]
select * from pdf where partno='3248101' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248101' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.024015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385549 LIMIT 5 [ RunTime:0.015711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385549 ORDER BY `minOrder` ASC [ RunTime:0.010140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385549 ORDER BY `unit` DESC [ RunTime:0.019344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385549 LIMIT 2 [ RunTime:0.007461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385549 ORDER BY `minOrder` ASC [ RunTime:0.001744s ]
select * from pdf where partno='3248120' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248120' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53646082 LIMIT 5 [ RunTime:0.020677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646082 ORDER BY `minOrder` ASC [ RunTime:0.032647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53646082 ORDER BY `unit` DESC [ RunTime:0.001995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53646082 LIMIT 2 [ RunTime:0.017097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646082 ORDER BY `minOrder` ASC [ RunTime:0.002970s ]
select * from pdf where partno='3248032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385688 LIMIT 5 [ RunTime:0.026467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385688 ORDER BY `minOrder` ASC [ RunTime:0.033470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385688 ORDER BY `unit` DESC [ RunTime:0.031917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385688 LIMIT 2 [ RunTime:0.015541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385688 ORDER BY `minOrder` ASC [ RunTime:0.007396s ]
select * from pdf where partno='3248034' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248034' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52487686 LIMIT 5 [ RunTime:0.019595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52487686 ORDER BY `minOrder` ASC [ RunTime:0.016118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52487686 ORDER BY `unit` DESC [ RunTime:0.008542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52487686 LIMIT 2 [ RunTime:0.019371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52487686 ORDER BY `minOrder` ASC [ RunTime:0.006786s ]
select * from pdf where partno='324893' and brandshort='TE Connectivity' limit 1 [ RunTime:0.005992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '324893' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.027995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53646512 LIMIT 5 [ RunTime:0.039395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646512 ORDER BY `minOrder` ASC [ RunTime:0.030494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53646512 ORDER BY `unit` DESC [ RunTime:0.026047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53646512 LIMIT 2 [ RunTime:0.005035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646512 ORDER BY `minOrder` ASC [ RunTime:0.001397s ]
select * from pdf where partno='3248130' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248130' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385551 LIMIT 5 [ RunTime:0.003794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385551 ORDER BY `minOrder` ASC [ RunTime:0.015797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385551 ORDER BY `unit` DESC [ RunTime:0.015121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385551 LIMIT 2 [ RunTime:0.005654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385551 ORDER BY `minOrder` ASC [ RunTime:0.026310s ]
select * from pdf where partno='3248140' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.024328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248140' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53646870 LIMIT 5 [ RunTime:0.036192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646870 ORDER BY `minOrder` ASC [ RunTime:0.016639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53646870 ORDER BY `unit` DESC [ RunTime:0.010935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53646870 LIMIT 2 [ RunTime:0.021159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646870 ORDER BY `minOrder` ASC [ RunTime:0.011377s ]
select * from pdf where partno='3248025' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248025' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.034885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56181416 LIMIT 5 [ RunTime:0.018668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56181416 ORDER BY `minOrder` ASC [ RunTime:0.010400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56181416 ORDER BY `unit` DESC [ RunTime:0.031469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56181416 LIMIT 2 [ RunTime:0.030416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56181416 ORDER BY `minOrder` ASC [ RunTime:0.006042s ]
select * from pdf where partno='3248 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.022898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.015960s ]
SELECT `id` FROM `stock` WHERE `id` <> 56181416 AND `partno` = '3248 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.025101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13515405 [ RunTime:0.015672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53646542 LIMIT 5 [ RunTime:0.025558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646542 ORDER BY `minOrder` ASC [ RunTime:0.056782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53646542 ORDER BY `unit` DESC [ RunTime:0.069998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53646542 LIMIT 2 [ RunTime:0.034800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53646542 ORDER BY `minOrder` ASC [ RunTime:0.013447s ]
select * from pdf where partno='3248037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386732 LIMIT 5 [ RunTime:0.007795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386732 ORDER BY `minOrder` ASC [ RunTime:0.028628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386732 ORDER BY `unit` DESC [ RunTime:0.009571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386732 LIMIT 2 [ RunTime:0.055823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386732 ORDER BY `minOrder` ASC [ RunTime:0.008590s ]
select * from pdf where partno='3248495' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248495' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53649167 LIMIT 5 [ RunTime:0.024846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649167 ORDER BY `minOrder` ASC [ RunTime:0.022414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53649167 ORDER BY `unit` DESC [ RunTime:0.021713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53649167 LIMIT 2 [ RunTime:0.007332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649167 ORDER BY `minOrder` ASC [ RunTime:0.004973s ]
select * from pdf where partno='3248038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54182018 LIMIT 5 [ RunTime:0.008444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54182018 ORDER BY `minOrder` ASC [ RunTime:0.018742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54182018 ORDER BY `unit` DESC [ RunTime:0.009886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54182018 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54182018 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
select * from pdf where partno='3248115' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3248115' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58558868 LIMIT 5 [ RunTime:0.016824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58558868 ORDER BY `minOrder` ASC [ RunTime:0.011339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58558868 ORDER BY `unit` DESC [ RunTime:0.020196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58558868 LIMIT 2 [ RunTime:0.023954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58558868 ORDER BY `minOrder` ASC [ RunTime:0.005365s ]
select * from pdf where partno='32482' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.006801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '32482' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005007s ]
SELECT `id` FROM `stock` WHERE `id` <> 58558868 AND `partno` = '32482' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.015784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168352 [ RunTime:0.017192s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001459s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005108s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013955s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007692s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012850s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021881s ]
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 '3248%' OR `brand` LIKE '3248%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014732s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3248%' OR `brand` LIKE '3248%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022226s ]