SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002239s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.202' , `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=DA10&search=1' [ RunTime:0.003042s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002529s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000767s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002957s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.202' ) [ RunTime:0.006483s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002316s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002072s ]
SELECT * FROM `stock_search` WHERE `partno` = 'DA10' LIMIT 1 [ RunTime:0.002656s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 04:39:42' WHERE `partno` = 'DA10' [ RunTime:0.007058s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002343s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011313s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14253381 LIMIT 5 [ RunTime:0.009933s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14253381 ORDER BY `minOrder` ASC [ RunTime:0.019235s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14253381 ORDER BY `unit` DESC [ RunTime:0.005828s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14253381 LIMIT 2 [ RunTime:0.002663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14253381 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13370238 LIMIT 5 [ RunTime:0.004630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13370238 ORDER BY `minOrder` ASC [ RunTime:0.003517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13370238 ORDER BY `unit` DESC [ RunTime:0.024680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13370238 LIMIT 2 [ RunTime:0.008293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13370238 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17853761 LIMIT 5 [ RunTime:0.033447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17853761 ORDER BY `minOrder` ASC [ RunTime:0.004542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17853761 ORDER BY `unit` DESC [ RunTime:0.002545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17853761 LIMIT 2 [ RunTime:0.003833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17853761 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13369135 LIMIT 5 [ RunTime:0.004160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369135 ORDER BY `minOrder` ASC [ RunTime:0.002563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13369135 ORDER BY `unit` DESC [ RunTime:0.007061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13369135 LIMIT 2 [ RunTime:0.009575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369135 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13369051 LIMIT 5 [ RunTime:0.003264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369051 ORDER BY `minOrder` ASC [ RunTime:0.005445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13369051 ORDER BY `unit` DESC [ RunTime:0.008264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13369051 LIMIT 2 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369051 ORDER BY `minOrder` ASC [ RunTime:0.003800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281670 LIMIT 5 [ RunTime:0.005286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281670 ORDER BY `minOrder` ASC [ RunTime:0.010488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281670 ORDER BY `unit` DESC [ RunTime:0.002952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281670 LIMIT 2 [ RunTime:0.005580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281670 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13369154 LIMIT 5 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369154 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13369154 ORDER BY `unit` DESC [ RunTime:0.000629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13369154 LIMIT 2 [ RunTime:0.002360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369154 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13369155 LIMIT 5 [ RunTime:0.001764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369155 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13369155 ORDER BY `unit` DESC [ RunTime:0.005069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13369155 LIMIT 2 [ RunTime:0.006458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13369155 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14253600 LIMIT 5 [ RunTime:0.018089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14253600 ORDER BY `minOrder` ASC [ RunTime:0.023640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14253600 ORDER BY `unit` DESC [ RunTime:0.021587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14253600 LIMIT 2 [ RunTime:0.013323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14253600 ORDER BY `minOrder` ASC [ RunTime:0.003320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17859377 LIMIT 5 [ RunTime:0.095763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17859377 ORDER BY `minOrder` ASC [ RunTime:0.011029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17859377 ORDER BY `unit` DESC [ RunTime:0.009904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17859377 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17859377 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14253604 LIMIT 5 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14253604 ORDER BY `minOrder` ASC [ RunTime:0.001636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14253604 ORDER BY `unit` DESC [ RunTime:0.003467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14253604 LIMIT 2 [ RunTime:0.004395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14253604 ORDER BY `minOrder` ASC [ RunTime:0.001833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19021851 LIMIT 5 [ RunTime:0.028716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021851 ORDER BY `minOrder` ASC [ RunTime:0.023013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19021851 ORDER BY `unit` DESC [ RunTime:0.015806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19021851 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021851 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19559779 LIMIT 5 [ RunTime:0.009249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559779 ORDER BY `minOrder` ASC [ RunTime:0.003093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19559779 ORDER BY `unit` DESC [ RunTime:0.006224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19559779 LIMIT 2 [ RunTime:0.010662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559779 ORDER BY `minOrder` ASC [ RunTime:0.009892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19559765 LIMIT 5 [ RunTime:0.010139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559765 ORDER BY `minOrder` ASC [ RunTime:0.014004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19559765 ORDER BY `unit` DESC [ RunTime:0.005865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19559765 LIMIT 2 [ RunTime:0.021570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559765 ORDER BY `minOrder` ASC [ RunTime:0.007290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19559723 LIMIT 5 [ RunTime:0.021124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559723 ORDER BY `minOrder` ASC [ RunTime:0.004882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19559723 ORDER BY `unit` DESC [ RunTime:0.017701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19559723 LIMIT 2 [ RunTime:0.038836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559723 ORDER BY `minOrder` ASC [ RunTime:0.010921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17859391 LIMIT 5 [ RunTime:0.005708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17859391 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17859391 ORDER BY `unit` DESC [ RunTime:0.000883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17859391 LIMIT 2 [ RunTime:0.002619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17859391 ORDER BY `minOrder` ASC [ RunTime:0.003483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17857775 LIMIT 5 [ RunTime:0.018512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17857775 ORDER BY `minOrder` ASC [ RunTime:0.011628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17857775 ORDER BY `unit` DESC [ RunTime:0.022438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17857775 LIMIT 2 [ RunTime:0.030276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17857775 ORDER BY `minOrder` ASC [ RunTime:0.006343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17857678 LIMIT 5 [ RunTime:0.006427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17857678 ORDER BY `minOrder` ASC [ RunTime:0.009439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17857678 ORDER BY `unit` DESC [ RunTime:0.024461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17857678 LIMIT 2 [ RunTime:0.021698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17857678 ORDER BY `minOrder` ASC [ RunTime:0.028386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17854908 LIMIT 5 [ RunTime:0.012013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17854908 ORDER BY `minOrder` ASC [ RunTime:0.009121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17854908 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17854908 LIMIT 2 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17854908 ORDER BY `minOrder` ASC [ RunTime:0.006456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17854907 LIMIT 5 [ RunTime:0.006366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17854907 ORDER BY `minOrder` ASC [ RunTime:0.008593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17854907 ORDER BY `unit` DESC [ RunTime:0.007775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17854907 LIMIT 2 [ RunTime:0.014851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17854907 ORDER BY `minOrder` ASC [ RunTime:0.003580s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51123488 LIMIT 5 [ RunTime:0.018699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51123488 ORDER BY `minOrder` ASC [ RunTime:0.017425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51123488 ORDER BY `unit` DESC [ RunTime:0.011024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51123488 LIMIT 2 [ RunTime:0.024804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51123488 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
select * from pdf where partno='da101jc-r' and brandshort='murata power solutions' limit 1 [ RunTime:0.018958s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'da101jc-r' OR `brand` LIKE 'murata power solutions%' ) ) LIMIT 1 [ RunTime:0.006157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51123808 LIMIT 5 [ RunTime:0.013544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51123808 ORDER BY `minOrder` ASC [ RunTime:0.000858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51123808 ORDER BY `unit` DESC [ RunTime:0.005963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51123808 LIMIT 2 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51123808 ORDER BY `minOrder` ASC [ RunTime:0.009845s ]
select * from pdf where partno='da103c' and brandshort='murata power solutions' limit 1 [ RunTime:0.003220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'da103c' OR `brand` LIKE 'murata power solutions%' ) ) LIMIT 1 [ RunTime:0.011314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51079942 LIMIT 5 [ RunTime:0.015611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51079942 ORDER BY `minOrder` ASC [ RunTime:0.005684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51079942 ORDER BY `unit` DESC [ RunTime:0.005680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51079942 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51079942 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='da10d0c000000000' and brandshort='red lion' limit 1 [ RunTime:0.009965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'da10d0c000000000' OR `brand` LIKE 'red lion%' ) ) LIMIT 1 [ RunTime:0.006978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51123807 LIMIT 5 [ RunTime:0.013145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51123807 ORDER BY `minOrder` ASC [ RunTime:0.009242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51123807 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51123807 LIMIT 2 [ RunTime:0.002398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51123807 ORDER BY `minOrder` ASC [ RunTime:0.012652s ]
select * from pdf where partno='da102c' and brandshort='murata power solutions' limit 1 [ RunTime:0.025342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'da102c' OR `brand` LIKE 'murata power solutions%' ) ) LIMIT 1 [ RunTime:0.005525s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58266890 LIMIT 5 [ RunTime:0.006095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58266890 ORDER BY `minOrder` ASC [ RunTime:0.012825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58266890 ORDER BY `unit` DESC [ RunTime:0.012795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58266890 LIMIT 2 [ RunTime:0.008610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58266890 ORDER BY `minOrder` ASC [ RunTime:0.006019s ]
select * from pdf where partno='DA101JC-R' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA101JC-R' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.008105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267050 LIMIT 5 [ RunTime:0.008895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267050 ORDER BY `minOrder` ASC [ RunTime:0.003454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267050 ORDER BY `unit` DESC [ RunTime:0.008977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267050 LIMIT 2 [ RunTime:0.003158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267050 ORDER BY `minOrder` ASC [ RunTime:0.001159s ]
select * from pdf where partno='DA101C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.011044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA101C' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.006786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267045 LIMIT 5 [ RunTime:0.004087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267045 ORDER BY `minOrder` ASC [ RunTime:0.010935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267045 ORDER BY `unit` DESC [ RunTime:0.002233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267045 LIMIT 2 [ RunTime:0.014159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267045 ORDER BY `minOrder` ASC [ RunTime:0.013310s ]
select * from pdf where partno='DA101MC-R' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.010619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA101MC-R' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.008767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780836 LIMIT 5 [ RunTime:0.009223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780836 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780836 ORDER BY `unit` DESC [ RunTime:0.007072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780836 LIMIT 2 [ RunTime:0.010303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780836 ORDER BY `minOrder` ASC [ RunTime:0.012208s ]
select * from pdf where partno='DA102J3GS215QF7' and brandshort='C&K' limit 1 [ RunTime:0.027105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA102J3GS215QF7' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.021547s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780836 AND `partno` = 'DA102J3GS215QF7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.002698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267051 LIMIT 5 [ RunTime:0.002648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267051 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267051 ORDER BY `unit` DESC [ RunTime:0.002605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267051 LIMIT 2 [ RunTime:0.005821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267051 ORDER BY `minOrder` ASC [ RunTime:0.001031s ]
select * from pdf where partno='DA102C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.009992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA102C' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41590809 LIMIT 5 [ RunTime:0.007700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590809 ORDER BY `minOrder` ASC [ RunTime:0.003762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41590809 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41590809 LIMIT 2 [ RunTime:0.003419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590809 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='DA10-050US' and brandshort='Artesyn Embedded Technologies/Embedded Power' limit 1 [ RunTime:0.001494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050US' OR `brand` LIKE 'Artesyn Embedded Technologies/Embedded Power%' ) ) LIMIT 1 [ RunTime:0.000948s ]
SELECT `id` FROM `stock` WHERE `id` <> 41590809 AND `partno` = 'DA10-050US' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn embedded technologies/embedded power%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41590804 LIMIT 5 [ RunTime:0.010454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590804 ORDER BY `minOrder` ASC [ RunTime:0.007061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41590804 ORDER BY `unit` DESC [ RunTime:0.004197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41590804 LIMIT 2 [ RunTime:0.006206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590804 ORDER BY `minOrder` ASC [ RunTime:0.001110s ]
select * from pdf where partno='DA10-050MP-M402' and brandshort='Artesyn Embedded Technologies/Embedded Power' limit 1 [ RunTime:0.003000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050MP-M402' OR `brand` LIKE 'Artesyn Embedded Technologies/Embedded Power%' ) ) LIMIT 1 [ RunTime:0.000908s ]
SELECT `id` FROM `stock` WHERE `id` <> 41590804 AND `partno` = 'DA10-050MP-M402' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn embedded technologies/embedded power%' ) [ RunTime:0.008237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43780830 LIMIT 5 [ RunTime:0.006470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780830 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43780830 ORDER BY `unit` DESC [ RunTime:0.007473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43780830 LIMIT 2 [ RunTime:0.004191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43780830 ORDER BY `minOrder` ASC [ RunTime:0.001629s ]
select * from pdf where partno='DA102J3RS215QF8' and brandshort='C&K' limit 1 [ RunTime:0.009805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA102J3RS215QF8' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.010804s ]
SELECT `id` FROM `stock` WHERE `id` <> 43780830 AND `partno` = 'DA102J3RS215QF8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.004142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43781170 LIMIT 5 [ RunTime:0.002922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43781170 ORDER BY `minOrder` ASC [ RunTime:0.002451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43781170 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43781170 LIMIT 2 [ RunTime:0.001522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43781170 ORDER BY `minOrder` ASC [ RunTime:0.002364s ]
select * from pdf where partno='DA103J12S217QF' and brandshort='C&K' limit 1 [ RunTime:0.008777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA103J12S217QF' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.010029s ]
SELECT `id` FROM `stock` WHERE `id` <> 43781170 AND `partno` = 'DA103J12S217QF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.002195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267283 LIMIT 5 [ RunTime:0.004975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267283 ORDER BY `minOrder` ASC [ RunTime:0.009308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267283 ORDER BY `unit` DESC [ RunTime:0.014911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267283 LIMIT 2 [ RunTime:0.007285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267283 ORDER BY `minOrder` ASC [ RunTime:0.003300s ]
select * from pdf where partno='DA102MC-R' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.004921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA102MC-R' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.002325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58267057 LIMIT 5 [ RunTime:0.006536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267057 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58267057 ORDER BY `unit` DESC [ RunTime:0.001432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58267057 LIMIT 2 [ RunTime:0.008423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58267057 ORDER BY `minOrder` ASC [ RunTime:0.014062s ]
select * from pdf where partno='DA103C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.011553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA103C' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.004431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41590805 LIMIT 5 [ RunTime:0.016475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590805 ORDER BY `minOrder` ASC [ RunTime:0.012603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41590805 ORDER BY `unit` DESC [ RunTime:0.003319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41590805 LIMIT 2 [ RunTime:0.005327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590805 ORDER BY `minOrder` ASC [ RunTime:0.001718s ]
select * from pdf where partno='DA10-050MP-M2.1' and brandshort='Artesyn Embedded Technologies/Embedded Power' limit 1 [ RunTime:0.005123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050MP-M2.1' OR `brand` LIKE 'Artesyn Embedded Technologies/Embedded Power%' ) ) LIMIT 1 [ RunTime:0.010721s ]
SELECT `id` FROM `stock` WHERE `id` <> 41590805 AND `partno` = 'DA10-050MP-M2.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn embedded technologies/embedded power%' ) [ RunTime:0.006960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58165157 LIMIT 5 [ RunTime:0.003571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165157 ORDER BY `minOrder` ASC [ RunTime:0.005941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58165157 ORDER BY `unit` DESC [ RunTime:0.003080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58165157 LIMIT 2 [ RunTime:0.000942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165157 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='DA10-050UK-M' and brandshort='ARTESYN / Advanced Energy' limit 1 [ RunTime:0.004253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050UK-M' OR `brand` LIKE 'ARTESYN / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.005520s ]
SELECT `id` FROM `stock` WHERE `id` <> 58165157 AND `partno` = 'DA10-050UK-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn / advanced energy%' ) [ RunTime:0.010527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17857775 [ RunTime:0.002723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58165691 LIMIT 5 [ RunTime:0.002296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165691 ORDER BY `minOrder` ASC [ RunTime:0.001249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58165691 ORDER BY `unit` DESC [ RunTime:0.004919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58165691 LIMIT 2 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165691 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
select * from pdf where partno='DA10-050AU-M' and brandshort='Artesyn Embedded Technologies/Embedded Power' limit 1 [ RunTime:0.006834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050AU-M' OR `brand` LIKE 'Artesyn Embedded Technologies/Embedded Power%' ) ) LIMIT 1 [ RunTime:0.010769s ]
SELECT `id` FROM `stock` WHERE `id` <> 58165691 AND `partno` = 'DA10-050AU-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn embedded technologies/embedded power%' ) [ RunTime:0.007110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58165163 LIMIT 5 [ RunTime:0.007612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165163 ORDER BY `minOrder` ASC [ RunTime:0.014929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58165163 ORDER BY `unit` DESC [ RunTime:0.004474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58165163 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165163 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='DA10-050AU-M' and brandshort='ARTESYN / Advanced Energy' limit 1 [ RunTime:0.001234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050AU-M' OR `brand` LIKE 'ARTESYN / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.001085s ]
SELECT `id` FROM `stock` WHERE `id` <> 58165163 AND `partno` = 'DA10-050AU-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn / advanced energy%' ) [ RunTime:0.008708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14071553 [ RunTime:0.013141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58165187 LIMIT 5 [ RunTime:0.001135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165187 ORDER BY `minOrder` ASC [ RunTime:0.001084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58165187 ORDER BY `unit` DESC [ RunTime:0.009891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58165187 LIMIT 2 [ RunTime:0.007695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58165187 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='DA10-050EU-M' and brandshort='ARTESYN / Advanced Energy' limit 1 [ RunTime:0.001907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050EU-M' OR `brand` LIKE 'ARTESYN / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.002710s ]
SELECT `id` FROM `stock` WHERE `id` <> 58165187 AND `partno` = 'DA10-050EU-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn / advanced energy%' ) [ RunTime:0.009143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16801934 [ RunTime:0.003480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41590806 LIMIT 5 [ RunTime:0.004109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590806 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41590806 ORDER BY `unit` DESC [ RunTime:0.011308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41590806 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41590806 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='DA10-050EU' and brandshort='Artesyn Embedded Technologies/Embedded Power' limit 1 [ RunTime:0.001344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10-050EU' OR `brand` LIKE 'Artesyn Embedded Technologies/Embedded Power%' ) ) LIMIT 1 [ RunTime:0.000712s ]
SELECT `id` FROM `stock` WHERE `id` <> 41590806 AND `partno` = 'DA10-050EU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%artesyn embedded technologies/embedded power%' ) [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58268071 LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58268071 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58268071 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58268071 LIMIT 2 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58268071 ORDER BY `minOrder` ASC [ RunTime:0.002710s ]
select * from pdf where partno='DA103JC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.002829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA103JC' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64389028 LIMIT 5 [ RunTime:0.002081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389028 ORDER BY `minOrder` ASC [ RunTime:0.003980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64389028 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64389028 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64389028 ORDER BY `minOrder` ASC [ RunTime:0.001666s ]
select * from pdf where partno='DA10D0C000000000' and brandshort='Red Lion Controls' limit 1 [ RunTime:0.001028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA10D0C000000000' OR `brand` LIKE 'Red Lion Controls%' ) ) LIMIT 1 [ RunTime:0.007350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58268074 LIMIT 5 [ RunTime:0.008922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58268074 ORDER BY `minOrder` ASC [ RunTime:0.001299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58268074 ORDER BY `unit` DESC [ RunTime:0.000783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58268074 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58268074 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
select * from pdf where partno='DA102JC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DA102JC' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.008102s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001306s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001067s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002187s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002057s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001136s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001110s ]
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 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004235s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DA10%' OR `brand` LIKE 'DA10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005387s ]