SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004008s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=tlc393ip&search=1' [ RunTime:0.020982s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004369s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.052610s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.008388s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.038092s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.006754s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.046129s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005821s ]
SELECT * FROM `stock_search` WHERE `partno` = 'tlc393ip' LIMIT 1 [ RunTime:0.078079s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 21:17:59' WHERE `partno` = 'tlc393ip' [ RunTime:0.029688s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.012899s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.115299s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255139 LIMIT 5 [ RunTime:0.048348s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255139 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19255139 ORDER BY `unit` DESC [ RunTime:0.163357s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19255139 LIMIT 2 [ RunTime:0.020510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255139 ORDER BY `minOrder` ASC [ RunTime:0.036054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255524 LIMIT 5 [ RunTime:0.026930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255524 ORDER BY `minOrder` ASC [ RunTime:0.050626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19255524 ORDER BY `unit` DESC [ RunTime:0.050639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19255524 LIMIT 2 [ RunTime:0.020715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255524 ORDER BY `minOrder` ASC [ RunTime:0.008956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19256161 LIMIT 5 [ RunTime:0.046433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19256161 ORDER BY `minOrder` ASC [ RunTime:0.025831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19256161 ORDER BY `unit` DESC [ RunTime:0.057899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19256161 LIMIT 2 [ RunTime:0.045000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19256161 ORDER BY `minOrder` ASC [ RunTime:0.040475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255027 LIMIT 5 [ RunTime:0.044988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255027 ORDER BY `minOrder` ASC [ RunTime:0.026582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19255027 ORDER BY `unit` DESC [ RunTime:0.010178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19255027 LIMIT 2 [ RunTime:0.015155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255027 ORDER BY `minOrder` ASC [ RunTime:0.050650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17137858 LIMIT 5 [ RunTime:0.059637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17137858 ORDER BY `minOrder` ASC [ RunTime:0.022213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17137858 ORDER BY `unit` DESC [ RunTime:0.030020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17137858 LIMIT 2 [ RunTime:0.039176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17137858 ORDER BY `minOrder` ASC [ RunTime:0.017659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143449 LIMIT 5 [ RunTime:0.052136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143449 ORDER BY `minOrder` ASC [ RunTime:0.014208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16143449 ORDER BY `unit` DESC [ RunTime:0.063710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16143449 LIMIT 2 [ RunTime:0.078833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143449 ORDER BY `minOrder` ASC [ RunTime:0.034515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143432 LIMIT 5 [ RunTime:0.015696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143432 ORDER BY `minOrder` ASC [ RunTime:0.080013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16143432 ORDER BY `unit` DESC [ RunTime:0.048895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16143432 LIMIT 2 [ RunTime:0.049854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16143432 ORDER BY `minOrder` ASC [ RunTime:0.036431s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32149351 LIMIT 5 [ RunTime:0.037450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32149351 ORDER BY `minOrder` ASC [ RunTime:0.033977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32149351 ORDER BY `unit` DESC [ RunTime:0.038806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32149351 LIMIT 2 [ RunTime:0.050946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32149351 ORDER BY `minOrder` ASC [ RunTime:0.027020s ]
select * from pdf where partno='tlc393ipwr' and brandshort='texas instruments' limit 1 [ RunTime:0.024487s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.006539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tlc393ipwr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.030500s ]
SELECT `id` FROM `stock` WHERE `id` <> 32149351 AND `partno` = 'tlc393ipwr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.038400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255139 [ RunTime:0.023982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51055676 LIMIT 5 [ RunTime:0.021902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51055676 ORDER BY `minOrder` ASC [ RunTime:0.051502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51055676 ORDER BY `unit` DESC [ RunTime:0.032314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51055676 LIMIT 2 [ RunTime:0.011668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51055676 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='tlc393ip' and brandshort='texas instruments' limit 1 [ RunTime:0.008834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tlc393ip' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.036179s ]
SELECT `id` FROM `stock` WHERE `id` <> 51055676 AND `partno` = 'tlc393ip' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.019783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255027 [ RunTime:0.011168s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63661868 LIMIT 5 [ RunTime:0.040889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63661868 ORDER BY `minOrder` ASC [ RunTime:0.023018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63661868 ORDER BY `unit` DESC [ RunTime:0.022527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63661868 LIMIT 2 [ RunTime:0.020382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63661868 ORDER BY `minOrder` ASC [ RunTime:0.023379s ]
select * from pdf where partno='TLC393IPWR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.071639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IPWR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.030395s ]
SELECT `id` FROM `stock` WHERE `id` <> 63661868 AND `partno` = 'TLC393IPWR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.017808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255139 [ RunTime:0.031395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63662776 LIMIT 5 [ RunTime:0.015733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63662776 ORDER BY `minOrder` ASC [ RunTime:0.016952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63662776 ORDER BY `unit` DESC [ RunTime:0.001056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63662776 LIMIT 2 [ RunTime:0.003260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63662776 ORDER BY `minOrder` ASC [ RunTime:0.011038s ]
select * from pdf where partno='TLC393IPW' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IPW' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.045980s ]
SELECT `id` FROM `stock` WHERE `id` <> 63662776 AND `partno` = 'TLC393IPW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.018698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255524 [ RunTime:0.026640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63661493 LIMIT 5 [ RunTime:0.029229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63661493 ORDER BY `minOrder` ASC [ RunTime:0.004633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63661493 ORDER BY `unit` DESC [ RunTime:0.003065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63661493 LIMIT 2 [ RunTime:0.027932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63661493 ORDER BY `minOrder` ASC [ RunTime:0.007214s ]
select * from pdf where partno='TLC393IP' and brandshort='Texas Instruments' limit 1 [ RunTime:0.043398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IP' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002197s ]
SELECT `id` FROM `stock` WHERE `id` <> 63661493 AND `partno` = 'TLC393IP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255027 [ RunTime:0.005524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63663933 LIMIT 5 [ RunTime:0.008580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663933 ORDER BY `minOrder` ASC [ RunTime:0.008419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63663933 ORDER BY `unit` DESC [ RunTime:0.018503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63663933 LIMIT 2 [ RunTime:0.014621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663933 ORDER BY `minOrder` ASC [ RunTime:0.014580s ]
select * from pdf where partno='TLC393IPWG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IPWG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.007753s ]
SELECT `id` FROM `stock` WHERE `id` <> 63663933 AND `partno` = 'TLC393IPWG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.005539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19256161 [ RunTime:0.009480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63663899 LIMIT 5 [ RunTime:0.031131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663899 ORDER BY `minOrder` ASC [ RunTime:0.016946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63663899 ORDER BY `unit` DESC [ RunTime:0.013147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63663899 LIMIT 2 [ RunTime:0.018471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663899 ORDER BY `minOrder` ASC [ RunTime:0.028421s ]
select * from pdf where partno='TLC393IPE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.018880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IPE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.022666s ]
SELECT `id` FROM `stock` WHERE `id` <> 63663899 AND `partno` = 'TLC393IPE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.014221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143449 [ RunTime:0.015034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63663832 LIMIT 5 [ RunTime:0.012109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663832 ORDER BY `minOrder` ASC [ RunTime:0.032545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63663832 ORDER BY `unit` DESC [ RunTime:0.020983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63663832 LIMIT 2 [ RunTime:0.015958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663832 ORDER BY `minOrder` ASC [ RunTime:0.043368s ]
select * from pdf where partno='TLC393IPG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.028048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IPG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.007529s ]
SELECT `id` FROM `stock` WHERE `id` <> 63663832 AND `partno` = 'TLC393IPG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.010134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16143432 [ RunTime:0.013956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63663767 LIMIT 5 [ RunTime:0.014406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663767 ORDER BY `minOrder` ASC [ RunTime:0.009788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63663767 ORDER BY `unit` DESC [ RunTime:0.011798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63663767 LIMIT 2 [ RunTime:0.061717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663767 ORDER BY `minOrder` ASC [ RunTime:0.014853s ]
select * from pdf where partno='TLC393IPWRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.023242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLC393IPWRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.019622s ]
SELECT `id` FROM `stock` WHERE `id` <> 63663767 AND `partno` = 'TLC393IPWRG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.019750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17137858 [ RunTime:0.008520s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054337s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047149s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048905s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.136307s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039449s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043097s ]
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 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038717s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'tlc393ip%' OR `brand` LIKE 'tlc393ip%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007203s ]