SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.005218s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.226' , `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=15107&search=1' [ RunTime:0.007435s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.005698s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000553s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.011703s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.226' ) [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.007907s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005900s ]
SELECT * FROM `stock_search` WHERE `partno` = '15107' LIMIT 1 [ RunTime:0.002535s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-06 00:21:50' WHERE `partno` = '15107' [ RunTime:0.002846s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.020993s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011565s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510012 LIMIT 5 [ RunTime:0.011198s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510012 ORDER BY `minOrder` ASC [ RunTime:0.003809s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510012 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510012 LIMIT 2 [ RunTime:0.002501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510012 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412823 LIMIT 5 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412823 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412823 ORDER BY `unit` DESC [ RunTime:0.011677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412823 LIMIT 2 [ RunTime:0.012687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412823 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13860480 LIMIT 5 [ RunTime:0.005083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13860480 ORDER BY `minOrder` ASC [ RunTime:0.014491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13860480 ORDER BY `unit` DESC [ RunTime:0.010856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13860480 LIMIT 2 [ RunTime:0.005527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13860480 ORDER BY `minOrder` ASC [ RunTime:0.006606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12565780 LIMIT 5 [ RunTime:0.001032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12565780 ORDER BY `minOrder` ASC [ RunTime:0.009713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12565780 ORDER BY `unit` DESC [ RunTime:0.002061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12565780 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12565780 ORDER BY `minOrder` ASC [ RunTime:0.004713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673807 LIMIT 5 [ RunTime:0.004979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673807 ORDER BY `minOrder` ASC [ RunTime:0.005194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673807 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673807 LIMIT 2 [ RunTime:0.001754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673807 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659966 LIMIT 5 [ RunTime:0.002803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659966 ORDER BY `minOrder` ASC [ RunTime:0.011293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659966 ORDER BY `unit` DESC [ RunTime:0.005532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659966 LIMIT 2 [ RunTime:0.008590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659966 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659965 LIMIT 5 [ RunTime:0.001999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659965 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659965 ORDER BY `unit` DESC [ RunTime:0.001911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659965 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659965 ORDER BY `minOrder` ASC [ RunTime:0.001480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659964 LIMIT 5 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659964 ORDER BY `minOrder` ASC [ RunTime:0.007777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659964 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659964 LIMIT 2 [ RunTime:0.003852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659964 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659963 LIMIT 5 [ RunTime:0.001548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659963 ORDER BY `minOrder` ASC [ RunTime:0.002146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659963 ORDER BY `unit` DESC [ RunTime:0.009084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659963 LIMIT 2 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659963 ORDER BY `minOrder` ASC [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19581138 LIMIT 5 [ RunTime:0.004027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581138 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19581138 ORDER BY `unit` DESC [ RunTime:0.002968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19581138 LIMIT 2 [ RunTime:0.008856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19581138 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508848 LIMIT 5 [ RunTime:0.003950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508848 ORDER BY `minOrder` ASC [ RunTime:0.008455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17508848 ORDER BY `unit` DESC [ RunTime:0.013812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17508848 LIMIT 2 [ RunTime:0.006602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508848 ORDER BY `minOrder` ASC [ RunTime:0.002396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266923 LIMIT 5 [ RunTime:0.008278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266923 ORDER BY `minOrder` ASC [ RunTime:0.005381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14266923 ORDER BY `unit` DESC [ RunTime:0.018642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14266923 LIMIT 2 [ RunTime:0.007865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266923 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13808228 LIMIT 5 [ RunTime:0.010282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808228 ORDER BY `minOrder` ASC [ RunTime:0.009648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13808228 ORDER BY `unit` DESC [ RunTime:0.013134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13808228 LIMIT 2 [ RunTime:0.012238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808228 ORDER BY `minOrder` ASC [ RunTime:0.020619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13808014 LIMIT 5 [ RunTime:0.029661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808014 ORDER BY `minOrder` ASC [ RunTime:0.020277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13808014 ORDER BY `unit` DESC [ RunTime:0.009393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13808014 LIMIT 2 [ RunTime:0.011373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808014 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510208 LIMIT 5 [ RunTime:0.003310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510208 ORDER BY `minOrder` ASC [ RunTime:0.006263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510208 ORDER BY `unit` DESC [ RunTime:0.017495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510208 LIMIT 2 [ RunTime:0.007918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510208 ORDER BY `minOrder` ASC [ RunTime:0.001501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510203 LIMIT 5 [ RunTime:0.013954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510203 ORDER BY `minOrder` ASC [ RunTime:0.020042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510203 ORDER BY `unit` DESC [ RunTime:0.018077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510203 LIMIT 2 [ RunTime:0.041794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510203 ORDER BY `minOrder` ASC [ RunTime:0.012062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510200 LIMIT 5 [ RunTime:0.006079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510200 ORDER BY `minOrder` ASC [ RunTime:0.011489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510200 ORDER BY `unit` DESC [ RunTime:0.022780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510200 LIMIT 2 [ RunTime:0.009116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510200 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12509273 LIMIT 5 [ RunTime:0.014741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509273 ORDER BY `minOrder` ASC [ RunTime:0.010222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12509273 ORDER BY `unit` DESC [ RunTime:0.014347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12509273 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12509273 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12034116 LIMIT 5 [ RunTime:0.007036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12034116 ORDER BY `minOrder` ASC [ RunTime:0.013553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12034116 ORDER BY `unit` DESC [ RunTime:0.026813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12034116 LIMIT 2 [ RunTime:0.015513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12034116 ORDER BY `minOrder` ASC [ RunTime:0.005208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11412631 LIMIT 5 [ RunTime:0.002508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412631 ORDER BY `minOrder` ASC [ RunTime:0.010537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11412631 ORDER BY `unit` DESC [ RunTime:0.021278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11412631 LIMIT 2 [ RunTime:0.003117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11412631 ORDER BY `minOrder` ASC [ RunTime:0.008970s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007153s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391675 LIMIT 5 [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391675 ORDER BY `minOrder` ASC [ RunTime:0.001729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391675 ORDER BY `unit` DESC [ RunTime:0.018901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391675 LIMIT 2 [ RunTime:0.007996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391675 ORDER BY `minOrder` ASC [ RunTime:0.009469s ]
select * from pdf where partno='1510760014' and brandshort='Molex' limit 1 [ RunTime:0.017591s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.007215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510760014' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.027995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391669 LIMIT 5 [ RunTime:0.027270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391669 ORDER BY `minOrder` ASC [ RunTime:0.011345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391669 ORDER BY `unit` DESC [ RunTime:0.010674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391669 LIMIT 2 [ RunTime:0.003931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391669 ORDER BY `minOrder` ASC [ RunTime:0.008152s ]
select * from pdf where partno='1510760012' and brandshort='Molex' limit 1 [ RunTime:0.020837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510760012' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41860858 LIMIT 5 [ RunTime:0.014030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41860858 ORDER BY `minOrder` ASC [ RunTime:0.006100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41860858 ORDER BY `unit` DESC [ RunTime:0.003329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41860858 LIMIT 2 [ RunTime:0.015003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41860858 ORDER BY `minOrder` ASC [ RunTime:0.015450s ]
select * from pdf where partno='151070' and brandshort='OptiFuse' limit 1 [ RunTime:0.012074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151070' OR `brand` LIKE 'OptiFuse%' ) ) LIMIT 1 [ RunTime:0.008020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59350729 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350729 ORDER BY `minOrder` ASC [ RunTime:0.018168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59350729 ORDER BY `unit` DESC [ RunTime:0.007234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59350729 LIMIT 2 [ RunTime:0.026773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59350729 ORDER BY `minOrder` ASC [ RunTime:0.019230s ]
select * from pdf where partno='15107' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.018845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15107' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.004998s ]
SELECT `id` FROM `stock` WHERE `id` <> 59350729 AND `partno` = '15107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.016769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12565780 [ RunTime:0.022703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62131169 LIMIT 5 [ RunTime:0.012769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62131169 ORDER BY `minOrder` ASC [ RunTime:0.026637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62131169 ORDER BY `unit` DESC [ RunTime:0.022962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62131169 LIMIT 2 [ RunTime:0.018645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62131169 ORDER BY `minOrder` ASC [ RunTime:0.003435s ]
select * from pdf where partno='1510748' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510748' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63377870 LIMIT 5 [ RunTime:0.010784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63377870 ORDER BY `minOrder` ASC [ RunTime:0.024688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63377870 ORDER BY `unit` DESC [ RunTime:0.011044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63377870 LIMIT 2 [ RunTime:0.015539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63377870 ORDER BY `minOrder` ASC [ RunTime:0.014393s ]
select * from pdf where partno='151076' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151076' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011928s ]
SELECT `id` FROM `stock` WHERE `id` <> 63377870 AND `partno` = '151076' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13808228 [ RunTime:0.002306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63377800 LIMIT 5 [ RunTime:0.009263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63377800 ORDER BY `minOrder` ASC [ RunTime:0.010878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63377800 ORDER BY `unit` DESC [ RunTime:0.005654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63377800 LIMIT 2 [ RunTime:0.012005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63377800 ORDER BY `minOrder` ASC [ RunTime:0.002968s ]
select * from pdf where partno='151071' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151071' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009723s ]
SELECT `id` FROM `stock` WHERE `id` <> 63377800 AND `partno` = '151071' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508848 [ RunTime:0.008614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63184692 LIMIT 5 [ RunTime:0.012350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63184692 ORDER BY `minOrder` ASC [ RunTime:0.005294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63184692 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63184692 LIMIT 2 [ RunTime:0.012622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63184692 ORDER BY `minOrder` ASC [ RunTime:0.007248s ]
select * from pdf where partno='15107' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.018031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15107' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.005034s ]
SELECT `id` FROM `stock` WHERE `id` <> 63184692 AND `partno` = '15107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.006758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266923 [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62138323 LIMIT 5 [ RunTime:0.003316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138323 ORDER BY `minOrder` ASC [ RunTime:0.003017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62138323 ORDER BY `unit` DESC [ RunTime:0.003882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62138323 LIMIT 2 [ RunTime:0.002014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138323 ORDER BY `minOrder` ASC [ RunTime:0.001858s ]
select * from pdf where partno='1510722' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510722' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60992541 LIMIT 5 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992541 ORDER BY `minOrder` ASC [ RunTime:0.009804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60992541 ORDER BY `unit` DESC [ RunTime:0.002957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60992541 LIMIT 2 [ RunTime:0.004140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992541 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
select * from pdf where partno='1510730001' and brandshort='Molex' limit 1 [ RunTime:0.000713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510730001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60526229 LIMIT 5 [ RunTime:0.006089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60526229 ORDER BY `minOrder` ASC [ RunTime:0.012523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60526229 ORDER BY `unit` DESC [ RunTime:0.016416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60526229 LIMIT 2 [ RunTime:0.006106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60526229 ORDER BY `minOrder` ASC [ RunTime:0.001466s ]
select * from pdf where partno='1510791' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510791' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60392074 LIMIT 5 [ RunTime:0.014321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392074 ORDER BY `minOrder` ASC [ RunTime:0.020386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60392074 ORDER BY `unit` DESC [ RunTime:0.006075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60392074 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392074 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='1510760016' and brandshort='Molex' limit 1 [ RunTime:0.011319s ]
select foldpath,foldpath2,filename from pdf_file where id=1895227 limit 1 [ RunTime:0.001102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510760016' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60392031 LIMIT 5 [ RunTime:0.006943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392031 ORDER BY `minOrder` ASC [ RunTime:0.008549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60392031 ORDER BY `unit` DESC [ RunTime:0.010676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60392031 LIMIT 2 [ RunTime:0.002115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392031 ORDER BY `minOrder` ASC [ RunTime:0.004081s ]
select * from pdf where partno='1510760015' and brandshort='Molex' limit 1 [ RunTime:0.009178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510760015' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60392024 LIMIT 5 [ RunTime:0.014521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392024 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60392024 ORDER BY `unit` DESC [ RunTime:0.002194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60392024 LIMIT 2 [ RunTime:0.006042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392024 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
select * from pdf where partno='1510760013' and brandshort='Molex' limit 1 [ RunTime:0.002286s ]
select foldpath,foldpath2,filename from pdf_file where id=1574141 limit 1 [ RunTime:0.000640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510760013' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60375294 LIMIT 5 [ RunTime:0.013471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60375294 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60375294 ORDER BY `unit` DESC [ RunTime:0.013036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60375294 LIMIT 2 [ RunTime:0.005576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60375294 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='1510730011' and brandshort='Molex' limit 1 [ RunTime:0.007304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1510730011' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010804s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001289s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003117s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002725s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011897s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002844s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005033s ]
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 '15107%' OR `brand` LIKE '15107%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001358s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15107%' OR `brand` LIKE '15107%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001846s ]