SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002371s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=4011&search=1' [ RunTime:0.001970s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001313s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001335s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002020s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.001206s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001398s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001819s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002114s ]
SELECT * FROM `stock_search` WHERE `partno` = '4011' LIMIT 1 [ RunTime:0.002820s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-15 22:25:51' WHERE `partno` = '4011' [ RunTime:0.003579s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001410s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012366s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19190229 LIMIT 5 [ RunTime:0.007736s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19190229 ORDER BY `minOrder` ASC [ RunTime:0.004571s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19190229 ORDER BY `unit` DESC [ RunTime:0.008177s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19190229 LIMIT 2 [ RunTime:0.008766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19190229 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16097579 LIMIT 5 [ RunTime:0.007700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16097579 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16097579 ORDER BY `unit` DESC [ RunTime:0.008722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16097579 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16097579 ORDER BY `minOrder` ASC [ RunTime:0.005078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443341 LIMIT 5 [ RunTime:0.010154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443341 ORDER BY `minOrder` ASC [ RunTime:0.006038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443341 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443341 LIMIT 2 [ RunTime:0.001614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443341 ORDER BY `minOrder` ASC [ RunTime:0.008448s ]
select * from pdf where partno='4011-0-15-80-30-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.023468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19598067 LIMIT 5 [ RunTime:0.029936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19598067 ORDER BY `minOrder` ASC [ RunTime:0.005720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19598067 ORDER BY `unit` DESC [ RunTime:0.004947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19598067 LIMIT 2 [ RunTime:0.009742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19598067 ORDER BY `minOrder` ASC [ RunTime:0.003740s ]
select * from pdf where partno='4011-0-15-01-30-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19598194 LIMIT 5 [ RunTime:0.008301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19598194 ORDER BY `minOrder` ASC [ RunTime:0.015785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19598194 ORDER BY `unit` DESC [ RunTime:0.023614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19598194 LIMIT 2 [ RunTime:0.011207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19598194 ORDER BY `minOrder` ASC [ RunTime:0.005775s ]
select * from pdf where partno='4011-0-15-15-30-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.025440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157725 LIMIT 5 [ RunTime:0.012936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157725 ORDER BY `minOrder` ASC [ RunTime:0.012527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12157725 ORDER BY `unit` DESC [ RunTime:0.010293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12157725 LIMIT 2 [ RunTime:0.013926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157725 ORDER BY `minOrder` ASC [ RunTime:0.013241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384748 LIMIT 5 [ RunTime:0.014592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384748 ORDER BY `minOrder` ASC [ RunTime:0.025617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14384748 ORDER BY `unit` DESC [ RunTime:0.007299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14384748 LIMIT 2 [ RunTime:0.026205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384748 ORDER BY `minOrder` ASC [ RunTime:0.006406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682398 LIMIT 5 [ RunTime:0.006466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682398 ORDER BY `minOrder` ASC [ RunTime:0.001645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682398 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682398 LIMIT 2 [ RunTime:0.003288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682398 ORDER BY `minOrder` ASC [ RunTime:0.009169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042658 LIMIT 5 [ RunTime:0.009328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042658 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042658 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042658 LIMIT 2 [ RunTime:0.002253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042658 ORDER BY `minOrder` ASC [ RunTime:0.002795s ]
select * from pdf where partno='4011-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.002879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12385801 LIMIT 5 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12385801 ORDER BY `minOrder` ASC [ RunTime:0.002774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12385801 ORDER BY `unit` DESC [ RunTime:0.005119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12385801 LIMIT 2 [ RunTime:0.015786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12385801 ORDER BY `minOrder` ASC [ RunTime:0.012860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14984558 LIMIT 5 [ RunTime:0.004873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14984558 ORDER BY `minOrder` ASC [ RunTime:0.001703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14984558 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14984558 LIMIT 2 [ RunTime:0.004290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14984558 ORDER BY `minOrder` ASC [ RunTime:0.014542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147857 LIMIT 5 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12147857 ORDER BY `minOrder` ASC [ RunTime:0.007202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12147857 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12147857 LIMIT 2 [ RunTime:0.010688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12147857 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148744 LIMIT 5 [ RunTime:0.009218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148744 ORDER BY `minOrder` ASC [ RunTime:0.011464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12148744 ORDER BY `unit` DESC [ RunTime:0.005637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12148744 LIMIT 2 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148744 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148701 LIMIT 5 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148701 ORDER BY `minOrder` ASC [ RunTime:0.012517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12148701 ORDER BY `unit` DESC [ RunTime:0.001460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12148701 LIMIT 2 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148701 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148739 LIMIT 5 [ RunTime:0.003629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148739 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12148739 ORDER BY `unit` DESC [ RunTime:0.000581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12148739 LIMIT 2 [ RunTime:0.009483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12148739 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11171470 LIMIT 5 [ RunTime:0.008500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11171470 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11171470 ORDER BY `unit` DESC [ RunTime:0.012501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11171470 LIMIT 2 [ RunTime:0.005655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11171470 ORDER BY `minOrder` ASC [ RunTime:0.015207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595838 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595838 ORDER BY `minOrder` ASC [ RunTime:0.010889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19595838 ORDER BY `unit` DESC [ RunTime:0.019028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19595838 LIMIT 2 [ RunTime:0.008412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19595838 ORDER BY `minOrder` ASC [ RunTime:0.003649s ]
select * from pdf where partno='4011-0-15-15-30-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.013503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594966 LIMIT 5 [ RunTime:0.004120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594966 ORDER BY `minOrder` ASC [ RunTime:0.009964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594966 ORDER BY `unit` DESC [ RunTime:0.028392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594966 LIMIT 2 [ RunTime:0.018390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594966 ORDER BY `minOrder` ASC [ RunTime:0.003062s ]
select * from pdf where partno='4011-0-15-01-30-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594527 LIMIT 5 [ RunTime:0.003997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594527 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594527 ORDER BY `unit` DESC [ RunTime:0.002414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594527 LIMIT 2 [ RunTime:0.005354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594527 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='4011-0-15-80-30-84-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594526 LIMIT 5 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594526 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594526 ORDER BY `unit` DESC [ RunTime:0.002352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594526 LIMIT 2 [ RunTime:0.006963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594526 ORDER BY `minOrder` ASC [ RunTime:0.001927s ]
select * from pdf where partno='4011-0-15-01-30-02-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012505s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287714 LIMIT 5 [ RunTime:0.015386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287714 ORDER BY `minOrder` ASC [ RunTime:0.011885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287714 ORDER BY `unit` DESC [ RunTime:0.000908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287714 LIMIT 2 [ RunTime:0.003355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287714 ORDER BY `minOrder` ASC [ RunTime:0.004243s ]
select * from pdf where partno='40115005' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001273s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40115005' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.001151s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287714 AND `partno` = '40115005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.010572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148739 [ RunTime:0.008878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287916 LIMIT 5 [ RunTime:0.003367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287916 ORDER BY `minOrder` ASC [ RunTime:0.009796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287916 ORDER BY `unit` DESC [ RunTime:0.005597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287916 LIMIT 2 [ RunTime:0.006163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287916 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
select * from pdf where partno='40111010' and brandshort='wurth elektronik' limit 1 [ RunTime:0.002257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40111010' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.007149s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287916 AND `partno` = '40111010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148719 [ RunTime:0.002007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287915 LIMIT 5 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287915 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287915 ORDER BY `unit` DESC [ RunTime:0.003452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287915 LIMIT 2 [ RunTime:0.003284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287915 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
select * from pdf where partno='40111005' and brandshort='wurth elektronik' limit 1 [ RunTime:0.003963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40111005' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.012814s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287915 AND `partno` = '40111005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.001496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148697 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095511 LIMIT 5 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095511 ORDER BY `minOrder` ASC [ RunTime:0.003247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095511 ORDER BY `unit` DESC [ RunTime:0.000468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095511 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095511 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='4011' and brandshort='adafruit' limit 1 [ RunTime:0.001183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287922 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287922 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287922 ORDER BY `unit` DESC [ RunTime:0.002067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287922 LIMIT 2 [ RunTime:0.007355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287922 ORDER BY `minOrder` ASC [ RunTime:0.003671s ]
select * from pdf where partno='40114010' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40114010' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000611s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287922 AND `partno` = '40114010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.004644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148744 [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287923 LIMIT 5 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287923 ORDER BY `minOrder` ASC [ RunTime:0.001860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287923 ORDER BY `unit` DESC [ RunTime:0.001817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287923 LIMIT 2 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287923 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='40115010' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40115010' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000508s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287923 AND `partno` = '40115010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.004400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11171483 [ RunTime:0.009043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32288247 LIMIT 5 [ RunTime:0.002503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288247 ORDER BY `minOrder` ASC [ RunTime:0.011228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32288247 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32288247 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288247 ORDER BY `minOrder` ASC [ RunTime:0.001423s ]
select * from pdf where partno='40113005' and brandshort='wurth elektronik' limit 1 [ RunTime:0.003357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40113005' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.004253s ]
SELECT `id` FROM `stock` WHERE `id` <> 32288247 AND `partno` = '40113005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503272 [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287917 LIMIT 5 [ RunTime:0.002679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287917 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287917 ORDER BY `unit` DESC [ RunTime:0.001697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287917 LIMIT 2 [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287917 ORDER BY `minOrder` ASC [ RunTime:0.006188s ]
select * from pdf where partno='40111020' and brandshort='wurth elektronik' limit 1 [ RunTime:0.008177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40111020' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.013851s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287917 AND `partno` = '40111020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11171470 [ RunTime:0.008174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287918 LIMIT 5 [ RunTime:0.007431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287918 ORDER BY `minOrder` ASC [ RunTime:0.022640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287918 ORDER BY `unit` DESC [ RunTime:0.002265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287918 LIMIT 2 [ RunTime:0.005194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287918 ORDER BY `minOrder` ASC [ RunTime:0.011979s ]
select * from pdf where partno='40112005' and brandshort='wurth elektronik' limit 1 [ RunTime:0.003309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40112005' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.004450s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287918 AND `partno` = '40112005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.023680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148701 [ RunTime:0.005223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287921 LIMIT 5 [ RunTime:0.001650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287921 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287921 ORDER BY `unit` DESC [ RunTime:0.010627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287921 LIMIT 2 [ RunTime:0.009188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287921 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
select * from pdf where partno='40114005' and brandshort='wurth elektronik' limit 1 [ RunTime:0.003774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40114005' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.001092s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287921 AND `partno` = '40114005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.000983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147857 [ RunTime:0.003588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287919 LIMIT 5 [ RunTime:0.001008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287919 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287919 ORDER BY `unit` DESC [ RunTime:0.000775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287919 LIMIT 2 [ RunTime:0.003369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287919 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
select * from pdf where partno='40112010' and brandshort='wurth elektronik' limit 1 [ RunTime:0.004988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40112010' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.004755s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287919 AND `partno` = '40112010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.006643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148726 [ RunTime:0.002265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287920 LIMIT 5 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287920 ORDER BY `minOrder` ASC [ RunTime:0.002426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287920 ORDER BY `unit` DESC [ RunTime:0.002019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287920 LIMIT 2 [ RunTime:0.001585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287920 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='40113010' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40113010' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.002473s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287920 AND `partno` = '40113010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.004153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503298 [ RunTime:0.000801s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313968 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313968 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313968 ORDER BY `unit` DESC [ RunTime:0.001639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313968 LIMIT 2 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313968 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='4011-0-15-15-30-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-0-15-15-30-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000694s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313968 AND `partno` = '4011-0-15-15-30-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19598194 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63792294 LIMIT 5 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63792294 ORDER BY `minOrder` ASC [ RunTime:0.001001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63792294 ORDER BY `unit` DESC [ RunTime:0.000388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63792294 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63792294 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='4011BDM' and brandshort='National Semiconductor' limit 1 [ RunTime:0.000627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011BDM' OR `brand` LIKE 'National Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001314s ]
SELECT `id` FROM `stock` WHERE `id` <> 63792294 AND `partno` = '4011BDM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%national semiconductor%' ) [ RunTime:0.001907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16097579 [ RunTime:0.001879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60314182 LIMIT 5 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314182 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60314182 ORDER BY `unit` DESC [ RunTime:0.010674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60314182 LIMIT 2 [ RunTime:0.003972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314182 ORDER BY `minOrder` ASC [ RunTime:0.006152s ]
select * from pdf where partno='4011-0-15-80-30-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-0-15-80-30-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.004174s ]
SELECT `id` FROM `stock` WHERE `id` <> 60314182 AND `partno` = '4011-0-15-80-30-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.001852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443341 [ RunTime:0.004150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63393559 LIMIT 5 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393559 ORDER BY `minOrder` ASC [ RunTime:0.001353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63393559 ORDER BY `unit` DESC [ RunTime:0.003276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63393559 LIMIT 2 [ RunTime:0.006771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393559 ORDER BY `minOrder` ASC [ RunTime:0.002029s ]
select * from pdf where partno='4011-440-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.001749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-440-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.019104s ]
SELECT `id` FROM `stock` WHERE `id` <> 63393559 AND `partno` = '4011-440-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.009180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60314185 LIMIT 5 [ RunTime:0.008257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314185 ORDER BY `minOrder` ASC [ RunTime:0.007344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60314185 ORDER BY `unit` DESC [ RunTime:0.003708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60314185 LIMIT 2 [ RunTime:0.009503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314185 ORDER BY `minOrder` ASC [ RunTime:0.002731s ]
select * from pdf where partno='4011-0-15-01-30-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-0-15-01-30-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.004643s ]
SELECT `id` FROM `stock` WHERE `id` <> 60314185 AND `partno` = '4011-0-15-01-30-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.012489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19598067 [ RunTime:0.007862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63393943 LIMIT 5 [ RunTime:0.006116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393943 ORDER BY `minOrder` ASC [ RunTime:0.008071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63393943 ORDER BY `unit` DESC [ RunTime:0.000804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63393943 LIMIT 2 [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393943 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
select * from pdf where partno='4011-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.003073s ]
SELECT `id` FROM `stock` WHERE `id` <> 63393943 AND `partno` = '4011-440-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.017101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042658 [ RunTime:0.017943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386805 LIMIT 5 [ RunTime:0.013579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386805 ORDER BY `minOrder` ASC [ RunTime:0.028776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386805 ORDER BY `unit` DESC [ RunTime:0.021979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386805 LIMIT 2 [ RunTime:0.014652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386805 ORDER BY `minOrder` ASC [ RunTime:0.009393s ]
select * from pdf where partno='4011200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022467s ]
select foldpath,foldpath2,filename from pdf_file where id=1219012 limit 1 [ RunTime:0.025623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006610s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386805 AND `partno` = '4011200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.028749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64519380 LIMIT 5 [ RunTime:0.014832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64519380 ORDER BY `minOrder` ASC [ RunTime:0.027100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64519380 ORDER BY `unit` DESC [ RunTime:0.023181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64519380 LIMIT 2 [ RunTime:0.037945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64519380 ORDER BY `minOrder` ASC [ RunTime:0.066337s ]
select * from pdf where partno='4011-B' and brandshort='Brady Corporation' limit 1 [ RunTime:0.033673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-B' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.051227s ]
SELECT `id` FROM `stock` WHERE `id` <> 64519380 AND `partno` = '4011-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459612 [ RunTime:0.020432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63494143 LIMIT 5 [ RunTime:0.046684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63494143 ORDER BY `minOrder` ASC [ RunTime:0.022437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63494143 ORDER BY `unit` DESC [ RunTime:0.044780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63494143 LIMIT 2 [ RunTime:0.048179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63494143 ORDER BY `minOrder` ASC [ RunTime:0.122013s ]
select * from pdf where partno='4011007' and brandshort='Simco-Ion' limit 1 [ RunTime:0.037422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011007' OR `brand` LIKE 'Simco-Ion%' ) ) LIMIT 1 [ RunTime:0.040529s ]
SELECT `id` FROM `stock` WHERE `id` <> 63494143 AND `partno` = '4011007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%simco-ion%' ) [ RunTime:0.038041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914259 LIMIT 5 [ RunTime:0.044921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914259 ORDER BY `minOrder` ASC [ RunTime:0.064374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914259 ORDER BY `unit` DESC [ RunTime:0.047580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914259 LIMIT 2 [ RunTime:0.090637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914259 ORDER BY `minOrder` ASC [ RunTime:0.062719s ]
select * from pdf where partno='4011-00044' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.046428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-00044' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.004778s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914259 AND `partno` = '4011-00044' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.015948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682398 [ RunTime:0.033060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63521399 LIMIT 5 [ RunTime:0.021225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63521399 ORDER BY `minOrder` ASC [ RunTime:0.049201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63521399 ORDER BY `unit` DESC [ RunTime:0.065943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63521399 LIMIT 2 [ RunTime:0.024900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63521399 ORDER BY `minOrder` ASC [ RunTime:0.006780s ]
select * from pdf where partno='4011A' and brandshort='B&K Precision' limit 1 [ RunTime:0.014264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011A' OR `brand` LIKE 'B&K Precision%' ) ) LIMIT 1 [ RunTime:0.035426s ]
SELECT `id` FROM `stock` WHERE `id` <> 63521399 AND `partno` = '4011A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.048840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14984558 [ RunTime:0.053909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63494150 LIMIT 5 [ RunTime:0.017606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63494150 ORDER BY `minOrder` ASC [ RunTime:0.006609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63494150 ORDER BY `unit` DESC [ RunTime:0.007369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63494150 LIMIT 2 [ RunTime:0.002326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63494150 ORDER BY `minOrder` ASC [ RunTime:0.005424s ]
select * from pdf where partno='4011425' and brandshort='Simco-Ion' limit 1 [ RunTime:0.014974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011425' OR `brand` LIKE 'Simco-Ion%' ) ) LIMIT 1 [ RunTime:0.005487s ]
SELECT `id` FROM `stock` WHERE `id` <> 63494150 AND `partno` = '4011425' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%simco-ion%' ) [ RunTime:0.006758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12385801 [ RunTime:0.003947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503268 LIMIT 5 [ RunTime:0.026919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503268 ORDER BY `minOrder` ASC [ RunTime:0.008593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58503268 ORDER BY `unit` DESC [ RunTime:0.019864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58503268 LIMIT 2 [ RunTime:0.013477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503268 ORDER BY `minOrder` ASC [ RunTime:0.010812s ]
select * from pdf where partno='40111020' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40111020' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015849s ]
SELECT `id` FROM `stock` WHERE `id` <> 58503268 AND `partno` = '40111020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.013657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11171470 [ RunTime:0.004187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58538888 LIMIT 5 [ RunTime:0.034578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58538888 ORDER BY `minOrder` ASC [ RunTime:0.027999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58538888 ORDER BY `unit` DESC [ RunTime:0.038094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58538888 LIMIT 2 [ RunTime:0.031330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58538888 ORDER BY `minOrder` ASC [ RunTime:0.013118s ]
select * from pdf where partno='4011-201-0400' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.013428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-201-0400' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.022698s ]
SELECT `id` FROM `stock` WHERE `id` <> 58538888 AND `partno` = '4011-201-0400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.022519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503237 LIMIT 5 [ RunTime:0.024404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503237 ORDER BY `minOrder` ASC [ RunTime:0.068748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58503237 ORDER BY `unit` DESC [ RunTime:0.022330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58503237 LIMIT 2 [ RunTime:0.013210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503237 ORDER BY `minOrder` ASC [ RunTime:0.012032s ]
select * from pdf where partno='40112005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.033509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40112005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.028214s ]
SELECT `id` FROM `stock` WHERE `id` <> 58503237 AND `partno` = '40112005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.034247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148701 [ RunTime:0.016669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503304 LIMIT 5 [ RunTime:0.017037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503304 ORDER BY `minOrder` ASC [ RunTime:0.024543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58503304 ORDER BY `unit` DESC [ RunTime:0.020226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58503304 LIMIT 2 [ RunTime:0.024031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503304 ORDER BY `minOrder` ASC [ RunTime:0.011681s ]
select * from pdf where partno='40114010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40114010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.043708s ]
SELECT `id` FROM `stock` WHERE `id` <> 58503304 AND `partno` = '40114010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.077500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148744 [ RunTime:0.023883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503274 LIMIT 5 [ RunTime:0.046791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503274 ORDER BY `minOrder` ASC [ RunTime:0.050885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58503274 ORDER BY `unit` DESC [ RunTime:0.028295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58503274 LIMIT 2 [ RunTime:0.032686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503274 ORDER BY `minOrder` ASC [ RunTime:0.114348s ]
select * from pdf where partno='40112010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.029403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40112010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016942s ]
SELECT `id` FROM `stock` WHERE `id` <> 58503274 AND `partno` = '40112010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.031428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148726 [ RunTime:0.019772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58503259 LIMIT 5 [ RunTime:0.021036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503259 ORDER BY `minOrder` ASC [ RunTime:0.020576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58503259 ORDER BY `unit` DESC [ RunTime:0.028753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58503259 LIMIT 2 [ RunTime:0.050275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58503259 ORDER BY `minOrder` ASC [ RunTime:0.044508s ]
select * from pdf where partno='40111010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40111010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.037581s ]
SELECT `id` FROM `stock` WHERE `id` <> 58503259 AND `partno` = '40111010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.040794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148719 [ RunTime:0.003586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520905 LIMIT 5 [ RunTime:0.017772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520905 ORDER BY `minOrder` ASC [ RunTime:0.032456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520905 ORDER BY `unit` DESC [ RunTime:0.019936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520905 LIMIT 2 [ RunTime:0.008875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520905 ORDER BY `minOrder` ASC [ RunTime:0.009580s ]
select * from pdf where partno='4011-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010530s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520905 AND `partno` = '4011-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344875 [ RunTime:0.019256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520607 LIMIT 5 [ RunTime:0.015110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520607 ORDER BY `minOrder` ASC [ RunTime:0.000870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520607 ORDER BY `unit` DESC [ RunTime:0.016228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520607 LIMIT 2 [ RunTime:0.003468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520607 ORDER BY `minOrder` ASC [ RunTime:0.011048s ]
select * from pdf where partno='4011-G' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4011-G' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009374s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520607 AND `partno` = '4011-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457802 [ RunTime:0.010338s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013971s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015215s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032313s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008864s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014680s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028905s ]
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 '4011%' OR `brand` LIKE '4011%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005838s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4011%' OR `brand` LIKE '4011%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022723s ]