SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002191s ]
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=0388&search=1' [ RunTime:0.005039s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001411s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001621s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001260s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002236s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001505s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005402s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001416s ]
SELECT * FROM `stock_search` WHERE `partno` = '0388' LIMIT 1 [ RunTime:0.004700s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-24 18:42:34' WHERE `partno` = '0388' [ RunTime:0.008279s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001326s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057445s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300488 LIMIT 5 [ RunTime:0.014910s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300488 ORDER BY `minOrder` ASC [ RunTime:0.021346s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300488 ORDER BY `unit` DESC [ RunTime:0.004764s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.033916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300488 LIMIT 2 [ RunTime:0.036066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300488 ORDER BY `minOrder` ASC [ RunTime:0.015951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442940 LIMIT 5 [ RunTime:0.008335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442940 ORDER BY `minOrder` ASC [ RunTime:0.026376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15442940 ORDER BY `unit` DESC [ RunTime:0.021546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15442940 LIMIT 2 [ RunTime:0.048754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442940 ORDER BY `minOrder` ASC [ RunTime:0.006386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594098 LIMIT 5 [ RunTime:0.033426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594098 ORDER BY `minOrder` ASC [ RunTime:0.015920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594098 ORDER BY `unit` DESC [ RunTime:0.030998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594098 LIMIT 2 [ RunTime:0.032131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594098 ORDER BY `minOrder` ASC [ RunTime:0.016687s ]
select * from pdf where partno='0388-0-15-80-08-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.021142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594101 LIMIT 5 [ RunTime:0.016223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594101 ORDER BY `minOrder` ASC [ RunTime:0.021128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594101 ORDER BY `unit` DESC [ RunTime:0.014172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594101 LIMIT 2 [ RunTime:0.011580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594101 ORDER BY `minOrder` ASC [ RunTime:0.003100s ]
select * from pdf where partno='0388-0-15-15-08-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.008411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594099 LIMIT 5 [ RunTime:0.014092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594099 ORDER BY `minOrder` ASC [ RunTime:0.023193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19594099 ORDER BY `unit` DESC [ RunTime:0.027041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19594099 LIMIT 2 [ RunTime:0.007122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19594099 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11685851 LIMIT 5 [ RunTime:0.022408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685851 ORDER BY `minOrder` ASC [ RunTime:0.018559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11685851 ORDER BY `unit` DESC [ RunTime:0.013982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11685851 LIMIT 2 [ RunTime:0.011372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11685851 ORDER BY `minOrder` ASC [ RunTime:0.004298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596826 LIMIT 5 [ RunTime:0.022969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596826 ORDER BY `minOrder` ASC [ RunTime:0.024367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596826 ORDER BY `unit` DESC [ RunTime:0.009078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596826 LIMIT 2 [ RunTime:0.008065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596826 ORDER BY `minOrder` ASC [ RunTime:0.001616s ]
select * from pdf where partno='0388-0-15-80-08-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596825 LIMIT 5 [ RunTime:0.017034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596825 ORDER BY `minOrder` ASC [ RunTime:0.026233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596825 ORDER BY `unit` DESC [ RunTime:0.014724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596825 LIMIT 2 [ RunTime:0.012304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596825 ORDER BY `minOrder` ASC [ RunTime:0.003858s ]
select * from pdf where partno='0388-0-15-01-08-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.029595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561987 LIMIT 5 [ RunTime:0.017224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561987 ORDER BY `minOrder` ASC [ RunTime:0.011011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561987 ORDER BY `unit` DESC [ RunTime:0.072228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561987 LIMIT 2 [ RunTime:0.027057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561987 ORDER BY `minOrder` ASC [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443114 LIMIT 5 [ RunTime:0.017615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443114 ORDER BY `minOrder` ASC [ RunTime:0.004426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15443114 ORDER BY `unit` DESC [ RunTime:0.016074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15443114 LIMIT 2 [ RunTime:0.030447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15443114 ORDER BY `minOrder` ASC [ RunTime:0.025478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328697 LIMIT 5 [ RunTime:0.037725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328697 ORDER BY `minOrder` ASC [ RunTime:0.016045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13328697 ORDER BY `unit` DESC [ RunTime:0.052175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13328697 LIMIT 2 [ RunTime:0.017119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328697 ORDER BY `minOrder` ASC [ RunTime:0.017167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12049509 LIMIT 5 [ RunTime:0.014539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12049509 ORDER BY `minOrder` ASC [ RunTime:0.019142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12049509 ORDER BY `unit` DESC [ RunTime:0.135524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12049509 LIMIT 2 [ RunTime:0.120935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12049509 ORDER BY `minOrder` ASC [ RunTime:0.021623s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063192s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313540 LIMIT 5 [ RunTime:0.014233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313540 ORDER BY `minOrder` ASC [ RunTime:0.086089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313540 ORDER BY `unit` DESC [ RunTime:0.064435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313540 LIMIT 2 [ RunTime:0.079022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313540 ORDER BY `minOrder` ASC [ RunTime:0.025629s ]
select * from pdf where partno='0388-0-15-80-08-80-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.065275s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-80-08-80-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.084186s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313540 AND `partno` = '0388-0-15-80-08-80-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.103527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300488 [ RunTime:0.086970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313465 LIMIT 5 [ RunTime:0.064366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313465 ORDER BY `minOrder` ASC [ RunTime:0.084475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313465 ORDER BY `unit` DESC [ RunTime:0.074450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313465 LIMIT 2 [ RunTime:0.074118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313465 ORDER BY `minOrder` ASC [ RunTime:0.119348s ]
select * from pdf where partno='0388-0-15-15-08-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.130380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-15-08-27-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.054167s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313465 AND `partno` = '0388-0-15-15-08-27-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.196295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442940 [ RunTime:0.093739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60314022 LIMIT 5 [ RunTime:0.079828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314022 ORDER BY `minOrder` ASC [ RunTime:0.169571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60314022 ORDER BY `unit` DESC [ RunTime:0.144589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60314022 LIMIT 2 [ RunTime:0.123580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314022 ORDER BY `minOrder` ASC [ RunTime:0.115052s ]
select * from pdf where partno='0388-0-15-01-08-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.067052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-01-08-27-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.060445s ]
SELECT `id` FROM `stock` WHERE `id` <> 60314022 AND `partno` = '0388-0-15-01-08-27-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.187963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594099 [ RunTime:0.082877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60314393 LIMIT 5 [ RunTime:0.113658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314393 ORDER BY `minOrder` ASC [ RunTime:0.176843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60314393 ORDER BY `unit` DESC [ RunTime:0.091737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60314393 LIMIT 2 [ RunTime:0.040790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60314393 ORDER BY `minOrder` ASC [ RunTime:0.082219s ]
select * from pdf where partno='0388-0-15-80-08-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-80-08-27-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.112525s ]
SELECT `id` FROM `stock` WHERE `id` <> 60314393 AND `partno` = '0388-0-15-80-08-27-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.122640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594098 [ RunTime:0.163558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60323698 LIMIT 5 [ RunTime:0.174834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60323698 ORDER BY `minOrder` ASC [ RunTime:0.096723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60323698 ORDER BY `unit` DESC [ RunTime:0.059787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60323698 LIMIT 2 [ RunTime:0.096634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60323698 ORDER BY `minOrder` ASC [ RunTime:0.020562s ]
select * from pdf where partno='038899' and brandshort='Lumberg Inc' limit 1 [ RunTime:0.140788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '038899' OR `brand` LIKE 'Lumberg Inc%' ) ) LIMIT 1 [ RunTime:0.051223s ]
SELECT `id` FROM `stock` WHERE `id` <> 60323698 AND `partno` = '038899' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg inc%' ) [ RunTime:0.057025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11685851 [ RunTime:0.051141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60313734 LIMIT 5 [ RunTime:0.051226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313734 ORDER BY `minOrder` ASC [ RunTime:0.060608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60313734 ORDER BY `unit` DESC [ RunTime:0.302781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60313734 LIMIT 2 [ RunTime:0.306556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60313734 ORDER BY `minOrder` ASC [ RunTime:0.041856s ]
select * from pdf where partno='0388-0-15-15-08-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.041894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-15-08-14-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.087426s ]
SELECT `id` FROM `stock` WHERE `id` <> 60313734 AND `partno` = '0388-0-15-15-08-14-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.050864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594101 [ RunTime:0.048207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386285 LIMIT 5 [ RunTime:0.043648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386285 ORDER BY `minOrder` ASC [ RunTime:0.117813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386285 ORDER BY `unit` DESC [ RunTime:0.067798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386285 LIMIT 2 [ RunTime:0.026115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386285 ORDER BY `minOrder` ASC [ RunTime:0.011734s ]
select * from pdf where partno='0388700000' and brandshort='Weidmüller' limit 1 [ RunTime:0.028530s ]
select foldpath,foldpath2,filename from pdf_file where id=1089206 limit 1 [ RunTime:0.024510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388700000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.028261s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386285 AND `partno` = '0388700000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.019494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386278 LIMIT 5 [ RunTime:0.033224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386278 ORDER BY `minOrder` ASC [ RunTime:0.025243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386278 ORDER BY `unit` DESC [ RunTime:0.003710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386278 LIMIT 2 [ RunTime:0.006889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386278 ORDER BY `minOrder` ASC [ RunTime:0.030470s ]
select * from pdf where partno='0388900000' and brandshort='Weidmüller' limit 1 [ RunTime:0.035763s ]
select foldpath,foldpath2,filename from pdf_file where id=1179999 limit 1 [ RunTime:0.068172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388900000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.071349s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386278 AND `partno` = '0388900000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386286 LIMIT 5 [ RunTime:0.036790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386286 ORDER BY `minOrder` ASC [ RunTime:0.042879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386286 ORDER BY `unit` DESC [ RunTime:0.017791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386286 LIMIT 2 [ RunTime:0.039766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386286 ORDER BY `minOrder` ASC [ RunTime:0.013213s ]
select * from pdf where partno='0388800000' and brandshort='Weidmüller' limit 1 [ RunTime:0.026473s ]
select foldpath,foldpath2,filename from pdf_file where id=1179998 limit 1 [ RunTime:0.034907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388800000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.027489s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386286 AND `partno` = '0388800000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.024818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60369254 LIMIT 5 [ RunTime:0.012045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369254 ORDER BY `minOrder` ASC [ RunTime:0.021943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60369254 ORDER BY `unit` DESC [ RunTime:0.011935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60369254 LIMIT 2 [ RunTime:0.062409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369254 ORDER BY `minOrder` ASC [ RunTime:0.030661s ]
select * from pdf where partno='0388' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.019945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.021952s ]
SELECT `id` FROM `stock` WHERE `id` <> 60369254 AND `partno` = '0388' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.042828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561987 [ RunTime:0.021484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60369253 LIMIT 5 [ RunTime:0.015758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369253 ORDER BY `minOrder` ASC [ RunTime:0.028939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60369253 ORDER BY `unit` DESC [ RunTime:0.013802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60369253 LIMIT 2 [ RunTime:0.021164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369253 ORDER BY `minOrder` ASC [ RunTime:0.011543s ]
select * from pdf where partno='0388EE' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.042041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388EE' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.007094s ]
SELECT `id` FROM `stock` WHERE `id` <> 60369253 AND `partno` = '0388EE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.015862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60317552 LIMIT 5 [ RunTime:0.017759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60317552 ORDER BY `minOrder` ASC [ RunTime:0.007380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60317552 ORDER BY `unit` DESC [ RunTime:0.005435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60317552 LIMIT 2 [ RunTime:0.001564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60317552 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='0388-0-15-80-08-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-80-08-14-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001624s ]
SELECT `id` FROM `stock` WHERE `id` <> 60317552 AND `partno` = '0388-0-15-80-08-14-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596826 [ RunTime:0.000817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60317551 LIMIT 5 [ RunTime:0.002844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60317551 ORDER BY `minOrder` ASC [ RunTime:0.010393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60317551 ORDER BY `unit` DESC [ RunTime:0.002188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60317551 LIMIT 2 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60317551 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='0388-0-15-01-08-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-01-08-14-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000832s ]
SELECT `id` FROM `stock` WHERE `id` <> 60317551 AND `partno` = '0388-0-15-01-08-14-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596825 [ RunTime:0.003498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60317057 LIMIT 5 [ RunTime:0.008676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60317057 ORDER BY `minOrder` ASC [ RunTime:0.006033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60317057 ORDER BY `unit` DESC [ RunTime:0.002055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60317057 LIMIT 2 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60317057 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='0388-0-15-01-08-01-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388-0-15-01-08-01-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.002071s ]
SELECT `id` FROM `stock` WHERE `id` <> 60317057 AND `partno` = '0388-0-15-01-08-01-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.009130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443114 [ RunTime:0.000797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59391221 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59391221 ORDER BY `minOrder` ASC [ RunTime:0.014050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59391221 ORDER BY `unit` DESC [ RunTime:0.001145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59391221 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59391221 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='0388600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001108s ]
select foldpath,foldpath2,filename from pdf_file where id=1089205 limit 1 [ RunTime:0.000544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001568s ]
SELECT `id` FROM `stock` WHERE `id` <> 59391221 AND `partno` = '0388600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59387657 LIMIT 5 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59387657 ORDER BY `minOrder` ASC [ RunTime:0.004230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59387657 ORDER BY `unit` DESC [ RunTime:0.000927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59387657 LIMIT 2 [ RunTime:0.003717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59387657 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
select * from pdf where partno='0388500000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016031s ]
select foldpath,foldpath2,filename from pdf_file where id=1089204 limit 1 [ RunTime:0.023390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0388500000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013108s ]
SELECT `id` FROM `stock` WHERE `id` <> 59387657 AND `partno` = '0388500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001625s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002920s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007035s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002523s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002381s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003051s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003669s ]
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 '0388%' OR `brand` LIKE '0388%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001266s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0388%' OR `brand` LIKE '0388%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005131s ]