SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002457s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.162' , `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=SMCJ54C&search=1' [ RunTime:0.001763s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002850s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003238s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001779s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.162' ) [ RunTime:0.001051s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001597s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005234s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001609s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ54C' LIMIT 1 [ RunTime:0.008120s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-18 09:47:43' WHERE `partno` = 'SMCJ54C' [ RunTime:0.013278s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001488s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016543s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667696 LIMIT 5 [ RunTime:0.024121s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667696 ORDER BY `minOrder` ASC [ RunTime:0.007513s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667696 ORDER BY `unit` DESC [ RunTime:0.023508s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.026963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667696 LIMIT 2 [ RunTime:0.056648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667696 ORDER BY `minOrder` ASC [ RunTime:0.013012s ]
select * from pdf where partno='SMCJ54CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.038264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809516 LIMIT 5 [ RunTime:0.025105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809516 ORDER BY `minOrder` ASC [ RunTime:0.035885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809516 ORDER BY `unit` DESC [ RunTime:0.058746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809516 LIMIT 2 [ RunTime:0.010002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809516 ORDER BY `minOrder` ASC [ RunTime:0.032726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820403 LIMIT 5 [ RunTime:0.014277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820403 ORDER BY `minOrder` ASC [ RunTime:0.025717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820403 ORDER BY `unit` DESC [ RunTime:0.027644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820403 LIMIT 2 [ RunTime:0.015546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820403 ORDER BY `minOrder` ASC [ RunTime:0.012634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678055 LIMIT 5 [ RunTime:0.049736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678055 ORDER BY `minOrder` ASC [ RunTime:0.031597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678055 ORDER BY `unit` DESC [ RunTime:0.034874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678055 LIMIT 2 [ RunTime:0.027014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678055 ORDER BY `minOrder` ASC [ RunTime:0.021174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692184 LIMIT 5 [ RunTime:0.028985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692184 ORDER BY `minOrder` ASC [ RunTime:0.031359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692184 ORDER BY `unit` DESC [ RunTime:0.035458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692184 LIMIT 2 [ RunTime:0.029095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692184 ORDER BY `minOrder` ASC [ RunTime:0.033803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800889 LIMIT 5 [ RunTime:0.013694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800889 ORDER BY `minOrder` ASC [ RunTime:0.016341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800889 ORDER BY `unit` DESC [ RunTime:0.018183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800889 LIMIT 2 [ RunTime:0.045291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800889 ORDER BY `minOrder` ASC [ RunTime:0.029634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800087 LIMIT 5 [ RunTime:0.008382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800087 ORDER BY `minOrder` ASC [ RunTime:0.041151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800087 ORDER BY `unit` DESC [ RunTime:0.018314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800087 LIMIT 2 [ RunTime:0.034645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800087 ORDER BY `minOrder` ASC [ RunTime:0.012620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832594 LIMIT 5 [ RunTime:0.013702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832594 ORDER BY `minOrder` ASC [ RunTime:0.011702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832594 ORDER BY `unit` DESC [ RunTime:0.041772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832594 LIMIT 2 [ RunTime:0.001151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832594 ORDER BY `minOrder` ASC [ RunTime:0.016481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692543 LIMIT 5 [ RunTime:0.045542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692543 ORDER BY `minOrder` ASC [ RunTime:0.006693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692543 ORDER BY `unit` DESC [ RunTime:0.030867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692543 LIMIT 2 [ RunTime:0.045016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692543 ORDER BY `minOrder` ASC [ RunTime:0.025729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822165 LIMIT 5 [ RunTime:0.024306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822165 ORDER BY `minOrder` ASC [ RunTime:0.013529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14822165 ORDER BY `unit` DESC [ RunTime:0.007717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14822165 LIMIT 2 [ RunTime:0.024069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822165 ORDER BY `minOrder` ASC [ RunTime:0.013907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16693240 LIMIT 5 [ RunTime:0.019365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16693240 ORDER BY `minOrder` ASC [ RunTime:0.020947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16693240 ORDER BY `unit` DESC [ RunTime:0.023757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16693240 LIMIT 2 [ RunTime:0.010877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16693240 ORDER BY `minOrder` ASC [ RunTime:0.029262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692490 LIMIT 5 [ RunTime:0.027288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692490 ORDER BY `minOrder` ASC [ RunTime:0.019667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692490 ORDER BY `unit` DESC [ RunTime:0.022210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692490 LIMIT 2 [ RunTime:0.025629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692490 ORDER BY `minOrder` ASC [ RunTime:0.041160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691244 LIMIT 5 [ RunTime:0.028192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691244 ORDER BY `minOrder` ASC [ RunTime:0.033220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691244 ORDER BY `unit` DESC [ RunTime:0.041583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691244 LIMIT 2 [ RunTime:0.036477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691244 ORDER BY `minOrder` ASC [ RunTime:0.028495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689684 LIMIT 5 [ RunTime:0.015908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689684 ORDER BY `minOrder` ASC [ RunTime:0.036124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689684 ORDER BY `unit` DESC [ RunTime:0.017859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689684 LIMIT 2 [ RunTime:0.062313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689684 ORDER BY `minOrder` ASC [ RunTime:0.012054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689209 LIMIT 5 [ RunTime:0.045364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689209 ORDER BY `minOrder` ASC [ RunTime:0.042070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689209 ORDER BY `unit` DESC [ RunTime:0.028574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689209 LIMIT 2 [ RunTime:0.011364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689209 ORDER BY `minOrder` ASC [ RunTime:0.049971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689208 LIMIT 5 [ RunTime:0.076668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689208 ORDER BY `minOrder` ASC [ RunTime:0.063205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689208 ORDER BY `unit` DESC [ RunTime:0.027099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689208 LIMIT 2 [ RunTime:0.028114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689208 ORDER BY `minOrder` ASC [ RunTime:0.062049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689207 LIMIT 5 [ RunTime:0.030073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689207 ORDER BY `minOrder` ASC [ RunTime:0.052322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689207 ORDER BY `unit` DESC [ RunTime:0.048580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689207 LIMIT 2 [ RunTime:0.012115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689207 ORDER BY `minOrder` ASC [ RunTime:0.022984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680229 LIMIT 5 [ RunTime:0.004179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680229 ORDER BY `minOrder` ASC [ RunTime:0.036474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680229 ORDER BY `unit` DESC [ RunTime:0.013656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680229 LIMIT 2 [ RunTime:0.016758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680229 ORDER BY `minOrder` ASC [ RunTime:0.011221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676350 LIMIT 5 [ RunTime:0.050760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676350 ORDER BY `minOrder` ASC [ RunTime:0.055218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676350 ORDER BY `unit` DESC [ RunTime:0.028314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676350 LIMIT 2 [ RunTime:0.044589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676350 ORDER BY `minOrder` ASC [ RunTime:0.005305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676321 LIMIT 5 [ RunTime:0.045563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676321 ORDER BY `minOrder` ASC [ RunTime:0.021072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676321 ORDER BY `unit` DESC [ RunTime:0.035717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676321 LIMIT 2 [ RunTime:0.013678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676321 ORDER BY `minOrder` ASC [ RunTime:0.010950s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010308s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104894 LIMIT 5 [ RunTime:0.019882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104894 ORDER BY `minOrder` ASC [ RunTime:0.007715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104894 ORDER BY `unit` DESC [ RunTime:0.013448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104894 LIMIT 2 [ RunTime:0.031009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104894 ORDER BY `minOrder` ASC [ RunTime:0.003554s ]
select * from pdf where partno='SMCJ54CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.022184s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.033489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106223 LIMIT 5 [ RunTime:0.021743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106223 ORDER BY `minOrder` ASC [ RunTime:0.005349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106223 ORDER BY `unit` DESC [ RunTime:0.010383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106223 LIMIT 2 [ RunTime:0.037234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106223 ORDER BY `minOrder` ASC [ RunTime:0.036611s ]
select * from pdf where partno='SMCJ54CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.015340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.011037s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106223 AND `partno` = 'SMCJ54CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.024718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809516 [ RunTime:0.028707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118251 LIMIT 5 [ RunTime:0.009846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118251 ORDER BY `minOrder` ASC [ RunTime:0.034509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118251 ORDER BY `unit` DESC [ RunTime:0.003518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118251 LIMIT 2 [ RunTime:0.023367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118251 ORDER BY `minOrder` ASC [ RunTime:0.018094s ]
select * from pdf where partno='SMCJ54CA-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019358s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118251 AND `partno` = 'SMCJ54CA-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.029125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820403 [ RunTime:0.019908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155164 LIMIT 5 [ RunTime:0.014351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155164 ORDER BY `minOrder` ASC [ RunTime:0.018442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155164 ORDER BY `unit` DESC [ RunTime:0.033466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155164 LIMIT 2 [ RunTime:0.008379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155164 ORDER BY `minOrder` ASC [ RunTime:0.017247s ]
select * from pdf where partno='SMCJ54CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.012467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.008751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42116507 LIMIT 5 [ RunTime:0.049470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116507 ORDER BY `minOrder` ASC [ RunTime:0.039344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42116507 ORDER BY `unit` DESC [ RunTime:0.015347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42116507 LIMIT 2 [ RunTime:0.001741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116507 ORDER BY `minOrder` ASC [ RunTime:0.001956s ]
select * from pdf where partno='SMCJ54CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.019952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.025722s ]
SELECT `id` FROM `stock` WHERE `id` <> 42116507 AND `partno` = 'SMCJ54CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.042836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692543 [ RunTime:0.048253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142618 LIMIT 5 [ RunTime:0.011321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142618 ORDER BY `minOrder` ASC [ RunTime:0.043582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142618 ORDER BY `unit` DESC [ RunTime:0.054314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142618 LIMIT 2 [ RunTime:0.046432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142618 ORDER BY `minOrder` ASC [ RunTime:0.066245s ]
select * from pdf where partno='SMCJ54CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.028423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.015023s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142618 AND `partno` = 'SMCJ54CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.060153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665276 [ RunTime:0.015254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141830 LIMIT 5 [ RunTime:0.025315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141830 ORDER BY `minOrder` ASC [ RunTime:0.056130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141830 ORDER BY `unit` DESC [ RunTime:0.019774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141830 LIMIT 2 [ RunTime:0.015784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141830 ORDER BY `minOrder` ASC [ RunTime:0.021051s ]
select * from pdf where partno='SMCJ54CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.052131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.016171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123450 LIMIT 5 [ RunTime:0.024386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123450 ORDER BY `minOrder` ASC [ RunTime:0.018958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123450 ORDER BY `unit` DESC [ RunTime:0.008289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123450 LIMIT 2 [ RunTime:0.027383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123450 ORDER BY `minOrder` ASC [ RunTime:0.004500s ]
select * from pdf where partno='SMCJ54CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.005073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.030075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42115623 LIMIT 5 [ RunTime:0.013398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115623 ORDER BY `minOrder` ASC [ RunTime:0.017238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42115623 ORDER BY `unit` DESC [ RunTime:0.015248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42115623 LIMIT 2 [ RunTime:0.004484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115623 ORDER BY `minOrder` ASC [ RunTime:0.013011s ]
select * from pdf where partno='SMCJ54CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.020966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155854 LIMIT 5 [ RunTime:0.000822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155854 ORDER BY `minOrder` ASC [ RunTime:0.009438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155854 ORDER BY `unit` DESC [ RunTime:0.011621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155854 LIMIT 2 [ RunTime:0.003187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155854 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='SMCJ54CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.007979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.000887s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155854 AND `partno` = 'SMCJ54CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16693240 [ RunTime:0.004444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105751 LIMIT 5 [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105751 ORDER BY `minOrder` ASC [ RunTime:0.005213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105751 ORDER BY `unit` DESC [ RunTime:0.012295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105751 LIMIT 2 [ RunTime:0.003462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105751 ORDER BY `minOrder` ASC [ RunTime:0.002106s ]
select * from pdf where partno='SMCJ54CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169213 LIMIT 5 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169213 ORDER BY `minOrder` ASC [ RunTime:0.008135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169213 ORDER BY `unit` DESC [ RunTime:0.002353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169213 LIMIT 2 [ RunTime:0.004850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169213 ORDER BY `minOrder` ASC [ RunTime:0.009686s ]
select * from pdf where partno='SMCJ54CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42415235 LIMIT 5 [ RunTime:0.008141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415235 ORDER BY `minOrder` ASC [ RunTime:0.027112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42415235 ORDER BY `unit` DESC [ RunTime:0.012519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42415235 LIMIT 2 [ RunTime:0.004709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415235 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='SMCJ54CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005662s ]
SELECT `id` FROM `stock` WHERE `id` <> 42415235 AND `partno` = 'SMCJ54CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.020943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823982 [ RunTime:0.010829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42413466 LIMIT 5 [ RunTime:0.013599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413466 ORDER BY `minOrder` ASC [ RunTime:0.011739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42413466 ORDER BY `unit` DESC [ RunTime:0.006664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42413466 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413466 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
select * from pdf where partno='SMCJ54CA-HRAT7' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.011950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-HRAT7' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001290s ]
SELECT `id` FROM `stock` WHERE `id` <> 42413466 AND `partno` = 'SMCJ54CA-HRAT7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823792 [ RunTime:0.010689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42413465 LIMIT 5 [ RunTime:0.002198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413465 ORDER BY `minOrder` ASC [ RunTime:0.005889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42413465 ORDER BY `unit` DESC [ RunTime:0.013919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42413465 LIMIT 2 [ RunTime:0.005823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413465 ORDER BY `minOrder` ASC [ RunTime:0.004592s ]
select * from pdf where partno='SMCJ54CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000653s ]
SELECT `id` FROM `stock` WHERE `id` <> 42413465 AND `partno` = 'SMCJ54CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823791 [ RunTime:0.006884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42311513 LIMIT 5 [ RunTime:0.013758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42311513 ORDER BY `minOrder` ASC [ RunTime:0.005148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42311513 ORDER BY `unit` DESC [ RunTime:0.002966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42311513 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42311513 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
select * from pdf where partno='SMCJ54CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012557s ]
SELECT `id` FROM `stock` WHERE `id` <> 42311513 AND `partno` = 'SMCJ54CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.004105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680229 [ RunTime:0.004858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290603 LIMIT 5 [ RunTime:0.013599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290603 ORDER BY `minOrder` ASC [ RunTime:0.039504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290603 ORDER BY `unit` DESC [ RunTime:0.027101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290603 LIMIT 2 [ RunTime:0.021869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290603 ORDER BY `minOrder` ASC [ RunTime:0.005762s ]
select * from pdf where partno='SMCJ54CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.014700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.003296s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290603 AND `partno` = 'SMCJ54CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.011616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920056 [ RunTime:0.030898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42290602 LIMIT 5 [ RunTime:0.013636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290602 ORDER BY `minOrder` ASC [ RunTime:0.017390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42290602 ORDER BY `unit` DESC [ RunTime:0.013931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42290602 LIMIT 2 [ RunTime:0.015326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42290602 ORDER BY `minOrder` ASC [ RunTime:0.005499s ]
select * from pdf where partno='SMCJ54CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.003418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.010275s ]
SELECT `id` FROM `stock` WHERE `id` <> 42290602 AND `partno` = 'SMCJ54CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.017580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920055 [ RunTime:0.017646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42281258 LIMIT 5 [ RunTime:0.033023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281258 ORDER BY `minOrder` ASC [ RunTime:0.019807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42281258 ORDER BY `unit` DESC [ RunTime:0.057851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42281258 LIMIT 2 [ RunTime:0.021894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281258 ORDER BY `minOrder` ASC [ RunTime:0.009626s ]
select * from pdf where partno='SMCJ54CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.032106s ]
SELECT `id` FROM `stock` WHERE `id` <> 42281258 AND `partno` = 'SMCJ54CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816284 [ RunTime:0.037495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42280891 LIMIT 5 [ RunTime:0.030438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280891 ORDER BY `minOrder` ASC [ RunTime:0.025777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42280891 ORDER BY `unit` DESC [ RunTime:0.028962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42280891 LIMIT 2 [ RunTime:0.005195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42280891 ORDER BY `minOrder` ASC [ RunTime:0.016895s ]
select * from pdf where partno='SMCJ54CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ54CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031240s ]
SELECT `id` FROM `stock` WHERE `id` <> 42280891 AND `partno` = 'SMCJ54CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918623 [ RunTime:0.024692s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005384s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030518s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014162s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009612s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026940s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011392s ]
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 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010283s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ54C%' OR `brand` LIKE 'SMCJ54C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011430s ]