SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002769s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=78133&search=1' [ RunTime:0.002971s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002451s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002328s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.001975s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003857s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002765s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002066s ]
SELECT * FROM `stock_search` WHERE `partno` = '78133' LIMIT 1 [ RunTime:0.005396s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 12:14:42' WHERE `partno` = '78133' [ RunTime:0.025842s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002430s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008085s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516070 LIMIT 5 [ RunTime:0.002820s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516070 ORDER BY `minOrder` ASC [ RunTime:0.007274s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13516070 ORDER BY `unit` DESC [ RunTime:0.001572s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13516070 LIMIT 2 [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516070 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18901463 LIMIT 5 [ RunTime:0.001302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18901463 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18901463 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18901463 LIMIT 2 [ RunTime:0.002474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18901463 ORDER BY `minOrder` ASC [ RunTime:0.009264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251449 LIMIT 5 [ RunTime:0.003261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251449 ORDER BY `minOrder` ASC [ RunTime:0.006641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15251449 ORDER BY `unit` DESC [ RunTime:0.000448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15251449 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251449 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18903153 LIMIT 5 [ RunTime:0.005985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903153 ORDER BY `minOrder` ASC [ RunTime:0.011263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18903153 ORDER BY `unit` DESC [ RunTime:0.014051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18903153 LIMIT 2 [ RunTime:0.011578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18903153 ORDER BY `minOrder` ASC [ RunTime:0.002516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389505 LIMIT 5 [ RunTime:0.006043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389505 ORDER BY `minOrder` ASC [ RunTime:0.004098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389505 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389505 LIMIT 2 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389505 ORDER BY `minOrder` ASC [ RunTime:0.004332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12430 LIMIT 5 [ RunTime:0.004024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12430 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12430 ORDER BY `unit` DESC [ RunTime:0.009414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12430 LIMIT 2 [ RunTime:0.004059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12430 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781337-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.003170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18916517 LIMIT 5 [ RunTime:0.002356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18916517 ORDER BY `minOrder` ASC [ RunTime:0.002927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18916517 ORDER BY `unit` DESC [ RunTime:0.006903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18916517 LIMIT 2 [ RunTime:0.015780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18916517 ORDER BY `minOrder` ASC [ RunTime:0.002108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17035947 LIMIT 5 [ RunTime:0.015185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17035947 ORDER BY `minOrder` ASC [ RunTime:0.003433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17035947 ORDER BY `unit` DESC [ RunTime:0.002087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17035947 LIMIT 2 [ RunTime:0.001077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17035947 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376813 LIMIT 5 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376813 ORDER BY `minOrder` ASC [ RunTime:0.014329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376813 ORDER BY `unit` DESC [ RunTime:0.001864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376813 LIMIT 2 [ RunTime:0.001870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376813 ORDER BY `minOrder` ASC [ RunTime:0.005171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374343 LIMIT 5 [ RunTime:0.003478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374343 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13374343 ORDER BY `unit` DESC [ RunTime:0.000395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13374343 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374343 ORDER BY `minOrder` ASC [ RunTime:0.002073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374284 LIMIT 5 [ RunTime:0.009165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374284 ORDER BY `minOrder` ASC [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13374284 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13374284 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374284 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
select * from pdf where partno='781333-01' and brandshort='NI' limit 1 [ RunTime:0.012480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266920 LIMIT 5 [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13266920 ORDER BY `minOrder` ASC [ RunTime:0.002671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13266920 ORDER BY `unit` DESC [ RunTime:0.000476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13266920 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13266920 ORDER BY `minOrder` ASC [ RunTime:0.002722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12275253 LIMIT 5 [ RunTime:0.002985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12275253 ORDER BY `minOrder` ASC [ RunTime:0.002775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12275253 ORDER BY `unit` DESC [ RunTime:0.004836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12275253 LIMIT 2 [ RunTime:0.006461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12275253 ORDER BY `minOrder` ASC [ RunTime:0.003831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993191 LIMIT 5 [ RunTime:0.002342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11993191 ORDER BY `minOrder` ASC [ RunTime:0.004523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11993191 ORDER BY `unit` DESC [ RunTime:0.006301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11993191 LIMIT 2 [ RunTime:0.001646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11993191 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993099 LIMIT 5 [ RunTime:0.006192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11993099 ORDER BY `minOrder` ASC [ RunTime:0.005250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11993099 ORDER BY `unit` DESC [ RunTime:0.003069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11993099 LIMIT 2 [ RunTime:0.004268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11993099 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993077 LIMIT 5 [ RunTime:0.004197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11993077 ORDER BY `minOrder` ASC [ RunTime:0.001993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11993077 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11993077 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11993077 ORDER BY `minOrder` ASC [ RunTime:0.001786s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004781s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56185838 LIMIT 5 [ RunTime:0.013077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56185838 ORDER BY `minOrder` ASC [ RunTime:0.007292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56185838 ORDER BY `unit` DESC [ RunTime:0.014409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56185838 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56185838 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='78133 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.010812s ]
SELECT `id` FROM `stock` WHERE `id` <> 56185838 AND `partno` = '78133 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389505 [ RunTime:0.002518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57761092 LIMIT 5 [ RunTime:0.001873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57761092 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57761092 ORDER BY `unit` DESC [ RunTime:0.005987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57761092 LIMIT 2 [ RunTime:0.015807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57761092 ORDER BY `minOrder` ASC [ RunTime:0.009301s ]
select * from pdf where partno='781337-01' and brandshort='NI' limit 1 [ RunTime:0.001746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781337-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56685117 LIMIT 5 [ RunTime:0.000958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685117 ORDER BY `minOrder` ASC [ RunTime:0.011045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56685117 ORDER BY `unit` DESC [ RunTime:0.004497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56685117 LIMIT 2 [ RunTime:0.014589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685117 ORDER BY `minOrder` ASC [ RunTime:0.008859s ]
select * from pdf where partno='781338-02' and brandshort='NI' limit 1 [ RunTime:0.008455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781338-02' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.017292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56685920 LIMIT 5 [ RunTime:0.022310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685920 ORDER BY `minOrder` ASC [ RunTime:0.029328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56685920 ORDER BY `unit` DESC [ RunTime:0.001547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56685920 LIMIT 2 [ RunTime:0.011660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56685920 ORDER BY `minOrder` ASC [ RunTime:0.008876s ]
select * from pdf where partno='781338-01' and brandshort='NI' limit 1 [ RunTime:0.014004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781338-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.037753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57761882 LIMIT 5 [ RunTime:0.018175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57761882 ORDER BY `minOrder` ASC [ RunTime:0.023326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57761882 ORDER BY `unit` DESC [ RunTime:0.009283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57761882 LIMIT 2 [ RunTime:0.012684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57761882 ORDER BY `minOrder` ASC [ RunTime:0.030264s ]
select * from pdf where partno='781336-01' and brandshort='NI' limit 1 [ RunTime:0.005303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781336-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.023457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57608629 LIMIT 5 [ RunTime:0.017149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57608629 ORDER BY `minOrder` ASC [ RunTime:0.002283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57608629 ORDER BY `unit` DESC [ RunTime:0.016398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57608629 LIMIT 2 [ RunTime:0.008427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57608629 ORDER BY `minOrder` ASC [ RunTime:0.003353s ]
select * from pdf where partno='781334-01' and brandshort='NI' limit 1 [ RunTime:0.002924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781334-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.008409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57608528 LIMIT 5 [ RunTime:0.022969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57608528 ORDER BY `minOrder` ASC [ RunTime:0.021214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57608528 ORDER BY `unit` DESC [ RunTime:0.017686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57608528 LIMIT 2 [ RunTime:0.035811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57608528 ORDER BY `minOrder` ASC [ RunTime:0.002061s ]
select * from pdf where partno='781333-01' and brandshort='NI' limit 1 [ RunTime:0.011431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '781333-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.010580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57473534 LIMIT 5 [ RunTime:0.026341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57473534 ORDER BY `minOrder` ASC [ RunTime:0.010987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57473534 ORDER BY `unit` DESC [ RunTime:0.038924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57473534 LIMIT 2 [ RunTime:0.013908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57473534 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
select * from pdf where partno='78133' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009524s ]
SELECT `id` FROM `stock` WHERE `id` <> 57473534 AND `partno` = '78133' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12275253 [ RunTime:0.013828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57405031 LIMIT 5 [ RunTime:0.003622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57405031 ORDER BY `minOrder` ASC [ RunTime:0.008041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57405031 ORDER BY `unit` DESC [ RunTime:0.008904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57405031 LIMIT 2 [ RunTime:0.019082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57405031 ORDER BY `minOrder` ASC [ RunTime:0.004930s ]
select * from pdf where partno='78133079' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.012175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133079' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.006017s ]
SELECT `id` FROM `stock` WHERE `id` <> 57405031 AND `partno` = '78133079' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.029403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993191 [ RunTime:0.011736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57405010 LIMIT 5 [ RunTime:0.018855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57405010 ORDER BY `minOrder` ASC [ RunTime:0.019496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57405010 ORDER BY `unit` DESC [ RunTime:0.031373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57405010 LIMIT 2 [ RunTime:0.005303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57405010 ORDER BY `minOrder` ASC [ RunTime:0.010855s ]
select * from pdf where partno='78133077' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.011316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133077' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.003068s ]
SELECT `id` FROM `stock` WHERE `id` <> 57405010 AND `partno` = '78133077' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.030276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266920 [ RunTime:0.029777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57404948 LIMIT 5 [ RunTime:0.030343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57404948 ORDER BY `minOrder` ASC [ RunTime:0.007971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57404948 ORDER BY `unit` DESC [ RunTime:0.012528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57404948 LIMIT 2 [ RunTime:0.038265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57404948 ORDER BY `minOrder` ASC [ RunTime:0.013950s ]
select * from pdf where partno='78133073' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.012379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133073' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.010814s ]
SELECT `id` FROM `stock` WHERE `id` <> 57404948 AND `partno` = '78133073' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.013499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993099 [ RunTime:0.014187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57404907 LIMIT 5 [ RunTime:0.006145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57404907 ORDER BY `minOrder` ASC [ RunTime:0.022084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57404907 ORDER BY `unit` DESC [ RunTime:0.015304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57404907 LIMIT 2 [ RunTime:0.021127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57404907 ORDER BY `minOrder` ASC [ RunTime:0.002194s ]
select * from pdf where partno='78133071' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133071' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.003504s ]
SELECT `id` FROM `stock` WHERE `id` <> 57404907 AND `partno` = '78133071' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.011829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993077 [ RunTime:0.010525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56202160 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56202160 ORDER BY `minOrder` ASC [ RunTime:0.003775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56202160 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56202160 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56202160 ORDER BY `minOrder` ASC [ RunTime:0.000925s ]
select * from pdf where partno='78133 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.004537s ]
SELECT `id` FROM `stock` WHERE `id` <> 56202160 AND `partno` = '78133 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.006662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376813 [ RunTime:0.001251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56192572 LIMIT 5 [ RunTime:0.008366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56192572 ORDER BY `minOrder` ASC [ RunTime:0.004451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56192572 ORDER BY `unit` DESC [ RunTime:0.006031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56192572 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56192572 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='78133 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '78133 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002805s ]
SELECT `id` FROM `stock` WHERE `id` <> 56192572 AND `partno` = '78133 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516070 [ RunTime:0.001847s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001176s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004322s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003617s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001060s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003470s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002081s ]
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 '78133%' OR `brand` LIKE '78133%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001978s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '78133%' OR `brand` LIKE '78133%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001129s ]