SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001980s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `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=P4SMA16C&search=1' [ RunTime:0.001913s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002169s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002320s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.001548s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002919s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002090s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMA16C' LIMIT 1 [ RunTime:0.004324s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-15 01:41:03' WHERE `partno` = 'P4SMA16C' [ RunTime:0.015760s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002336s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013715s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906601 LIMIT 5 [ RunTime:0.014611s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906601 ORDER BY `minOrder` ASC [ RunTime:0.012383s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906601 ORDER BY `unit` DESC [ RunTime:0.013116s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906601 LIMIT 2 [ RunTime:0.011367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906601 ORDER BY `minOrder` ASC [ RunTime:0.010753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915275 LIMIT 5 [ RunTime:0.006116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915275 ORDER BY `minOrder` ASC [ RunTime:0.026829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915275 ORDER BY `unit` DESC [ RunTime:0.011162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915275 LIMIT 2 [ RunTime:0.024326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915275 ORDER BY `minOrder` ASC [ RunTime:0.018997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685407 LIMIT 5 [ RunTime:0.012321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685407 ORDER BY `minOrder` ASC [ RunTime:0.016014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685407 ORDER BY `unit` DESC [ RunTime:0.008036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685407 LIMIT 2 [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685407 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825953 LIMIT 5 [ RunTime:0.015037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825953 ORDER BY `minOrder` ASC [ RunTime:0.028390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825953 ORDER BY `unit` DESC [ RunTime:0.009568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825953 LIMIT 2 [ RunTime:0.052128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825953 ORDER BY `minOrder` ASC [ RunTime:0.010446s ]
select * from pdf where partno='P4SMA16CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916594 LIMIT 5 [ RunTime:0.023162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916594 ORDER BY `minOrder` ASC [ RunTime:0.014573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916594 ORDER BY `unit` DESC [ RunTime:0.016224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916594 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916594 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692080 LIMIT 5 [ RunTime:0.006687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692080 ORDER BY `minOrder` ASC [ RunTime:0.014441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692080 ORDER BY `unit` DESC [ RunTime:0.008773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692080 LIMIT 2 [ RunTime:0.011894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692080 ORDER BY `minOrder` ASC [ RunTime:0.003138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691333 LIMIT 5 [ RunTime:0.020548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691333 ORDER BY `minOrder` ASC [ RunTime:0.024137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691333 ORDER BY `unit` DESC [ RunTime:0.019597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691333 LIMIT 2 [ RunTime:0.022906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691333 ORDER BY `minOrder` ASC [ RunTime:0.015878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689316 LIMIT 5 [ RunTime:0.028346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689316 ORDER BY `minOrder` ASC [ RunTime:0.008255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689316 ORDER BY `unit` DESC [ RunTime:0.004882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689316 LIMIT 2 [ RunTime:0.027501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689316 ORDER BY `minOrder` ASC [ RunTime:0.019371s ]
select * from pdf where partno='P4SMA16CAHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674592 LIMIT 5 [ RunTime:0.016322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674592 ORDER BY `minOrder` ASC [ RunTime:0.020711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674592 ORDER BY `unit` DESC [ RunTime:0.026486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674592 LIMIT 2 [ RunTime:0.009461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674592 ORDER BY `minOrder` ASC [ RunTime:0.002082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668953 LIMIT 5 [ RunTime:0.012326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668953 ORDER BY `minOrder` ASC [ RunTime:0.052295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668953 ORDER BY `unit` DESC [ RunTime:0.012955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668953 LIMIT 2 [ RunTime:0.021662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668953 ORDER BY `minOrder` ASC [ RunTime:0.013874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668308 LIMIT 5 [ RunTime:0.012228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668308 ORDER BY `minOrder` ASC [ RunTime:0.003436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668308 ORDER BY `unit` DESC [ RunTime:0.004939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668308 LIMIT 2 [ RunTime:0.001335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668308 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668307 LIMIT 5 [ RunTime:0.003913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668307 ORDER BY `minOrder` ASC [ RunTime:0.003343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668307 ORDER BY `unit` DESC [ RunTime:0.002437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668307 LIMIT 2 [ RunTime:0.001027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668307 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667618 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667618 ORDER BY `minOrder` ASC [ RunTime:0.001837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667618 ORDER BY `unit` DESC [ RunTime:0.003475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667618 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667618 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833288 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833288 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833288 ORDER BY `unit` DESC [ RunTime:0.004009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833288 LIMIT 2 [ RunTime:0.002944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833288 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828848 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828848 ORDER BY `minOrder` ASC [ RunTime:0.006932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828848 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828848 LIMIT 2 [ RunTime:0.003980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828848 ORDER BY `minOrder` ASC [ RunTime:0.010750s ]
select * from pdf where partno='P4SMA16CAHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818626 LIMIT 5 [ RunTime:0.009352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818626 ORDER BY `minOrder` ASC [ RunTime:0.002344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818626 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818626 LIMIT 2 [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818626 ORDER BY `minOrder` ASC [ RunTime:0.006986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815906 LIMIT 5 [ RunTime:0.019414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815906 ORDER BY `minOrder` ASC [ RunTime:0.008887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815906 ORDER BY `unit` DESC [ RunTime:0.012043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815906 LIMIT 2 [ RunTime:0.006352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815906 ORDER BY `minOrder` ASC [ RunTime:0.001540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808280 LIMIT 5 [ RunTime:0.001651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808280 ORDER BY `minOrder` ASC [ RunTime:0.005403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808280 ORDER BY `unit` DESC [ RunTime:0.002544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808280 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808280 ORDER BY `minOrder` ASC [ RunTime:0.004117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806098 LIMIT 5 [ RunTime:0.009197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806098 ORDER BY `minOrder` ASC [ RunTime:0.012251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806098 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806098 LIMIT 2 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806098 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806066 LIMIT 5 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806066 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806066 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806066 LIMIT 2 [ RunTime:0.002374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806066 ORDER BY `minOrder` ASC [ RunTime:0.001939s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001978s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160802 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160802 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160802 ORDER BY `unit` DESC [ RunTime:0.002022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160802 LIMIT 2 [ RunTime:0.006496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160802 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='P4SMA16CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.000900s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.000790s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160802 AND `partno` = 'P4SMA16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906601 [ RunTime:0.002844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113352 LIMIT 5 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113352 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113352 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113352 LIMIT 2 [ RunTime:0.001340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113352 ORDER BY `minOrder` ASC [ RunTime:0.001876s ]
select * from pdf where partno='P4SMA16CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000754s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113352 AND `partno` = 'P4SMA16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915275 [ RunTime:0.002322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123514 LIMIT 5 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123514 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123514 ORDER BY `unit` DESC [ RunTime:0.000568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123514 LIMIT 2 [ RunTime:0.001736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123514 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='P4SMA16CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127060 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127060 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127060 ORDER BY `unit` DESC [ RunTime:0.002561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127060 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127060 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='P4SMA16CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000702s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127060 AND `partno` = 'P4SMA16CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825953 [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42115541 LIMIT 5 [ RunTime:0.011471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115541 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42115541 ORDER BY `unit` DESC [ RunTime:0.003295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42115541 LIMIT 2 [ RunTime:0.001892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115541 ORDER BY `minOrder` ASC [ RunTime:0.008198s ]
select * from pdf where partno='P4SMA16CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003021s ]
SELECT `id` FROM `stock` WHERE `id` <> 42115541 AND `partno` = 'P4SMA16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916594 [ RunTime:0.006821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42289444 LIMIT 5 [ RunTime:0.003830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289444 ORDER BY `minOrder` ASC [ RunTime:0.003692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42289444 ORDER BY `unit` DESC [ RunTime:0.000794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42289444 LIMIT 2 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289444 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
select * from pdf where partno='P4SMA16CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001000s ]
SELECT `id` FROM `stock` WHERE `id` <> 42289444 AND `partno` = 'P4SMA16CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818626 [ RunTime:0.001789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237507 LIMIT 5 [ RunTime:0.001744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237507 ORDER BY `minOrder` ASC [ RunTime:0.003416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237507 ORDER BY `unit` DESC [ RunTime:0.003223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237507 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237507 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='P4SMA16CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010651s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237507 AND `partno` = 'P4SMA16CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.026109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815906 [ RunTime:0.017691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236780 LIMIT 5 [ RunTime:0.002949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236780 ORDER BY `minOrder` ASC [ RunTime:0.017120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236780 ORDER BY `unit` DESC [ RunTime:0.008883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236780 LIMIT 2 [ RunTime:0.005499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236780 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
select * from pdf where partno='P4SMA16CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016128s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236780 AND `partno` = 'P4SMA16CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674592 [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228597 LIMIT 5 [ RunTime:0.020327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228597 ORDER BY `minOrder` ASC [ RunTime:0.008225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228597 ORDER BY `unit` DESC [ RunTime:0.013110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228597 LIMIT 2 [ RunTime:0.013478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228597 ORDER BY `minOrder` ASC [ RunTime:0.004418s ]
select * from pdf where partno='P4SMA16CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005278s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228597 AND `partno` = 'P4SMA16CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913966 [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42211185 LIMIT 5 [ RunTime:0.003379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211185 ORDER BY `minOrder` ASC [ RunTime:0.004970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42211185 ORDER BY `unit` DESC [ RunTime:0.011312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42211185 LIMIT 2 [ RunTime:0.014561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211185 ORDER BY `minOrder` ASC [ RunTime:0.002682s ]
select * from pdf where partno='P4SMA16CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.016359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003152s ]
SELECT `id` FROM `stock` WHERE `id` <> 42211185 AND `partno` = 'P4SMA16CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668953 [ RunTime:0.019511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205443 LIMIT 5 [ RunTime:0.009866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205443 ORDER BY `minOrder` ASC [ RunTime:0.004963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205443 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205443 LIMIT 2 [ RunTime:0.011801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205443 ORDER BY `minOrder` ASC [ RunTime:0.009344s ]
select * from pdf where partno='P4SMA16CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004685s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205443 AND `partno` = 'P4SMA16CA-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911557 [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203373 LIMIT 5 [ RunTime:0.003455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203373 ORDER BY `minOrder` ASC [ RunTime:0.011603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203373 ORDER BY `unit` DESC [ RunTime:0.019280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203373 LIMIT 2 [ RunTime:0.025660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203373 ORDER BY `minOrder` ASC [ RunTime:0.009774s ]
select * from pdf where partno='P4SMA16CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.037995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.009204s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203373 AND `partno` = 'P4SMA16CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.035360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668308 [ RunTime:0.026930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203372 LIMIT 5 [ RunTime:0.023677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203372 ORDER BY `minOrder` ASC [ RunTime:0.020002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203372 ORDER BY `unit` DESC [ RunTime:0.015998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203372 LIMIT 2 [ RunTime:0.013147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203372 ORDER BY `minOrder` ASC [ RunTime:0.042781s ]
select * from pdf where partno='P4SMA16CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.023333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.006030s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203372 AND `partno` = 'P4SMA16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.008813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668307 [ RunTime:0.008249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203112 LIMIT 5 [ RunTime:0.007411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203112 ORDER BY `minOrder` ASC [ RunTime:0.012689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203112 ORDER BY `unit` DESC [ RunTime:0.003897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203112 LIMIT 2 [ RunTime:0.022184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203112 ORDER BY `minOrder` ASC [ RunTime:0.010093s ]
select * from pdf where partno='P4SMA16C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.017051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002345s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203112 AND `partno` = 'P4SMA16C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.006930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808280 [ RunTime:0.003917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202833 LIMIT 5 [ RunTime:0.004913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202833 ORDER BY `minOrder` ASC [ RunTime:0.013284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202833 ORDER BY `unit` DESC [ RunTime:0.002396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202833 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202833 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
select * from pdf where partno='P4SMA16CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.020021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003470s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202833 AND `partno` = 'P4SMA16CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911872 [ RunTime:0.005116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202388 LIMIT 5 [ RunTime:0.001034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202388 ORDER BY `minOrder` ASC [ RunTime:0.003415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202388 ORDER BY `unit` DESC [ RunTime:0.002426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202388 LIMIT 2 [ RunTime:0.001893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202388 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='P4SMA16CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.000820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202388 AND `partno` = 'P4SMA16CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911047 [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42199720 LIMIT 5 [ RunTime:0.001178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199720 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42199720 ORDER BY `unit` DESC [ RunTime:0.011556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42199720 LIMIT 2 [ RunTime:0.004937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199720 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='P4SMA16CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.004328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001423s ]
SELECT `id` FROM `stock` WHERE `id` <> 42199720 AND `partno` = 'P4SMA16CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919818 [ RunTime:0.012337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42192101 LIMIT 5 [ RunTime:0.004977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192101 ORDER BY `minOrder` ASC [ RunTime:0.009366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42192101 ORDER BY `unit` DESC [ RunTime:0.008778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42192101 LIMIT 2 [ RunTime:0.003961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192101 ORDER BY `minOrder` ASC [ RunTime:0.003767s ]
select * from pdf where partno='P4SMA16CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191744 LIMIT 5 [ RunTime:0.002712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191744 ORDER BY `minOrder` ASC [ RunTime:0.010375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191744 ORDER BY `unit` DESC [ RunTime:0.007251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191744 LIMIT 2 [ RunTime:0.002341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191744 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
select * from pdf where partno='P4SMA16CAS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.002018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CAS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.010597s ]
SELECT `id` FROM `stock` WHERE `id` <> 42191744 AND `partno` = 'P4SMA16CAS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919187 [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42190854 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190854 ORDER BY `minOrder` ASC [ RunTime:0.008876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42190854 ORDER BY `unit` DESC [ RunTime:0.009467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42190854 LIMIT 2 [ RunTime:0.004009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190854 ORDER BY `minOrder` ASC [ RunTime:0.002069s ]
select * from pdf where partno='P4SMA16CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009807s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010046s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007581s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001677s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003990s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017735s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020011s ]
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 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003987s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMA16C%' OR `brand` LIKE 'P4SMA16C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009090s ]