SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001249s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=22020&search=1' [ RunTime:0.010239s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001712s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001717s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001180s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001111s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011763s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001973s ]
SELECT * FROM `stock_search` WHERE `partno` = '22020' LIMIT 1 [ RunTime:0.015851s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-25 23:51:46' WHERE `partno` = '22020' [ RunTime:0.014532s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002246s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056812s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991582 LIMIT 5 [ RunTime:0.021130s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991582 ORDER BY `minOrder` ASC [ RunTime:0.017834s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991582 ORDER BY `unit` DESC [ RunTime:0.016574s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991582 LIMIT 2 [ RunTime:0.037232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991582 ORDER BY `minOrder` ASC [ RunTime:0.015930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996862 LIMIT 5 [ RunTime:0.020552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996862 ORDER BY `minOrder` ASC [ RunTime:0.043859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18996862 ORDER BY `unit` DESC [ RunTime:0.052547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18996862 LIMIT 2 [ RunTime:0.040115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996862 ORDER BY `minOrder` ASC [ RunTime:0.016459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17051858 LIMIT 5 [ RunTime:0.051608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17051858 ORDER BY `minOrder` ASC [ RunTime:0.036634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17051858 ORDER BY `unit` DESC [ RunTime:0.020583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17051858 LIMIT 2 [ RunTime:0.040778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17051858 ORDER BY `minOrder` ASC [ RunTime:0.015442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998173 LIMIT 5 [ RunTime:0.034422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998173 ORDER BY `minOrder` ASC [ RunTime:0.033141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998173 ORDER BY `unit` DESC [ RunTime:0.064957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998173 LIMIT 2 [ RunTime:0.036461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998173 ORDER BY `minOrder` ASC [ RunTime:0.011013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15269058 LIMIT 5 [ RunTime:0.045328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269058 ORDER BY `minOrder` ASC [ RunTime:0.026135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15269058 ORDER BY `unit` DESC [ RunTime:0.028222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15269058 LIMIT 2 [ RunTime:0.013820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15269058 ORDER BY `minOrder` ASC [ RunTime:0.005723s ]
select * from pdf where partno='2202007' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19000150 LIMIT 5 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19000150 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19000150 ORDER BY `unit` DESC [ RunTime:0.001393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19000150 LIMIT 2 [ RunTime:0.005768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19000150 ORDER BY `minOrder` ASC [ RunTime:0.010170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17053114 LIMIT 5 [ RunTime:0.014057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17053114 ORDER BY `minOrder` ASC [ RunTime:0.006190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17053114 ORDER BY `unit` DESC [ RunTime:0.030272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17053114 LIMIT 2 [ RunTime:0.005190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17053114 ORDER BY `minOrder` ASC [ RunTime:0.007771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199380 LIMIT 5 [ RunTime:0.021455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199380 ORDER BY `minOrder` ASC [ RunTime:0.005350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14199380 ORDER BY `unit` DESC [ RunTime:0.002371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14199380 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199380 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18999548 LIMIT 5 [ RunTime:0.013765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18999548 ORDER BY `minOrder` ASC [ RunTime:0.005935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18999548 ORDER BY `unit` DESC [ RunTime:0.011496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18999548 LIMIT 2 [ RunTime:0.004639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18999548 ORDER BY `minOrder` ASC [ RunTime:0.003968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997582 LIMIT 5 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997582 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18997582 ORDER BY `unit` DESC [ RunTime:0.001435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18997582 LIMIT 2 [ RunTime:0.016577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997582 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997436 LIMIT 5 [ RunTime:0.008852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997436 ORDER BY `minOrder` ASC [ RunTime:0.005917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18997436 ORDER BY `unit` DESC [ RunTime:0.002635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18997436 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997436 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997386 LIMIT 5 [ RunTime:0.004620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997386 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18997386 ORDER BY `unit` DESC [ RunTime:0.009728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18997386 LIMIT 2 [ RunTime:0.009705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997386 ORDER BY `minOrder` ASC [ RunTime:0.003029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997351 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997351 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18997351 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18997351 LIMIT 2 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997351 ORDER BY `minOrder` ASC [ RunTime:0.011309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997192 LIMIT 5 [ RunTime:0.002816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997192 ORDER BY `minOrder` ASC [ RunTime:0.004951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18997192 ORDER BY `unit` DESC [ RunTime:0.005609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18997192 LIMIT 2 [ RunTime:0.008084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997192 ORDER BY `minOrder` ASC [ RunTime:0.001129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991743 LIMIT 5 [ RunTime:0.001860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991743 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991743 ORDER BY `unit` DESC [ RunTime:0.006230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991743 LIMIT 2 [ RunTime:0.007735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991743 ORDER BY `minOrder` ASC [ RunTime:0.006275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991665 LIMIT 5 [ RunTime:0.001529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991665 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991665 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991665 LIMIT 2 [ RunTime:0.002172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991665 ORDER BY `minOrder` ASC [ RunTime:0.002590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991430 LIMIT 5 [ RunTime:0.002678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991430 ORDER BY `minOrder` ASC [ RunTime:0.004972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991430 ORDER BY `unit` DESC [ RunTime:0.001915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991430 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991430 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052589 LIMIT 5 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052589 ORDER BY `minOrder` ASC [ RunTime:0.001329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17052589 ORDER BY `unit` DESC [ RunTime:0.004914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17052589 LIMIT 2 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052589 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17051220 LIMIT 5 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17051220 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17051220 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17051220 LIMIT 2 [ RunTime:0.002104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17051220 ORDER BY `minOrder` ASC [ RunTime:0.004858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17022654 LIMIT 5 [ RunTime:0.012418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022654 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17022654 ORDER BY `unit` DESC [ RunTime:0.002676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17022654 LIMIT 2 [ RunTime:0.003236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022654 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077112 LIMIT 5 [ RunTime:0.005392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077112 ORDER BY `minOrder` ASC [ RunTime:0.004335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077112 ORDER BY `unit` DESC [ RunTime:0.005850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077112 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077112 ORDER BY `minOrder` ASC [ RunTime:0.002233s ]
select * from pdf where partno='2202031' and brandshort='phoenix contact' limit 1 [ RunTime:0.000990s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202031' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.005864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078143 LIMIT 5 [ RunTime:0.001123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078143 ORDER BY `minOrder` ASC [ RunTime:0.010492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078143 ORDER BY `unit` DESC [ RunTime:0.003162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078143 LIMIT 2 [ RunTime:0.001668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078143 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='2202019' and brandshort='phoenix contact' limit 1 [ RunTime:0.001649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202019' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.003299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077087 LIMIT 5 [ RunTime:0.002985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077087 ORDER BY `minOrder` ASC [ RunTime:0.011305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077087 ORDER BY `unit` DESC [ RunTime:0.002715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077087 LIMIT 2 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077087 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='2202030' and brandshort='phoenix contact' limit 1 [ RunTime:0.001354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202030' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.003291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078147 LIMIT 5 [ RunTime:0.002647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078147 ORDER BY `minOrder` ASC [ RunTime:0.006005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078147 ORDER BY `unit` DESC [ RunTime:0.004538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078147 LIMIT 2 [ RunTime:0.005480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078147 ORDER BY `minOrder` ASC [ RunTime:0.001798s ]
select * from pdf where partno='2202028' and brandshort='phoenix contact' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202028' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.003499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078146 LIMIT 5 [ RunTime:0.003700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078146 ORDER BY `minOrder` ASC [ RunTime:0.001377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078146 ORDER BY `unit` DESC [ RunTime:0.001968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078146 LIMIT 2 [ RunTime:0.005668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078146 ORDER BY `minOrder` ASC [ RunTime:0.004407s ]
select * from pdf where partno='2202023' and brandshort='phoenix contact' limit 1 [ RunTime:0.005349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202023' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.003461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078144 LIMIT 5 [ RunTime:0.003559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078144 ORDER BY `minOrder` ASC [ RunTime:0.002624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078144 ORDER BY `unit` DESC [ RunTime:0.000602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078144 LIMIT 2 [ RunTime:0.005644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078144 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='2202021' and brandshort='phoenix contact' limit 1 [ RunTime:0.003231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202021' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.005389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078142 LIMIT 5 [ RunTime:0.002691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078142 ORDER BY `minOrder` ASC [ RunTime:0.010136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078142 ORDER BY `unit` DESC [ RunTime:0.006618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078142 LIMIT 2 [ RunTime:0.002329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078142 ORDER BY `minOrder` ASC [ RunTime:0.005821s ]
select * from pdf where partno='2202018' and brandshort='phoenix contact' limit 1 [ RunTime:0.003055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202018' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078148 LIMIT 5 [ RunTime:0.004649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078148 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078148 ORDER BY `unit` DESC [ RunTime:0.001430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078148 LIMIT 2 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078148 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='2202045' and brandshort='phoenix contact' limit 1 [ RunTime:0.001134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202045' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.006924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078149 LIMIT 5 [ RunTime:0.006351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078149 ORDER BY `minOrder` ASC [ RunTime:0.004453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078149 ORDER BY `unit` DESC [ RunTime:0.003955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078149 LIMIT 2 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078149 ORDER BY `minOrder` ASC [ RunTime:0.004533s ]
select * from pdf where partno='2202046' and brandshort='phoenix contact' limit 1 [ RunTime:0.006026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202046' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077165 LIMIT 5 [ RunTime:0.001067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077165 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077165 ORDER BY `unit` DESC [ RunTime:0.000899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077165 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077165 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='2202032' and brandshort='phoenix contact' limit 1 [ RunTime:0.005380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202032' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.009161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078145 LIMIT 5 [ RunTime:0.002326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078145 ORDER BY `minOrder` ASC [ RunTime:0.003834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078145 ORDER BY `unit` DESC [ RunTime:0.000468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078145 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078145 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='2202022' and brandshort='phoenix contact' limit 1 [ RunTime:0.001196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202022' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077154 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077154 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077154 ORDER BY `unit` DESC [ RunTime:0.008416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077154 LIMIT 2 [ RunTime:0.004082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077154 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='2202096' and brandshort='phoenix contact' limit 1 [ RunTime:0.002932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202096' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.001477s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56182413 LIMIT 5 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182413 ORDER BY `minOrder` ASC [ RunTime:0.015275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56182413 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56182413 LIMIT 2 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56182413 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='2202040' and brandshort='LAPP' limit 1 [ RunTime:0.005612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202040' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.000451s ]
SELECT `id` FROM `stock` WHERE `id` <> 56182413 AND `partno` = '2202040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384051 [ RunTime:0.014400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997963 LIMIT 5 [ RunTime:0.003079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997963 ORDER BY `minOrder` ASC [ RunTime:0.011020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997963 ORDER BY `unit` DESC [ RunTime:0.004084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997963 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997963 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='220204' and brandshort='LAPP' limit 1 [ RunTime:0.001374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '220204' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.002414s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997963 AND `partno` = '220204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.006797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14383715 [ RunTime:0.002752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63450592 LIMIT 5 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63450592 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63450592 ORDER BY `unit` DESC [ RunTime:0.004552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63450592 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63450592 ORDER BY `minOrder` ASC [ RunTime:0.001223s ]
select * from pdf where partno='2202023' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202023' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63450942 LIMIT 5 [ RunTime:0.016398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63450942 ORDER BY `minOrder` ASC [ RunTime:0.015085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63450942 ORDER BY `unit` DESC [ RunTime:0.000515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63450942 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63450942 ORDER BY `minOrder` ASC [ RunTime:0.002746s ]
select * from pdf where partno='2202029' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202029' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63451003 LIMIT 5 [ RunTime:0.002536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63451003 ORDER BY `minOrder` ASC [ RunTime:0.004553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63451003 ORDER BY `unit` DESC [ RunTime:0.004816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63451003 LIMIT 2 [ RunTime:0.003683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63451003 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='2202028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460082 LIMIT 5 [ RunTime:0.006954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460082 ORDER BY `minOrder` ASC [ RunTime:0.014976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460082 ORDER BY `unit` DESC [ RunTime:0.008297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460082 LIMIT 2 [ RunTime:0.002982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460082 ORDER BY `minOrder` ASC [ RunTime:0.001907s ]
select * from pdf where partno='2202022' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202022' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460438 LIMIT 5 [ RunTime:0.009336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460438 ORDER BY `minOrder` ASC [ RunTime:0.002301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460438 ORDER BY `unit` DESC [ RunTime:0.005500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460438 LIMIT 2 [ RunTime:0.001517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460438 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='2202021' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202021' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460407 LIMIT 5 [ RunTime:0.005519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460407 ORDER BY `minOrder` ASC [ RunTime:0.011987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460407 ORDER BY `unit` DESC [ RunTime:0.002479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460407 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460407 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='2202019' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202019' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460408 LIMIT 5 [ RunTime:0.005725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460408 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460408 ORDER BY `unit` DESC [ RunTime:0.013816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460408 LIMIT 2 [ RunTime:0.005504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460408 ORDER BY `minOrder` ASC [ RunTime:0.004066s ]
select * from pdf where partno='2202018' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202018' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586435 LIMIT 5 [ RunTime:0.007944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586435 ORDER BY `minOrder` ASC [ RunTime:0.003751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586435 ORDER BY `unit` DESC [ RunTime:0.002567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586435 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586435 ORDER BY `minOrder` ASC [ RunTime:0.000174s ]
select * from pdf where partno='22020' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.000968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22020' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000572s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586435 AND `partno` = '22020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460462 LIMIT 5 [ RunTime:0.004584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460462 ORDER BY `minOrder` ASC [ RunTime:0.004965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460462 ORDER BY `unit` DESC [ RunTime:0.001250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460462 LIMIT 2 [ RunTime:0.006078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460462 ORDER BY `minOrder` ASC [ RunTime:0.003815s ]
select * from pdf where partno='2202046' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202046' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460461 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460461 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460461 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460461 LIMIT 2 [ RunTime:0.002303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460461 ORDER BY `minOrder` ASC [ RunTime:0.004218s ]
select * from pdf where partno='2202045' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202045' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64445286 LIMIT 5 [ RunTime:0.004547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445286 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64445286 ORDER BY `unit` DESC [ RunTime:0.006897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64445286 LIMIT 2 [ RunTime:0.004964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64445286 ORDER BY `minOrder` ASC [ RunTime:0.002322s ]
select * from pdf where partno='22020000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.002975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22020000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000603s ]
SELECT `id` FROM `stock` WHERE `id` <> 64445286 AND `partno` = '22020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.003176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17022654 [ RunTime:0.016077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461773 LIMIT 5 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461773 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461773 ORDER BY `unit` DESC [ RunTime:0.000265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461773 LIMIT 2 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461773 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='2202098' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202098' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461591 LIMIT 5 [ RunTime:0.002196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461591 ORDER BY `minOrder` ASC [ RunTime:0.011049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461591 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461591 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461591 ORDER BY `minOrder` ASC [ RunTime:0.001545s ]
select * from pdf where partno='2202096' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202096' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461531 LIMIT 5 [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461531 ORDER BY `minOrder` ASC [ RunTime:0.004299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461531 ORDER BY `unit` DESC [ RunTime:0.001008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461531 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461531 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
select * from pdf where partno='2202047' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202047' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461472 LIMIT 5 [ RunTime:0.009978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461472 ORDER BY `minOrder` ASC [ RunTime:0.002533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461472 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461472 LIMIT 2 [ RunTime:0.003821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461472 ORDER BY `minOrder` ASC [ RunTime:0.009444s ]
select * from pdf where partno='2202034' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202034' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461468 LIMIT 5 [ RunTime:0.002007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461468 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461468 ORDER BY `unit` DESC [ RunTime:0.003424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461468 LIMIT 2 [ RunTime:0.010003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461468 ORDER BY `minOrder` ASC [ RunTime:0.006547s ]
select * from pdf where partno='2202087' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202087' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461439 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461439 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461439 ORDER BY `unit` DESC [ RunTime:0.001973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461439 LIMIT 2 [ RunTime:0.016232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461439 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='2202033' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202033' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63461164 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461164 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63461164 ORDER BY `unit` DESC [ RunTime:0.001406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63461164 LIMIT 2 [ RunTime:0.016433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63461164 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='2202032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2202032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003357s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001243s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002572s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005803s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007828s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002437s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001215s ]
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 '22020%' OR `brand` LIKE '22020%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012579s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '22020%' OR `brand` LIKE '22020%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003711s ]