SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001861s ]
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=8499&search=1' [ RunTime:0.004111s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002771s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000681s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002041s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.007726s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001685s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004341s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003511s ]
SELECT * FROM `stock_search` WHERE `partno` = '8499' LIMIT 1 [ RunTime:0.008824s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-19 23:19:36' WHERE `partno` = '8499' [ RunTime:0.008493s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001651s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013360s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19275328 LIMIT 5 [ RunTime:0.011210s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19275328 ORDER BY `minOrder` ASC [ RunTime:0.017778s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19275328 ORDER BY `unit` DESC [ RunTime:0.022838s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19275328 LIMIT 2 [ RunTime:0.022215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19275328 ORDER BY `minOrder` ASC [ RunTime:0.018726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716202 LIMIT 5 [ RunTime:0.033046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716202 ORDER BY `minOrder` ASC [ RunTime:0.021021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18716202 ORDER BY `unit` DESC [ RunTime:0.031413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18716202 LIMIT 2 [ RunTime:0.020262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716202 ORDER BY `minOrder` ASC [ RunTime:0.009056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716186 LIMIT 5 [ RunTime:0.008209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716186 ORDER BY `minOrder` ASC [ RunTime:0.015625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18716186 ORDER BY `unit` DESC [ RunTime:0.006589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18716186 LIMIT 2 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18716186 ORDER BY `minOrder` ASC [ RunTime:0.009180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18708067 LIMIT 5 [ RunTime:0.039113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18708067 ORDER BY `minOrder` ASC [ RunTime:0.016401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18708067 ORDER BY `unit` DESC [ RunTime:0.036704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18708067 LIMIT 2 [ RunTime:0.024477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18708067 ORDER BY `minOrder` ASC [ RunTime:0.004189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16966107 LIMIT 5 [ RunTime:0.026166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16966107 ORDER BY `minOrder` ASC [ RunTime:0.033435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16966107 ORDER BY `unit` DESC [ RunTime:0.020071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16966107 LIMIT 2 [ RunTime:0.052693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16966107 ORDER BY `minOrder` ASC [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394311 LIMIT 5 [ RunTime:0.033001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394311 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394311 ORDER BY `unit` DESC [ RunTime:0.004745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394311 LIMIT 2 [ RunTime:0.020893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394311 ORDER BY `minOrder` ASC [ RunTime:0.018023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553590 LIMIT 5 [ RunTime:0.025181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553590 ORDER BY `minOrder` ASC [ RunTime:0.008564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553590 ORDER BY `unit` DESC [ RunTime:0.014394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553590 LIMIT 2 [ RunTime:0.016975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553590 ORDER BY `minOrder` ASC [ RunTime:0.005652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553552 LIMIT 5 [ RunTime:0.010085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553552 ORDER BY `minOrder` ASC [ RunTime:0.009687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553552 ORDER BY `unit` DESC [ RunTime:0.025769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553552 LIMIT 2 [ RunTime:0.007857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553552 ORDER BY `minOrder` ASC [ RunTime:0.001009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522491 LIMIT 5 [ RunTime:0.003901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522491 ORDER BY `minOrder` ASC [ RunTime:0.015629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522491 ORDER BY `unit` DESC [ RunTime:0.035707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522491 LIMIT 2 [ RunTime:0.027101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522491 ORDER BY `minOrder` ASC [ RunTime:0.001250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12505264 LIMIT 5 [ RunTime:0.017931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12505264 ORDER BY `minOrder` ASC [ RunTime:0.009083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12505264 ORDER BY `unit` DESC [ RunTime:0.010581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12505264 LIMIT 2 [ RunTime:0.026161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12505264 ORDER BY `minOrder` ASC [ RunTime:0.004480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12181272 LIMIT 5 [ RunTime:0.026013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12181272 ORDER BY `minOrder` ASC [ RunTime:0.016372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12181272 ORDER BY `unit` DESC [ RunTime:0.012772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12181272 LIMIT 2 [ RunTime:0.006191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12181272 ORDER BY `minOrder` ASC [ RunTime:0.026367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12180320 LIMIT 5 [ RunTime:0.010699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12180320 ORDER BY `minOrder` ASC [ RunTime:0.032524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12180320 ORDER BY `unit` DESC [ RunTime:0.050904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12180320 LIMIT 2 [ RunTime:0.036153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12180320 ORDER BY `minOrder` ASC [ RunTime:0.009039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193938 LIMIT 5 [ RunTime:0.035706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193938 ORDER BY `minOrder` ASC [ RunTime:0.017621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193938 ORDER BY `unit` DESC [ RunTime:0.008328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193938 LIMIT 2 [ RunTime:0.017671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193938 ORDER BY `minOrder` ASC [ RunTime:0.008753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193173 LIMIT 5 [ RunTime:0.014151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193173 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193173 ORDER BY `unit` DESC [ RunTime:0.014780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193173 LIMIT 2 [ RunTime:0.026025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193173 ORDER BY `minOrder` ASC [ RunTime:0.004961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193039 LIMIT 5 [ RunTime:0.018775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193039 ORDER BY `minOrder` ASC [ RunTime:0.010583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193039 ORDER BY `unit` DESC [ RunTime:0.013836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193039 LIMIT 2 [ RunTime:0.032374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193039 ORDER BY `minOrder` ASC [ RunTime:0.009662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193031 LIMIT 5 [ RunTime:0.024587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193031 ORDER BY `minOrder` ASC [ RunTime:0.008714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193031 ORDER BY `unit` DESC [ RunTime:0.023612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193031 LIMIT 2 [ RunTime:0.017696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193031 ORDER BY `minOrder` ASC [ RunTime:0.000994s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001263s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121217 LIMIT 5 [ RunTime:0.004090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121217 ORDER BY `minOrder` ASC [ RunTime:0.024247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121217 ORDER BY `unit` DESC [ RunTime:0.012837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121217 LIMIT 2 [ RunTime:0.005883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121217 ORDER BY `minOrder` ASC [ RunTime:0.008151s ]
select * from pdf where partno='84998-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014924s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84998-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.048738s ]
SELECT `id` FROM `stock` WHERE `id` <> 62121217 AND `partno` = '84998-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.053714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64529154 LIMIT 5 [ RunTime:0.017545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64529154 ORDER BY `minOrder` ASC [ RunTime:0.030870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64529154 ORDER BY `unit` DESC [ RunTime:0.013168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64529154 LIMIT 2 [ RunTime:0.034358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64529154 ORDER BY `minOrder` ASC [ RunTime:0.024849s ]
select * from pdf where partno='84994' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84994' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001171s ]
SELECT `id` FROM `stock` WHERE `id` <> 64529154 AND `partno` = '84994' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.022650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553590 [ RunTime:0.017139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64529088 LIMIT 5 [ RunTime:0.007463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64529088 ORDER BY `minOrder` ASC [ RunTime:0.005791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64529088 ORDER BY `unit` DESC [ RunTime:0.004182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64529088 LIMIT 2 [ RunTime:0.030702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64529088 ORDER BY `minOrder` ASC [ RunTime:0.014407s ]
select * from pdf where partno='84992' and brandshort='Brady Corporation' limit 1 [ RunTime:0.013132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84992' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.040766s ]
SELECT `id` FROM `stock` WHERE `id` <> 64529088 AND `partno` = '84992' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553552 [ RunTime:0.015631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64510910 LIMIT 5 [ RunTime:0.020354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510910 ORDER BY `minOrder` ASC [ RunTime:0.018717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64510910 ORDER BY `unit` DESC [ RunTime:0.018644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64510910 LIMIT 2 [ RunTime:0.015177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510910 ORDER BY `minOrder` ASC [ RunTime:0.024016s ]
select * from pdf where partno='84993' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84993' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005560s ]
SELECT `id` FROM `stock` WHERE `id` <> 64510910 AND `partno` = '84993' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394311 [ RunTime:0.011043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64510879 LIMIT 5 [ RunTime:0.008663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510879 ORDER BY `minOrder` ASC [ RunTime:0.002773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64510879 ORDER BY `unit` DESC [ RunTime:0.006261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64510879 LIMIT 2 [ RunTime:0.019065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64510879 ORDER BY `minOrder` ASC [ RunTime:0.005766s ]
select * from pdf where partno='84991' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84991' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.019772s ]
SELECT `id` FROM `stock` WHERE `id` <> 64510879 AND `partno` = '84991' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522491 [ RunTime:0.011315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64428136 LIMIT 5 [ RunTime:0.014259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64428136 ORDER BY `minOrder` ASC [ RunTime:0.011717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64428136 ORDER BY `unit` DESC [ RunTime:0.012390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64428136 LIMIT 2 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64428136 ORDER BY `minOrder` ASC [ RunTime:0.015700s ]
select * from pdf where partno='84993' and brandshort='3M' limit 1 [ RunTime:0.008830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84993' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.020132s ]
SELECT `id` FROM `stock` WHERE `id` <> 64428136 AND `partno` = '84993' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.032057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18708067 [ RunTime:0.008929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64427595 LIMIT 5 [ RunTime:0.024794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64427595 ORDER BY `minOrder` ASC [ RunTime:0.021123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64427595 ORDER BY `unit` DESC [ RunTime:0.008709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64427595 LIMIT 2 [ RunTime:0.008835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64427595 ORDER BY `minOrder` ASC [ RunTime:0.007878s ]
select * from pdf where partno='84998' and brandshort='3M' limit 1 [ RunTime:0.034518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84998' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.023619s ]
SELECT `id` FROM `stock` WHERE `id` <> 64427595 AND `partno` = '84998' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.011857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716202 [ RunTime:0.023499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64427569 LIMIT 5 [ RunTime:0.032784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64427569 ORDER BY `minOrder` ASC [ RunTime:0.043054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64427569 ORDER BY `unit` DESC [ RunTime:0.014373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64427569 LIMIT 2 [ RunTime:0.012870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64427569 ORDER BY `minOrder` ASC [ RunTime:0.005498s ]
select * from pdf where partno='84999' and brandshort='3M' limit 1 [ RunTime:0.059251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84999' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.022140s ]
SELECT `id` FROM `stock` WHERE `id` <> 64427569 AND `partno` = '84999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.045660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18716186 [ RunTime:0.036333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63077731 LIMIT 5 [ RunTime:0.047179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63077731 ORDER BY `minOrder` ASC [ RunTime:0.020558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63077731 ORDER BY `unit` DESC [ RunTime:0.037573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63077731 LIMIT 2 [ RunTime:0.050308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63077731 ORDER BY `minOrder` ASC [ RunTime:0.028393s ]
select * from pdf where partno='8499' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.046126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8499' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.066528s ]
SELECT `id` FROM `stock` WHERE `id` <> 63077731 AND `partno` = '8499' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.012590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62122405 LIMIT 5 [ RunTime:0.020812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62122405 ORDER BY `minOrder` ASC [ RunTime:0.020842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62122405 ORDER BY `unit` DESC [ RunTime:0.038742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62122405 LIMIT 2 [ RunTime:0.031594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62122405 ORDER BY `minOrder` ASC [ RunTime:0.036649s ]
select * from pdf where partno='84998-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84998-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007540s ]
SELECT `id` FROM `stock` WHERE `id` <> 62122405 AND `partno` = '84998-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12505264 [ RunTime:0.003553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578971 LIMIT 5 [ RunTime:0.047214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578971 ORDER BY `minOrder` ASC [ RunTime:0.037888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578971 ORDER BY `unit` DESC [ RunTime:0.025470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578971 LIMIT 2 [ RunTime:0.033634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578971 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='84996' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.043740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84996' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.053547s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578971 AND `partno` = '84996' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.063334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12180320 [ RunTime:0.048473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578754 LIMIT 5 [ RunTime:0.024511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578754 ORDER BY `minOrder` ASC [ RunTime:0.053625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578754 ORDER BY `unit` DESC [ RunTime:0.027803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578754 LIMIT 2 [ RunTime:0.046676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578754 ORDER BY `minOrder` ASC [ RunTime:0.017038s ]
select * from pdf where partno='84995' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.016959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84995' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.023827s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578754 AND `partno` = '84995' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.067077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578678 LIMIT 5 [ RunTime:0.015367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578678 ORDER BY `minOrder` ASC [ RunTime:0.033672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578678 ORDER BY `unit` DESC [ RunTime:0.029610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578678 LIMIT 2 [ RunTime:0.051420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578678 ORDER BY `minOrder` ASC [ RunTime:0.012004s ]
select * from pdf where partno='84994' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.035664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84994' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.019078s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578678 AND `partno` = '84994' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.060488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193173 [ RunTime:0.028832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578520 LIMIT 5 [ RunTime:0.075671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578520 ORDER BY `minOrder` ASC [ RunTime:0.070108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578520 ORDER BY `unit` DESC [ RunTime:0.071515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578520 LIMIT 2 [ RunTime:0.038462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578520 ORDER BY `minOrder` ASC [ RunTime:0.018150s ]
select * from pdf where partno='84993' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.053233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84993' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.037212s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578520 AND `partno` = '84993' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.033510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578459 LIMIT 5 [ RunTime:0.028122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578459 ORDER BY `minOrder` ASC [ RunTime:0.019101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578459 ORDER BY `unit` DESC [ RunTime:0.055154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578459 LIMIT 2 [ RunTime:0.038736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578459 ORDER BY `minOrder` ASC [ RunTime:0.002320s ]
select * from pdf where partno='84992' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.018753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84992' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.013032s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578459 AND `partno` = '84992' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.047037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578316 LIMIT 5 [ RunTime:0.023892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578316 ORDER BY `minOrder` ASC [ RunTime:0.016513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578316 ORDER BY `unit` DESC [ RunTime:0.008179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578316 LIMIT 2 [ RunTime:0.014768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578316 ORDER BY `minOrder` ASC [ RunTime:0.002584s ]
select * from pdf where partno='84990' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.038117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84990' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.025852s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578316 AND `partno` = '84990' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.045481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193039 [ RunTime:0.028698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58578294 LIMIT 5 [ RunTime:0.002343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578294 ORDER BY `minOrder` ASC [ RunTime:0.017050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58578294 ORDER BY `unit` DESC [ RunTime:0.020630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58578294 LIMIT 2 [ RunTime:0.013116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58578294 ORDER BY `minOrder` ASC [ RunTime:0.002517s ]
select * from pdf where partno='84991' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.011830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '84991' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.028849s ]
SELECT `id` FROM `stock` WHERE `id` <> 58578294 AND `partno` = '84991' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.033758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193031 [ RunTime:0.046392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58509125 LIMIT 5 [ RunTime:0.016298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58509125 ORDER BY `minOrder` ASC [ RunTime:0.015767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58509125 ORDER BY `unit` DESC [ RunTime:0.009835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58509125 LIMIT 2 [ RunTime:0.040885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58509125 ORDER BY `minOrder` ASC [ RunTime:0.012605s ]
select * from pdf where partno='8499' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.007935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8499' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.033660s ]
SELECT `id` FROM `stock` WHERE `id` <> 58509125 AND `partno` = '8499' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.020611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16966107 [ RunTime:0.002812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43776498 LIMIT 5 [ RunTime:0.015480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43776498 ORDER BY `minOrder` ASC [ RunTime:0.078250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43776498 ORDER BY `unit` DESC [ RunTime:0.039978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43776498 LIMIT 2 [ RunTime:0.028870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43776498 ORDER BY `minOrder` ASC [ RunTime:0.019903s ]
select * from pdf where partno='8499550000' and brandshort='Weidmüller' limit 1 [ RunTime:0.049613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8499550000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016993s ]
SELECT `id` FROM `stock` WHERE `id` <> 43776498 AND `partno` = '8499550000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.009301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19275328 [ RunTime:0.011214s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029586s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041155s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037140s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025114s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056033s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023048s ]
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 '8499%' OR `brand` LIKE '8499%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030854s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8499%' OR `brand` LIKE '8499%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.063223s ]