SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002259s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=17253&search=1' [ RunTime:0.004288s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002692s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002110s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002809s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002517s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003799s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002133s ]
SELECT * FROM `stock_search` WHERE `partno` = '17253' LIMIT 1 [ RunTime:0.006308s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-29 09:04:24' WHERE `partno` = '17253' [ RunTime:0.013550s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002665s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008797s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435298 LIMIT 5 [ RunTime:0.003472s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435298 ORDER BY `minOrder` ASC [ RunTime:0.002533s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11435298 ORDER BY `unit` DESC [ RunTime:0.001342s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11435298 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435298 ORDER BY `minOrder` ASC [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12555867 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555867 ORDER BY `minOrder` ASC [ RunTime:0.006812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12555867 ORDER BY `unit` DESC [ RunTime:0.004182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12555867 LIMIT 2 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555867 ORDER BY `minOrder` ASC [ RunTime:0.000175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11450028 LIMIT 5 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450028 ORDER BY `minOrder` ASC [ RunTime:0.000170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11450028 ORDER BY `unit` DESC [ RunTime:0.000153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11450028 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450028 ORDER BY `minOrder` ASC [ RunTime:0.000203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657571 LIMIT 5 [ RunTime:0.001748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657571 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657571 ORDER BY `unit` DESC [ RunTime:0.000264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657571 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657571 ORDER BY `minOrder` ASC [ RunTime:0.001443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657310 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657310 ORDER BY `minOrder` ASC [ RunTime:0.004950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657310 ORDER BY `unit` DESC [ RunTime:0.000199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657310 LIMIT 2 [ RunTime:0.001949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657310 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657216 LIMIT 5 [ RunTime:0.001229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657216 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657216 ORDER BY `unit` DESC [ RunTime:0.005068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657216 LIMIT 2 [ RunTime:0.003971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657216 ORDER BY `minOrder` ASC [ RunTime:0.002188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657091 LIMIT 5 [ RunTime:0.002430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657091 ORDER BY `minOrder` ASC [ RunTime:0.005435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19657091 ORDER BY `unit` DESC [ RunTime:0.000943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19657091 LIMIT 2 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19657091 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656752 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656752 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656752 ORDER BY `unit` DESC [ RunTime:0.003481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656752 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656752 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656439 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656439 ORDER BY `minOrder` ASC [ RunTime:0.001551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656439 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656439 LIMIT 2 [ RunTime:0.009364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656439 ORDER BY `minOrder` ASC [ RunTime:0.001575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656197 LIMIT 5 [ RunTime:0.006299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656197 ORDER BY `minOrder` ASC [ RunTime:0.013570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656197 ORDER BY `unit` DESC [ RunTime:0.001501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656197 LIMIT 2 [ RunTime:0.032622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656197 ORDER BY `minOrder` ASC [ RunTime:0.015205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655881 LIMIT 5 [ RunTime:0.003354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655881 ORDER BY `minOrder` ASC [ RunTime:0.004059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655881 ORDER BY `unit` DESC [ RunTime:0.007441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655881 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655881 ORDER BY `minOrder` ASC [ RunTime:0.001821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655404 LIMIT 5 [ RunTime:0.004439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655404 ORDER BY `minOrder` ASC [ RunTime:0.005903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655404 ORDER BY `unit` DESC [ RunTime:0.000871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655404 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655404 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18757230 LIMIT 5 [ RunTime:0.008511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757230 ORDER BY `minOrder` ASC [ RunTime:0.001942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18757230 ORDER BY `unit` DESC [ RunTime:0.000930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18757230 LIMIT 2 [ RunTime:0.010000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757230 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752350 LIMIT 5 [ RunTime:0.007752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752350 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752350 ORDER BY `unit` DESC [ RunTime:0.007605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752350 LIMIT 2 [ RunTime:0.014658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752350 ORDER BY `minOrder` ASC [ RunTime:0.006474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005772 LIMIT 5 [ RunTime:0.028542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005772 ORDER BY `minOrder` ASC [ RunTime:0.048089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005772 ORDER BY `unit` DESC [ RunTime:0.010496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005772 LIMIT 2 [ RunTime:0.004181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005772 ORDER BY `minOrder` ASC [ RunTime:0.006629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149820 LIMIT 5 [ RunTime:0.008953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149820 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149820 ORDER BY `unit` DESC [ RunTime:0.013005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149820 LIMIT 2 [ RunTime:0.018629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149820 ORDER BY `minOrder` ASC [ RunTime:0.013378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12558322 LIMIT 5 [ RunTime:0.003297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12558322 ORDER BY `minOrder` ASC [ RunTime:0.007173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12558322 ORDER BY `unit` DESC [ RunTime:0.006776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12558322 LIMIT 2 [ RunTime:0.002543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12558322 ORDER BY `minOrder` ASC [ RunTime:0.007306s ]
select * from pdf where partno='1725328' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556803 LIMIT 5 [ RunTime:0.015753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556803 ORDER BY `minOrder` ASC [ RunTime:0.008697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556803 ORDER BY `unit` DESC [ RunTime:0.011684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556803 LIMIT 2 [ RunTime:0.019580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556803 ORDER BY `minOrder` ASC [ RunTime:0.004557s ]
select * from pdf where partno='1725315' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556715 LIMIT 5 [ RunTime:0.024733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556715 ORDER BY `minOrder` ASC [ RunTime:0.024275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556715 ORDER BY `unit` DESC [ RunTime:0.015899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556715 LIMIT 2 [ RunTime:0.027158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556715 ORDER BY `minOrder` ASC [ RunTime:0.016495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12547776 LIMIT 5 [ RunTime:0.031735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12547776 ORDER BY `minOrder` ASC [ RunTime:0.015266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12547776 ORDER BY `unit` DESC [ RunTime:0.036726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12547776 LIMIT 2 [ RunTime:0.025558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12547776 ORDER BY `minOrder` ASC [ RunTime:0.030554s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275398 LIMIT 5 [ RunTime:0.001216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275398 ORDER BY `minOrder` ASC [ RunTime:0.012985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275398 ORDER BY `unit` DESC [ RunTime:0.015713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275398 LIMIT 2 [ RunTime:0.019824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275398 ORDER BY `minOrder` ASC [ RunTime:0.016305s ]
select * from pdf where partno='1725328' and brandshort='phoenix contact' limit 1 [ RunTime:0.012700s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725328' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.007640s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560315 LIMIT 5 [ RunTime:0.009838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560315 ORDER BY `minOrder` ASC [ RunTime:0.026717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560315 ORDER BY `unit` DESC [ RunTime:0.025727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560315 LIMIT 2 [ RunTime:0.024857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560315 ORDER BY `minOrder` ASC [ RunTime:0.016991s ]
select * from pdf where partno='1725302' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.039220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725302' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560524 LIMIT 5 [ RunTime:0.022750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560524 ORDER BY `minOrder` ASC [ RunTime:0.003957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560524 ORDER BY `unit` DESC [ RunTime:0.010802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560524 LIMIT 2 [ RunTime:0.002293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560524 ORDER BY `minOrder` ASC [ RunTime:0.006689s ]
select * from pdf where partno='1725328' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725328' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64567438 LIMIT 5 [ RunTime:0.010486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64567438 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64567438 ORDER BY `unit` DESC [ RunTime:0.002118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64567438 LIMIT 2 [ RunTime:0.005195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64567438 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='17253' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.001611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17253' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.005585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64013489 LIMIT 5 [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64013489 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64013489 ORDER BY `unit` DESC [ RunTime:0.000309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64013489 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64013489 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
select * from pdf where partno='17253' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.005746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17253' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000375s ]
SELECT `id` FROM `stock` WHERE `id` <> 64013489 AND `partno` = '17253' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.006857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11334613 [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60631355 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60631355 ORDER BY `minOrder` ASC [ RunTime:0.001943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60631355 ORDER BY `unit` DESC [ RunTime:0.001020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60631355 LIMIT 2 [ RunTime:0.003027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60631355 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
select * from pdf where partno='17253.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.009944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17253.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.001971s ]
SELECT `id` FROM `stock` WHERE `id` <> 60631355 AND `partno` = '17253.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.015593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60584353 LIMIT 5 [ RunTime:0.008024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60584353 ORDER BY `minOrder` ASC [ RunTime:0.011269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60584353 ORDER BY `unit` DESC [ RunTime:0.011870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60584353 LIMIT 2 [ RunTime:0.007781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60584353 ORDER BY `minOrder` ASC [ RunTime:0.001846s ]
select * from pdf where partno='1725393' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725393' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60582776 LIMIT 5 [ RunTime:0.002974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60582776 ORDER BY `minOrder` ASC [ RunTime:0.005162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60582776 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60582776 LIMIT 2 [ RunTime:0.002970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60582776 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
select * from pdf where partno='1725380' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725380' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60581108 LIMIT 5 [ RunTime:0.003959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60581108 ORDER BY `minOrder` ASC [ RunTime:0.005842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60581108 ORDER BY `unit` DESC [ RunTime:0.007134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60581108 LIMIT 2 [ RunTime:0.005523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60581108 ORDER BY `minOrder` ASC [ RunTime:0.007305s ]
select * from pdf where partno='1725367' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725367' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60565158 LIMIT 5 [ RunTime:0.024769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565158 ORDER BY `minOrder` ASC [ RunTime:0.008885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60565158 ORDER BY `unit` DESC [ RunTime:0.007223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60565158 LIMIT 2 [ RunTime:0.013560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565158 ORDER BY `minOrder` ASC [ RunTime:0.004973s ]
select * from pdf where partno='1725354' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725354' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60565118 LIMIT 5 [ RunTime:0.006579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565118 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60565118 ORDER BY `unit` DESC [ RunTime:0.008427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60565118 LIMIT 2 [ RunTime:0.004663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565118 ORDER BY `minOrder` ASC [ RunTime:0.013491s ]
select * from pdf where partno='1725341' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725341' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.017571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60565040 LIMIT 5 [ RunTime:0.009976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565040 ORDER BY `minOrder` ASC [ RunTime:0.014373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60565040 ORDER BY `unit` DESC [ RunTime:0.006268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60565040 LIMIT 2 [ RunTime:0.002659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565040 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1725315' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725315' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60557327 LIMIT 5 [ RunTime:0.004184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60557327 ORDER BY `minOrder` ASC [ RunTime:0.001259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60557327 ORDER BY `unit` DESC [ RunTime:0.001095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60557327 LIMIT 2 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60557327 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='1725390000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725390000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT `id` FROM `stock` WHERE `id` <> 60557327 AND `partno` = '1725390000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657571 [ RunTime:0.002685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60557160 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60557160 ORDER BY `minOrder` ASC [ RunTime:0.004908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60557160 ORDER BY `unit` DESC [ RunTime:0.013451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60557160 LIMIT 2 [ RunTime:0.007375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60557160 ORDER BY `minOrder` ASC [ RunTime:0.003386s ]
select * from pdf where partno='1725380000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725380000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000932s ]
SELECT `id` FROM `stock` WHERE `id` <> 60557160 AND `partno` = '1725380000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657310 [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60557128 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60557128 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60557128 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60557128 LIMIT 2 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60557128 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
select * from pdf where partno='1725370000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725370000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001692s ]
SELECT `id` FROM `stock` WHERE `id` <> 60557128 AND `partno` = '1725370000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657216 [ RunTime:0.004468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60556795 LIMIT 5 [ RunTime:0.003407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60556795 ORDER BY `minOrder` ASC [ RunTime:0.004420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60556795 ORDER BY `unit` DESC [ RunTime:0.006426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60556795 LIMIT 2 [ RunTime:0.005512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60556795 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='1725360000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725360000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018558s ]
SELECT `id` FROM `stock` WHERE `id` <> 60556795 AND `partno` = '1725360000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19657091 [ RunTime:0.000916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60556176 LIMIT 5 [ RunTime:0.005798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60556176 ORDER BY `minOrder` ASC [ RunTime:0.013288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60556176 ORDER BY `unit` DESC [ RunTime:0.005359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60556176 LIMIT 2 [ RunTime:0.014360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60556176 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='1725340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010587s ]
SELECT `id` FROM `stock` WHERE `id` <> 60556176 AND `partno` = '1725340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.032367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656752 [ RunTime:0.022180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60556080 LIMIT 5 [ RunTime:0.002520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60556080 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60556080 ORDER BY `unit` DESC [ RunTime:0.006124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60556080 LIMIT 2 [ RunTime:0.011574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60556080 ORDER BY `minOrder` ASC [ RunTime:0.016435s ]
select * from pdf where partno='1725330000' and brandshort='Weidmüller' limit 1 [ RunTime:0.015894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725330000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015194s ]
SELECT `id` FROM `stock` WHERE `id` <> 60556080 AND `partno` = '1725330000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656439 [ RunTime:0.014547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60555405 LIMIT 5 [ RunTime:0.004882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60555405 ORDER BY `minOrder` ASC [ RunTime:0.006887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60555405 ORDER BY `unit` DESC [ RunTime:0.002321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60555405 LIMIT 2 [ RunTime:0.008588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60555405 ORDER BY `minOrder` ASC [ RunTime:0.014262s ]
select * from pdf where partno='1725320000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725320000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002112s ]
SELECT `id` FROM `stock` WHERE `id` <> 60555405 AND `partno` = '1725320000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656197 [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60555201 LIMIT 5 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60555201 ORDER BY `minOrder` ASC [ RunTime:0.000918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60555201 ORDER BY `unit` DESC [ RunTime:0.018266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60555201 LIMIT 2 [ RunTime:0.014984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60555201 ORDER BY `minOrder` ASC [ RunTime:0.011168s ]
select * from pdf where partno='1725310000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725310000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001775s ]
SELECT `id` FROM `stock` WHERE `id` <> 60555201 AND `partno` = '1725310000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655881 [ RunTime:0.000768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60554396 LIMIT 5 [ RunTime:0.003126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60554396 ORDER BY `minOrder` ASC [ RunTime:0.017787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60554396 ORDER BY `unit` DESC [ RunTime:0.010618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60554396 LIMIT 2 [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60554396 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='1725300000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1725300000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012230s ]
SELECT `id` FROM `stock` WHERE `id` <> 60554396 AND `partno` = '1725300000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655404 [ RunTime:0.002843s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007807s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003408s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001530s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006362s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000989s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001349s ]
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 '17253%' OR `brand` LIKE '17253%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001087s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '17253%' OR `brand` LIKE '17253%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001223s ]