SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001739s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.95' , `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=ANT&search=1' [ RunTime:0.008837s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001326s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010862s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001219s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.95' ) [ RunTime:0.002663s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001215s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004552s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001424s ]
SELECT * FROM `stock_search` WHERE `partno` = 'ANT' LIMIT 1 [ RunTime:0.017596s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-18 23:07:57' WHERE `partno` = 'ANT' [ RunTime:0.037326s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002859s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.100159s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985200 LIMIT 5 [ RunTime:0.047386s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985200 ORDER BY `minOrder` ASC [ RunTime:0.047810s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985200 ORDER BY `unit` DESC [ RunTime:0.027129s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985200 LIMIT 2 [ RunTime:0.041204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985200 ORDER BY `minOrder` ASC [ RunTime:0.009742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13256651 LIMIT 5 [ RunTime:0.011405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13256651 ORDER BY `minOrder` ASC [ RunTime:0.013859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13256651 ORDER BY `unit` DESC [ RunTime:0.002039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13256651 LIMIT 2 [ RunTime:0.029527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13256651 ORDER BY `minOrder` ASC [ RunTime:0.039104s ]
select * from pdf where partno='A5645H' and brandshort='Antenova' limit 1 [ RunTime:0.025376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254803 LIMIT 5 [ RunTime:0.007039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254803 ORDER BY `minOrder` ASC [ RunTime:0.005725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254803 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254803 LIMIT 2 [ RunTime:0.021015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254803 ORDER BY `minOrder` ASC [ RunTime:0.007345s ]
select * from pdf where partno='SR4L034-L' and brandshort='Antenova' limit 1 [ RunTime:0.012045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258685 LIMIT 5 [ RunTime:0.053744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258685 ORDER BY `minOrder` ASC [ RunTime:0.010082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258685 ORDER BY `unit` DESC [ RunTime:0.011493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258685 LIMIT 2 [ RunTime:0.010850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258685 ORDER BY `minOrder` ASC [ RunTime:0.002983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254783 LIMIT 5 [ RunTime:0.010254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254783 ORDER BY `minOrder` ASC [ RunTime:0.019413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254783 ORDER BY `unit` DESC [ RunTime:0.037581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254783 LIMIT 2 [ RunTime:0.014710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254783 ORDER BY `minOrder` ASC [ RunTime:0.008095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11984204 LIMIT 5 [ RunTime:0.002271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984204 ORDER BY `minOrder` ASC [ RunTime:0.016357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11984204 ORDER BY `unit` DESC [ RunTime:0.014489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11984204 LIMIT 2 [ RunTime:0.014479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984204 ORDER BY `minOrder` ASC [ RunTime:0.005073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987079 LIMIT 5 [ RunTime:0.027158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987079 ORDER BY `minOrder` ASC [ RunTime:0.018836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987079 ORDER BY `unit` DESC [ RunTime:0.034925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987079 LIMIT 2 [ RunTime:0.028210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987079 ORDER BY `minOrder` ASC [ RunTime:0.019026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258117 LIMIT 5 [ RunTime:0.008092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258117 ORDER BY `minOrder` ASC [ RunTime:0.013481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258117 ORDER BY `unit` DESC [ RunTime:0.045591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258117 LIMIT 2 [ RunTime:0.040641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258117 ORDER BY `minOrder` ASC [ RunTime:0.007412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259341 LIMIT 5 [ RunTime:0.026009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259341 ORDER BY `minOrder` ASC [ RunTime:0.015444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13259341 ORDER BY `unit` DESC [ RunTime:0.025910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13259341 LIMIT 2 [ RunTime:0.033559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259341 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987423 LIMIT 5 [ RunTime:0.001565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987423 ORDER BY `minOrder` ASC [ RunTime:0.016049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987423 ORDER BY `unit` DESC [ RunTime:0.011428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987423 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987423 ORDER BY `minOrder` ASC [ RunTime:0.006900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258680 LIMIT 5 [ RunTime:0.009810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258680 ORDER BY `minOrder` ASC [ RunTime:0.021129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258680 ORDER BY `unit` DESC [ RunTime:0.010898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258680 LIMIT 2 [ RunTime:0.019154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258680 ORDER BY `minOrder` ASC [ RunTime:0.012037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985840 LIMIT 5 [ RunTime:0.021476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985840 ORDER BY `minOrder` ASC [ RunTime:0.015431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985840 ORDER BY `unit` DESC [ RunTime:0.033586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985840 LIMIT 2 [ RunTime:0.005571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985840 ORDER BY `minOrder` ASC [ RunTime:0.007133s ]
select * from pdf where partno='M20047-1' and brandshort='Antenova' limit 1 [ RunTime:0.011314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258118 LIMIT 5 [ RunTime:0.004181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258118 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258118 ORDER BY `unit` DESC [ RunTime:0.012867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258118 LIMIT 2 [ RunTime:0.015819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258118 ORDER BY `minOrder` ASC [ RunTime:0.009902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13254779 LIMIT 5 [ RunTime:0.013666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254779 ORDER BY `minOrder` ASC [ RunTime:0.015024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13254779 ORDER BY `unit` DESC [ RunTime:0.009529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13254779 LIMIT 2 [ RunTime:0.011071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13254779 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='A10192H' and brandshort='Antenova' limit 1 [ RunTime:0.003991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255705 LIMIT 5 [ RunTime:0.006807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255705 ORDER BY `minOrder` ASC [ RunTime:0.000799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13255705 ORDER BY `unit` DESC [ RunTime:0.003247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13255705 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255705 ORDER BY `minOrder` ASC [ RunTime:0.002363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255706 LIMIT 5 [ RunTime:0.003692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255706 ORDER BY `minOrder` ASC [ RunTime:0.017790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13255706 ORDER BY `unit` DESC [ RunTime:0.012734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13255706 LIMIT 2 [ RunTime:0.001006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255706 ORDER BY `minOrder` ASC [ RunTime:0.012614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985722 LIMIT 5 [ RunTime:0.006044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985722 ORDER BY `minOrder` ASC [ RunTime:0.002312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985722 ORDER BY `unit` DESC [ RunTime:0.005980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985722 LIMIT 2 [ RunTime:0.002861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985722 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987427 LIMIT 5 [ RunTime:0.004285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987427 ORDER BY `minOrder` ASC [ RunTime:0.011985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987427 ORDER BY `unit` DESC [ RunTime:0.004527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987427 LIMIT 2 [ RunTime:0.023492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987427 ORDER BY `minOrder` ASC [ RunTime:0.011881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258121 LIMIT 5 [ RunTime:0.004109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258121 ORDER BY `minOrder` ASC [ RunTime:0.004425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258121 ORDER BY `unit` DESC [ RunTime:0.007447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258121 LIMIT 2 [ RunTime:0.008225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258121 ORDER BY `minOrder` ASC [ RunTime:0.004248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255707 LIMIT 5 [ RunTime:0.011130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255707 ORDER BY `minOrder` ASC [ RunTime:0.016234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13255707 ORDER BY `unit` DESC [ RunTime:0.019486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13255707 LIMIT 2 [ RunTime:0.003058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255707 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='ANT160920ST-1204A1' and brandshort='TDK Corporation' limit 1 [ RunTime:0.014067s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304846 LIMIT 5 [ RunTime:0.004332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304846 ORDER BY `minOrder` ASC [ RunTime:0.005745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304846 ORDER BY `unit` DESC [ RunTime:0.007946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304846 LIMIT 2 [ RunTime:0.012407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304846 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='ant1005ll14r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.003292s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1005ll14r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.011634s ]
SELECT `id` FROM `stock` WHERE `id` <> 32304846 AND `partno` = 'ant1005ll14r2400a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.007270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987079 [ RunTime:0.019380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296624 LIMIT 5 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296624 ORDER BY `minOrder` ASC [ RunTime:0.006737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296624 ORDER BY `unit` DESC [ RunTime:0.007898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296624 LIMIT 2 [ RunTime:0.036484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296624 ORDER BY `minOrder` ASC [ RunTime:0.004812s ]
select * from pdf where partno='ant1005ll14r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.002863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1005ll14r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.000553s ]
SELECT `id` FROM `stock` WHERE `id` <> 32296624 AND `partno` = 'ant1005ll14r2400a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.001761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987079 [ RunTime:0.002408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114777 LIMIT 5 [ RunTime:0.002523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114777 ORDER BY `minOrder` ASC [ RunTime:0.008436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114777 ORDER BY `unit` DESC [ RunTime:0.011041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114777 LIMIT 2 [ RunTime:0.008937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114777 ORDER BY `minOrder` ASC [ RunTime:0.002181s ]
select * from pdf where partno='ant1005ll14r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1005ll14r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.003024s ]
SELECT `id` FROM `stock` WHERE `id` <> 51114777 AND `partno` = 'ant1005ll14r2400a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.002290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987079 [ RunTime:0.004068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304848 LIMIT 5 [ RunTime:0.010987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304848 ORDER BY `minOrder` ASC [ RunTime:0.015214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304848 ORDER BY `unit` DESC [ RunTime:0.011128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304848 LIMIT 2 [ RunTime:0.009589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304848 ORDER BY `minOrder` ASC [ RunTime:0.009659s ]
select * from pdf where partno='ant3216ll11r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.005431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant3216ll11r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.010190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296626 LIMIT 5 [ RunTime:0.015442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296626 ORDER BY `minOrder` ASC [ RunTime:0.013467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296626 ORDER BY `unit` DESC [ RunTime:0.007363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296626 LIMIT 2 [ RunTime:0.008587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296626 ORDER BY `minOrder` ASC [ RunTime:0.003424s ]
select * from pdf where partno='ant3216ll11r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant3216ll11r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.007685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114801 LIMIT 5 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114801 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114801 ORDER BY `unit` DESC [ RunTime:0.001449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114801 LIMIT 2 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114801 ORDER BY `minOrder` ASC [ RunTime:0.005730s ]
select * from pdf where partno='ant3216ll11r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.008412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant3216ll11r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.028813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304359 LIMIT 5 [ RunTime:0.015566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304359 ORDER BY `minOrder` ASC [ RunTime:0.015713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304359 ORDER BY `unit` DESC [ RunTime:0.009503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304359 LIMIT 2 [ RunTime:0.007899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304359 ORDER BY `minOrder` ASC [ RunTime:0.002920s ]
select * from pdf where partno='ant016008lcs2442ma2' and brandshort='tdk' limit 1 [ RunTime:0.010560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant016008lcs2442ma2' OR `brand` LIKE 'tdk%' ) ) LIMIT 1 [ RunTime:0.027004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296221 LIMIT 5 [ RunTime:0.018245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296221 ORDER BY `minOrder` ASC [ RunTime:0.002695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296221 ORDER BY `unit` DESC [ RunTime:0.007612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296221 LIMIT 2 [ RunTime:0.005570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296221 ORDER BY `minOrder` ASC [ RunTime:0.001522s ]
select * from pdf where partno='ant016008lcs2442ma2' and brandshort='tdk' limit 1 [ RunTime:0.008635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant016008lcs2442ma2' OR `brand` LIKE 'tdk%' ) ) LIMIT 1 [ RunTime:0.016345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114415 LIMIT 5 [ RunTime:0.016452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114415 ORDER BY `minOrder` ASC [ RunTime:0.015544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114415 ORDER BY `unit` DESC [ RunTime:0.013239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114415 LIMIT 2 [ RunTime:0.003544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114415 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
select * from pdf where partno='ant161575tt-3000a1' and brandshort='tdk' limit 1 [ RunTime:0.001250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant161575tt-3000a1' OR `brand` LIKE 'tdk%' ) ) LIMIT 1 [ RunTime:0.015272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304358 LIMIT 5 [ RunTime:0.004060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304358 ORDER BY `minOrder` ASC [ RunTime:0.003745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304358 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304358 LIMIT 2 [ RunTime:0.000868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304358 ORDER BY `minOrder` ASC [ RunTime:0.001455s ]
select * from pdf where partno='ant161575tt-3000a1' and brandshort='tdk' limit 1 [ RunTime:0.002467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant161575tt-3000a1' OR `brand` LIKE 'tdk%' ) ) LIMIT 1 [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296220 LIMIT 5 [ RunTime:0.004044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296220 ORDER BY `minOrder` ASC [ RunTime:0.009474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296220 ORDER BY `unit` DESC [ RunTime:0.005347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296220 LIMIT 2 [ RunTime:0.028239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296220 ORDER BY `minOrder` ASC [ RunTime:0.022796s ]
select * from pdf where partno='ant161575tt-3000a1' and brandshort='tdk' limit 1 [ RunTime:0.004179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant161575tt-3000a1' OR `brand` LIKE 'tdk%' ) ) LIMIT 1 [ RunTime:0.005330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114469 LIMIT 5 [ RunTime:0.017319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114469 ORDER BY `minOrder` ASC [ RunTime:0.011988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114469 ORDER BY `unit` DESC [ RunTime:0.005643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114469 LIMIT 2 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114469 ORDER BY `minOrder` ASC [ RunTime:0.015904s ]
select * from pdf where partno='ant-w63-msa-th1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.016338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant-w63-msa-th1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.024487s ]
SELECT `id` FROM `stock` WHERE `id` <> 51114469 AND `partno` = 'ant-w63-msa-th1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.011249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295972 [ RunTime:0.008418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304023 [ RunTime:0.002050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304023 LIMIT 5 [ RunTime:0.023986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304023 ORDER BY `minOrder` ASC [ RunTime:0.018863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304023 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304023 LIMIT 2 [ RunTime:0.006065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304023 ORDER BY `minOrder` ASC [ RunTime:0.010899s ]
select * from pdf where partno='ant-w63-msa-th1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.003948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant-w63-msa-th1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.003701s ]
SELECT `id` FROM `stock` WHERE `id` <> 32304023 AND `partno` = 'ant-w63-msa-th1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295972 [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114469 [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295972 LIMIT 5 [ RunTime:0.006018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295972 ORDER BY `minOrder` ASC [ RunTime:0.001352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32295972 ORDER BY `unit` DESC [ RunTime:0.003637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32295972 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295972 ORDER BY `minOrder` ASC [ RunTime:0.004943s ]
select * from pdf where partno='ant-w63-msa-th1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.001547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant-w63-msa-th1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.002223s ]
SELECT `id` FROM `stock` WHERE `id` <> 32295972 AND `partno` = 'ant-w63-msa-th1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.011961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304023 [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114469 [ RunTime:0.002866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114917 LIMIT 5 [ RunTime:0.004676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114917 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114917 ORDER BY `unit` DESC [ RunTime:0.002356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114917 LIMIT 2 [ RunTime:0.007297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114917 ORDER BY `minOrder` ASC [ RunTime:0.002141s ]
select * from pdf where partno='ant1608ll14r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.001685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1608ll14r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.006277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304901 LIMIT 5 [ RunTime:0.001178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304901 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304901 ORDER BY `unit` DESC [ RunTime:0.008529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304901 LIMIT 2 [ RunTime:0.000822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304901 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
select * from pdf where partno='ant1608ll14r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.000576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1608ll14r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296680 LIMIT 5 [ RunTime:0.003170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296680 ORDER BY `minOrder` ASC [ RunTime:0.002515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296680 ORDER BY `unit` DESC [ RunTime:0.010196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296680 LIMIT 2 [ RunTime:0.019526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296680 ORDER BY `minOrder` ASC [ RunTime:0.004891s ]
select * from pdf where partno='ant1608ll14r2400a' and brandshort='pulse electronics' limit 1 [ RunTime:0.000962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1608ll14r2400a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.003046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114278 LIMIT 5 [ RunTime:0.006470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114278 ORDER BY `minOrder` ASC [ RunTime:0.007526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114278 ORDER BY `unit` DESC [ RunTime:0.007861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114278 LIMIT 2 [ RunTime:0.002667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114278 ORDER BY `minOrder` ASC [ RunTime:0.005197s ]
select * from pdf where partno='ant1204f007r0870a' and brandshort='pulse electronics' limit 1 [ RunTime:0.008104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1204f007r0870a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.003473s ]
SELECT `id` FROM `stock` WHERE `id` <> 51114278 AND `partno` = 'ant1204f007r0870a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.017166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255714 [ RunTime:0.002645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304227 LIMIT 5 [ RunTime:0.005335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304227 ORDER BY `minOrder` ASC [ RunTime:0.016174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304227 ORDER BY `unit` DESC [ RunTime:0.001759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304227 LIMIT 2 [ RunTime:0.018360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304227 ORDER BY `minOrder` ASC [ RunTime:0.005429s ]
select * from pdf where partno='ant1204f007r0870a' and brandshort='pulse electronics' limit 1 [ RunTime:0.001156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1204f007r0870a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.000454s ]
SELECT `id` FROM `stock` WHERE `id` <> 32304227 AND `partno` = 'ant1204f007r0870a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.002104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255714 [ RunTime:0.002942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296099 LIMIT 5 [ RunTime:0.004098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296099 ORDER BY `minOrder` ASC [ RunTime:0.007144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296099 ORDER BY `unit` DESC [ RunTime:0.006442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296099 LIMIT 2 [ RunTime:0.006162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296099 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
select * from pdf where partno='ant1204f007r0870a' and brandshort='pulse electronics' limit 1 [ RunTime:0.019798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ant1204f007r0870a' OR `brand` LIKE 'pulse electronics%' ) ) LIMIT 1 [ RunTime:0.000313s ]
SELECT `id` FROM `stock` WHERE `id` <> 32296099 AND `partno` = 'ant1204f007r0870a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.006727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255714 [ RunTime:0.013192s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223902 LIMIT 5 [ RunTime:0.015344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223902 ORDER BY `minOrder` ASC [ RunTime:0.013711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223902 ORDER BY `unit` DESC [ RunTime:0.001500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223902 LIMIT 2 [ RunTime:0.006661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223902 ORDER BY `minOrder` ASC [ RunTime:0.018752s ]
select * from pdf where partno='ANT7020LL05R2400A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT7020LL05R2400A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.007404s ]
SELECT `id` FROM `stock` WHERE `id` <> 64223902 AND `partno` = 'ANT7020LL05R2400A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.010894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985200 [ RunTime:0.005674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225512 LIMIT 5 [ RunTime:0.010244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225512 ORDER BY `minOrder` ASC [ RunTime:0.013182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225512 ORDER BY `unit` DESC [ RunTime:0.002529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225512 LIMIT 2 [ RunTime:0.003378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225512 ORDER BY `minOrder` ASC [ RunTime:0.003477s ]
select * from pdf where partno='A5645H' and brandshort='Antenova' limit 1 [ RunTime:0.001548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A5645H' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.010555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223058 LIMIT 5 [ RunTime:0.011153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223058 ORDER BY `minOrder` ASC [ RunTime:0.006139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223058 ORDER BY `unit` DESC [ RunTime:0.004169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223058 LIMIT 2 [ RunTime:0.002665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223058 ORDER BY `minOrder` ASC [ RunTime:0.003484s ]
select * from pdf where partno='ANT3216A063R2400A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.015036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT3216A063R2400A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.005955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223059 LIMIT 5 [ RunTime:0.013802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223059 ORDER BY `minOrder` ASC [ RunTime:0.009172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223059 ORDER BY `unit` DESC [ RunTime:0.023400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223059 LIMIT 2 [ RunTime:0.010175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223059 ORDER BY `minOrder` ASC [ RunTime:0.010227s ]
select * from pdf where partno='ANT2012LL13R2400A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.012594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT2012LL13R2400A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.016261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222605 LIMIT 5 [ RunTime:0.030993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222605 ORDER BY `minOrder` ASC [ RunTime:0.026874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222605 ORDER BY `unit` DESC [ RunTime:0.005599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222605 LIMIT 2 [ RunTime:0.004455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222605 ORDER BY `minOrder` ASC [ RunTime:0.006651s ]
select * from pdf where partno='ANT162442DT-2001A2' and brandshort='TDK' limit 1 [ RunTime:0.001559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT162442DT-2001A2' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.010164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222624 LIMIT 5 [ RunTime:0.016857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222624 ORDER BY `minOrder` ASC [ RunTime:0.004331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222624 ORDER BY `unit` DESC [ RunTime:0.001506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222624 LIMIT 2 [ RunTime:0.006631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222624 ORDER BY `minOrder` ASC [ RunTime:0.009230s ]
select * from pdf where partno='SRCW004' and brandshort='Antenova' limit 1 [ RunTime:0.005764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SRCW004' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.017925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222695 LIMIT 5 [ RunTime:0.023293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222695 ORDER BY `minOrder` ASC [ RunTime:0.006608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222695 ORDER BY `unit` DESC [ RunTime:0.011941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222695 LIMIT 2 [ RunTime:0.002174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222695 ORDER BY `minOrder` ASC [ RunTime:0.003117s ]
select * from pdf where partno='ANT-868-CHP-T' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.008793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT-868-CHP-T' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.006534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222620 LIMIT 5 [ RunTime:0.014323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222620 ORDER BY `minOrder` ASC [ RunTime:0.001952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222620 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222620 LIMIT 2 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222620 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='SR4W035' and brandshort='Antenova' limit 1 [ RunTime:0.001622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4W035' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.000886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223063 LIMIT 5 [ RunTime:0.001256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223063 ORDER BY `minOrder` ASC [ RunTime:0.007336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223063 ORDER BY `unit` DESC [ RunTime:0.002079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223063 LIMIT 2 [ RunTime:0.004916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223063 ORDER BY `minOrder` ASC [ RunTime:0.001928s ]
select * from pdf where partno='ANT8010LL04R2400A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.007198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT8010LL04R2400A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.007010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222649 LIMIT 5 [ RunTime:0.005542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222649 ORDER BY `minOrder` ASC [ RunTime:0.005658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222649 ORDER BY `unit` DESC [ RunTime:0.000636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222649 LIMIT 2 [ RunTime:0.001136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222649 ORDER BY `minOrder` ASC [ RunTime:0.001211s ]
select * from pdf where partno='SR42W001' and brandshort='Antenova' limit 1 [ RunTime:0.001685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR42W001' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.001831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222700 LIMIT 5 [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222700 ORDER BY `minOrder` ASC [ RunTime:0.005443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222700 ORDER BY `unit` DESC [ RunTime:0.002274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222700 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222700 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='SR4L002' and brandshort='Antenova' limit 1 [ RunTime:0.001284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L002' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222690 LIMIT 5 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222690 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222690 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222690 LIMIT 2 [ RunTime:0.001826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222690 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
select * from pdf where partno='SR4L034-L' and brandshort='Antenova' limit 1 [ RunTime:0.000316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L034-L' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.001155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222652 LIMIT 5 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222652 ORDER BY `minOrder` ASC [ RunTime:0.005371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222652 ORDER BY `unit` DESC [ RunTime:0.001724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222652 LIMIT 2 [ RunTime:0.009104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222652 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='ANTX200P001B24003' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANTX200P001B24003' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001070s ]
SELECT `id` FROM `stock` WHERE `id` <> 64222652 AND `partno` = 'ANTX200P001B24003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11984186 [ RunTime:0.001443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223875 LIMIT 5 [ RunTime:0.006420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223875 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223875 ORDER BY `unit` DESC [ RunTime:0.001709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223875 LIMIT 2 [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223875 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='ANT1608LL14R2455A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.007321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT1608LL14R2455A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001655s ]
SELECT `id` FROM `stock` WHERE `id` <> 64223875 AND `partno` = 'ANT1608LL14R2455A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255705 [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223060 LIMIT 5 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223060 ORDER BY `minOrder` ASC [ RunTime:0.006000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223060 ORDER BY `unit` DESC [ RunTime:0.002629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223060 LIMIT 2 [ RunTime:0.003739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223060 ORDER BY `minOrder` ASC [ RunTime:0.002278s ]
select * from pdf where partno='ANT1608LL14R2400A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.000876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT1608LL14R2400A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223877 LIMIT 5 [ RunTime:0.006929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223877 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223877 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223877 LIMIT 2 [ RunTime:0.002546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223877 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='ANT1608LL14R2460A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.003465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT1608LL14R2460A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 64223877 AND `partno` = 'ANT1608LL14R2460A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255706 [ RunTime:0.001749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223905 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223905 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223905 ORDER BY `unit` DESC [ RunTime:0.010646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223905 LIMIT 2 [ RunTime:0.003141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223905 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
select * from pdf where partno='ANT5320LL04R2455A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.006796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT5320LL04R2455A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001004s ]
SELECT `id` FROM `stock` WHERE `id` <> 64223905 AND `partno` = 'ANT5320LL04R2455A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.000879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985722 [ RunTime:0.000772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223996 LIMIT 5 [ RunTime:0.001691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223996 ORDER BY `minOrder` ASC [ RunTime:0.007590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223996 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223996 LIMIT 2 [ RunTime:0.003993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223996 ORDER BY `minOrder` ASC [ RunTime:0.001770s ]
select * from pdf where partno='ANT-GNL1-NSP' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.006037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT-GNL1-NSP' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.004548s ]
SELECT `id` FROM `stock` WHERE `id` <> 64223996 AND `partno` = 'ANT-GNL1-NSP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.001218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222716 LIMIT 5 [ RunTime:0.002240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222716 ORDER BY `minOrder` ASC [ RunTime:0.009708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222716 ORDER BY `unit` DESC [ RunTime:0.006765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222716 LIMIT 2 [ RunTime:0.004126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222716 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
select * from pdf where partno='SR4L073' and brandshort='Antenova' limit 1 [ RunTime:0.006894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SR4L073' OR `brand` LIKE 'Antenova%' ) ) LIMIT 1 [ RunTime:0.007746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223055 LIMIT 5 [ RunTime:0.005780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223055 ORDER BY `minOrder` ASC [ RunTime:0.010488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223055 ORDER BY `unit` DESC [ RunTime:0.008039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223055 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223055 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='ANT1005LL14R2400A' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.003846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ANT1005LL14R2400A' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001176s ]
SELECT `id` FROM `stock` WHERE `id` <> 64223055 AND `partno` = 'ANT1005LL14R2400A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.000974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987079 [ RunTime:0.000450s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009209s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004557s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004795s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011492s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015333s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001821s ]
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 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019359s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ANT%' OR `brand` LIKE 'ANT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013498s ]