SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001148s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=m131&search=1' [ RunTime:0.004023s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001173s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001708s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002036s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.000414s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001087s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001075s ]
SELECT * FROM `stock_search` WHERE `partno` = 'm131' LIMIT 1 [ RunTime:0.000631s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-10-09 15:32:35' WHERE `partno` = 'm131' [ RunTime:0.002651s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001177s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026302s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505894 LIMIT 5 [ RunTime:0.000770s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505894 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505894 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505894 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505894 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='M13112 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389153 LIMIT 5 [ RunTime:0.002875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389153 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389153 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389153 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389153 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='M13142 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315613 LIMIT 5 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315613 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315613 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315613 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315613 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315000 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315000 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315000 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315000 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315000 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='M1316-3005-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386183 LIMIT 5 [ RunTime:0.000828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386183 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14386183 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14386183 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14386183 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='M13179 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316288 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316288 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316288 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316288 LIMIT 2 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316288 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041291 LIMIT 5 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041291 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041291 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041291 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041291 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13497623 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13497623 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13497623 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13497623 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13497623 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='M13197 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041029 LIMIT 5 [ RunTime:0.001346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041029 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041029 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041029 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041029 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='M1316-4007-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041455 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041455 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041455 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041455 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041455 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316263 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316263 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316263 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316263 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316263 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='M1313-3005-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13495341 LIMIT 5 [ RunTime:0.003299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495341 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13495341 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13495341 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13495341 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='M13149 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315142 LIMIT 5 [ RunTime:0.002684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315142 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315142 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315142 LIMIT 2 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315142 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='M1313-3005-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040278 LIMIT 5 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12040278 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12040278 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12040278 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12040278 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='M1311-3005-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042192 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042192 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042192 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042192 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042192 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='M1313-3005-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041250 LIMIT 5 [ RunTime:0.001513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041250 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041250 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041250 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041250 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='M1313-4007-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315173 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315173 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315173 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315173 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315173 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='M1316-4007-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041199 LIMIT 5 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041199 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041199 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041199 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041199 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315934 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315934 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315934 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315934 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315934 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='M1313-3005-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315151 LIMIT 5 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315151 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315151 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315151 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315151 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='M1317-3005-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000481s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704634 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704634 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704634 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704634 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704634 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='m13142 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm13142 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.001373s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704634 AND `partno` = 'm13142 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389153 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704679 LIMIT 5 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704679 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704679 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704679 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704679 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
select * from pdf where partno='m13195 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.000628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm13195 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000560s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704679 AND `partno` = 'm13195 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512409 [ RunTime:0.000956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704563 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704563 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704563 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704563 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704563 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='m13197 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.000673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm13197 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000524s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704563 AND `partno` = 'm13197 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514045 [ RunTime:0.002096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704583 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704583 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704583 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704583 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704583 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='m13103 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm13103 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000497s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704583 AND `partno` = 'm13103 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387525 [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71840748 LIMIT 5 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71840748 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71840748 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71840748 LIMIT 2 [ RunTime:0.001132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71840748 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
select * from pdf where partno='m131' and brandshort='m5stack' limit 1 [ RunTime:0.000926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm131' OR `brand` LIKE 'm5stack%' ) ) LIMIT 1 [ RunTime:0.003529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704671 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704671 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704671 ORDER BY `unit` DESC [ RunTime:0.000718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704671 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704671 ORDER BY `minOrder` ASC [ RunTime:0.000798s ]
select * from pdf where partno='m13194 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm13194 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000887s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704671 AND `partno` = 'm13194 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514444 [ RunTime:0.001093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71704670 LIMIT 5 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704670 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71704670 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71704670 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71704670 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='m13143 sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.000686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'm13143 sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000588s ]
SELECT `id` FROM `stock` WHERE `id` <> 71704670 AND `partno` = 'm13143 sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389479 [ RunTime:0.003216s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69799340 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69799340 ORDER BY `minOrder` ASC [ RunTime:0.005595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69799340 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69799340 LIMIT 2 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69799340 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='M13142 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M13142 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000575s ]
SELECT `id` FROM `stock` WHERE `id` <> 69799340 AND `partno` = 'M13142 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389153 [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69804801 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69804801 ORDER BY `minOrder` ASC [ RunTime:0.002319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69804801 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69804801 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69804801 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='M13112 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M13112 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000469s ]
SELECT `id` FROM `stock` WHERE `id` <> 69804801 AND `partno` = 'M13112 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505894 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69804082 LIMIT 5 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69804082 ORDER BY `minOrder` ASC [ RunTime:0.011584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69804082 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69804082 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69804082 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='M13143 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M13143 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000461s ]
SELECT `id` FROM `stock` WHERE `id` <> 69804082 AND `partno` = 'M13143 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14374686 [ RunTime:0.006866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69799879 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69799879 ORDER BY `minOrder` ASC [ RunTime:0.002125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69799879 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69799879 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69799879 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='M13143 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M13143 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000492s ]
SELECT `id` FROM `stock` WHERE `id` <> 69799879 AND `partno` = 'M13143 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389479 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175726 LIMIT 5 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175726 ORDER BY `minOrder` ASC [ RunTime:0.017182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175726 ORDER BY `unit` DESC [ RunTime:0.000545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175726 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175726 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='M1312-4007-B-5' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1312-4007-B-5' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000491s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175726 AND `partno` = 'M1312-4007-B-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315613 [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175735 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175735 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175735 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175735 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175735 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='M1311-3005-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.005518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1311-3005-SS-20' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.001147s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175735 AND `partno` = 'M1311-3005-SS-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.001145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316288 [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70174813 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70174813 ORDER BY `minOrder` ASC [ RunTime:0.015716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70174813 ORDER BY `unit` DESC [ RunTime:0.000926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70174813 LIMIT 2 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70174813 ORDER BY `minOrder` ASC [ RunTime:0.000890s ]
select * from pdf where partno='M1316-3005-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1316-3005-B-12' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000805s ]
SELECT `id` FROM `stock` WHERE `id` <> 70174813 AND `partno` = 'M1316-3005-B-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315000 [ RunTime:0.000632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69801829 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69801829 ORDER BY `minOrder` ASC [ RunTime:0.001257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69801829 ORDER BY `unit` DESC [ RunTime:0.000739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69801829 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69801829 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
select * from pdf where partno='M13197 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M13197 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000800s ]
SELECT `id` FROM `stock` WHERE `id` <> 69801829 AND `partno` = 'M13197 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13497623 [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175233 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175233 ORDER BY `minOrder` ASC [ RunTime:0.003719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175233 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175233 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175233 ORDER BY `minOrder` ASC [ RunTime:0.000824s ]
select * from pdf where partno='M1317-4007-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.003717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1317-4007-N' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000831s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175233 AND `partno` = 'M1317-4007-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041291 [ RunTime:0.000765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70176192 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176192 ORDER BY `minOrder` ASC [ RunTime:0.006599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70176192 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70176192 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176192 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
select * from pdf where partno='M1311-4007-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1311-4007-N' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000839s ]
SELECT `id` FROM `stock` WHERE `id` <> 70176192 AND `partno` = 'M1311-4007-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69802138 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69802138 ORDER BY `minOrder` ASC [ RunTime:0.006790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69802138 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69802138 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69802138 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
select * from pdf where partno='M13179 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M13179 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000777s ]
SELECT `id` FROM `stock` WHERE `id` <> 69802138 AND `partno` = 'M13179 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14386183 [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175821 LIMIT 5 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175821 ORDER BY `minOrder` ASC [ RunTime:0.011185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175821 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175821 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175821 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
select * from pdf where partno='M1311-3005-S-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1311-3005-S-12' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000798s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175821 AND `partno` = 'M1311-3005-S-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041455 [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70176075 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176075 ORDER BY `minOrder` ASC [ RunTime:0.004439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70176075 ORDER BY `unit` DESC [ RunTime:0.000796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70176075 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176075 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
select * from pdf where partno='M1314-3005-SS-20' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1314-3005-SS-20' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000715s ]
SELECT `id` FROM `stock` WHERE `id` <> 70176075 AND `partno` = 'M1314-3005-SS-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175651 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175651 ORDER BY `minOrder` ASC [ RunTime:0.008240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175651 ORDER BY `unit` DESC [ RunTime:0.000792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175651 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175651 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
select * from pdf where partno='M1313-3005-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1313-3005-B-12' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000832s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175651 AND `partno` = 'M1313-3005-B-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316263 [ RunTime:0.000698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70174676 LIMIT 5 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70174676 ORDER BY `minOrder` ASC [ RunTime:0.003447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70174676 ORDER BY `unit` DESC [ RunTime:0.000821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70174676 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70174676 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
select * from pdf where partno='M1313-3005-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1313-3005-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000902s ]
SELECT `id` FROM `stock` WHERE `id` <> 70174676 AND `partno` = 'M1313-3005-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.001086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042192 [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70176076 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176076 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70176076 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70176076 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176076 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='M1313-4007-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1313-4007-B-12' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000522s ]
SELECT `id` FROM `stock` WHERE `id` <> 70176076 AND `partno` = 'M1313-4007-B-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041250 [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70172688 LIMIT 5 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70172688 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70172688 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70172688 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70172688 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='M1315-3005-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1315-3005-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000514s ]
SELECT `id` FROM `stock` WHERE `id` <> 70172688 AND `partno` = 'M1315-3005-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040717 [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70175533 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175533 ORDER BY `minOrder` ASC [ RunTime:0.001912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70175533 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70175533 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70175533 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='M1311-3005-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1311-3005-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000610s ]
SELECT `id` FROM `stock` WHERE `id` <> 70175533 AND `partno` = 'M1311-3005-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040278 [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70176096 LIMIT 5 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176096 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70176096 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70176096 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176096 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='M1316-4007-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1316-4007-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000464s ]
SELECT `id` FROM `stock` WHERE `id` <> 70176096 AND `partno` = 'M1316-4007-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315173 [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70174928 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70174928 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70174928 ORDER BY `unit` DESC [ RunTime:0.000475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70174928 LIMIT 2 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70174928 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='M1316-3005-B' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M1316-3005-B' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000521s ]
SELECT `id` FROM `stock` WHERE `id` <> 70174928 AND `partno` = 'M1316-3005-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041199 [ RunTime:0.000374s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000812s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000603s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000752s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000729s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000731s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000663s ]
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 'm131%' OR `brand` LIKE 'm131%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000921s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'm131%' OR `brand` LIKE 'm131%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002401s ]