SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001082s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=645-1&search=1' [ RunTime:0.018316s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001464s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007138s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001304s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.009591s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002856s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.031746s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002202s ]
SELECT * FROM `stock_search` WHERE `partno` = '645-1' LIMIT 1 [ RunTime:0.096700s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-30 13:05:06' WHERE `partno` = '645-1' [ RunTime:0.011678s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001708s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064378s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12184204 LIMIT 5 [ RunTime:0.078948s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.022154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12184204 ORDER BY `minOrder` ASC [ RunTime:0.048821s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12184204 ORDER BY `unit` DESC [ RunTime:0.026897s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12184204 LIMIT 2 [ RunTime:0.031483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12184204 ORDER BY `minOrder` ASC [ RunTime:0.010674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183970 LIMIT 5 [ RunTime:0.056457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183970 ORDER BY `minOrder` ASC [ RunTime:0.014842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12183970 ORDER BY `unit` DESC [ RunTime:0.044062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12183970 LIMIT 2 [ RunTime:0.038633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183970 ORDER BY `minOrder` ASC [ RunTime:0.047772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196127 LIMIT 5 [ RunTime:0.029103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196127 ORDER BY `minOrder` ASC [ RunTime:0.051073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11196127 ORDER BY `unit` DESC [ RunTime:0.018755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11196127 LIMIT 2 [ RunTime:0.020106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196127 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196061 LIMIT 5 [ RunTime:0.056940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196061 ORDER BY `minOrder` ASC [ RunTime:0.100114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11196061 ORDER BY `unit` DESC [ RunTime:0.061747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11196061 LIMIT 2 [ RunTime:0.060680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11196061 ORDER BY `minOrder` ASC [ RunTime:0.059725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195875 LIMIT 5 [ RunTime:0.052942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195875 ORDER BY `minOrder` ASC [ RunTime:0.027845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195875 ORDER BY `unit` DESC [ RunTime:0.037479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195875 LIMIT 2 [ RunTime:0.012039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195875 ORDER BY `minOrder` ASC [ RunTime:0.031685s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018857s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725020 LIMIT 5 [ RunTime:0.040356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725020 ORDER BY `minOrder` ASC [ RunTime:0.025348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725020 ORDER BY `unit` DESC [ RunTime:0.065443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725020 LIMIT 2 [ RunTime:0.021801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725020 ORDER BY `minOrder` ASC [ RunTime:0.008683s ]
select * from pdf where partno='645-16-3V' and brandshort='Dwyer' limit 1 [ RunTime:0.045630s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-16-3V' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.012914s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725020 AND `partno` = '645-16-3V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.036526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32730154 [ RunTime:0.018057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725019 LIMIT 5 [ RunTime:0.019969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725019 ORDER BY `minOrder` ASC [ RunTime:0.028704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725019 ORDER BY `unit` DESC [ RunTime:0.035398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725019 LIMIT 2 [ RunTime:0.008018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725019 ORDER BY `minOrder` ASC [ RunTime:0.002694s ]
select * from pdf where partno='645-13-3V' and brandshort='Dwyer' limit 1 [ RunTime:0.013715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-13-3V' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.007245s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725019 AND `partno` = '645-13-3V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.011544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32730153 [ RunTime:0.020600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725018 LIMIT 5 [ RunTime:0.016046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725018 ORDER BY `minOrder` ASC [ RunTime:0.026299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725018 ORDER BY `unit` DESC [ RunTime:0.015087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725018 LIMIT 2 [ RunTime:0.019878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725018 ORDER BY `minOrder` ASC [ RunTime:0.022781s ]
select * from pdf where partno='645-12-3V' and brandshort='Dwyer' limit 1 [ RunTime:0.030934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-12-3V' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.003285s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725018 AND `partno` = '645-12-3V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.006741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32738684 [ RunTime:0.010124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725017 LIMIT 5 [ RunTime:0.005600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725017 ORDER BY `minOrder` ASC [ RunTime:0.005354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725017 ORDER BY `unit` DESC [ RunTime:0.005882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725017 LIMIT 2 [ RunTime:0.001795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725017 ORDER BY `minOrder` ASC [ RunTime:0.008310s ]
select * from pdf where partno='645-1-3V' and brandshort='Dwyer' limit 1 [ RunTime:0.007753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-3V' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.014840s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725017 AND `partno` = '645-1-3V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.002780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32738683 [ RunTime:0.001652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725015 LIMIT 5 [ RunTime:0.007279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725015 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725015 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725015 LIMIT 2 [ RunTime:0.006348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725015 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
select * from pdf where partno='645-14-3V' and brandshort='Dwyer' limit 1 [ RunTime:0.001081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-14-3V' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.002438s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725015 AND `partno` = '645-14-3V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.003062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32738681 [ RunTime:0.011503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64725014 LIMIT 5 [ RunTime:0.006312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725014 ORDER BY `minOrder` ASC [ RunTime:0.012527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64725014 ORDER BY `unit` DESC [ RunTime:0.006029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64725014 LIMIT 2 [ RunTime:0.003203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64725014 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='645-15-3V' and brandshort='Dwyer' limit 1 [ RunTime:0.010541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-15-3V' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.004373s ]
SELECT `id` FROM `stock` WHERE `id` <> 64725014 AND `partno` = '645-15-3V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.006320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32730152 [ RunTime:0.002805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719258 LIMIT 5 [ RunTime:0.001635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719258 ORDER BY `minOrder` ASC [ RunTime:0.001989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719258 ORDER BY `unit` DESC [ RunTime:0.009125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719258 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719258 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='645-16' and brandshort='Dwyer' limit 1 [ RunTime:0.001142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-16' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.002186s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719258 AND `partno` = '645-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.007705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32717211 [ RunTime:0.002754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719252 LIMIT 5 [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719252 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719252 ORDER BY `unit` DESC [ RunTime:0.003071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719252 LIMIT 2 [ RunTime:0.005322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719252 ORDER BY `minOrder` ASC [ RunTime:0.001186s ]
select * from pdf where partno='645-14' and brandshort='Dwyer' limit 1 [ RunTime:0.007152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-14' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.004907s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719252 AND `partno` = '645-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.005764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706767 [ RunTime:0.002065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719251 LIMIT 5 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719251 ORDER BY `minOrder` ASC [ RunTime:0.004057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719251 ORDER BY `unit` DESC [ RunTime:0.010823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719251 LIMIT 2 [ RunTime:0.005145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719251 ORDER BY `minOrder` ASC [ RunTime:0.002932s ]
select * from pdf where partno='645-1' and brandshort='Dwyer' limit 1 [ RunTime:0.003952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.001053s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719251 AND `partno` = '645-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.015563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706766 [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719250 LIMIT 5 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719250 ORDER BY `minOrder` ASC [ RunTime:0.002639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719250 ORDER BY `unit` DESC [ RunTime:0.004494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719250 LIMIT 2 [ RunTime:0.001489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719250 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='645-11' and brandshort='Dwyer' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-11' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.002659s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719250 AND `partno` = '645-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.000839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706765 [ RunTime:0.002564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719249 LIMIT 5 [ RunTime:0.012924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719249 ORDER BY `minOrder` ASC [ RunTime:0.003009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719249 ORDER BY `unit` DESC [ RunTime:0.004323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719249 LIMIT 2 [ RunTime:0.004551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719249 ORDER BY `minOrder` ASC [ RunTime:0.004954s ]
select * from pdf where partno='645-15' and brandshort='Dwyer' limit 1 [ RunTime:0.011170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-15' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.007091s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719249 AND `partno` = '645-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.007557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706764 [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719247 LIMIT 5 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719247 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719247 ORDER BY `unit` DESC [ RunTime:0.002775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719247 LIMIT 2 [ RunTime:0.001308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719247 ORDER BY `minOrder` ASC [ RunTime:0.004985s ]
select * from pdf where partno='645-10' and brandshort='Dwyer' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-10' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.003538s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719247 AND `partno` = '645-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706762 [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719246 LIMIT 5 [ RunTime:0.003145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719246 ORDER BY `minOrder` ASC [ RunTime:0.006652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719246 ORDER BY `unit` DESC [ RunTime:0.001055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719246 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719246 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='645-12' and brandshort='Dwyer' limit 1 [ RunTime:0.003277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-12' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.000717s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719246 AND `partno` = '645-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706761 [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719245 LIMIT 5 [ RunTime:0.010581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719245 ORDER BY `minOrder` ASC [ RunTime:0.023269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719245 ORDER BY `unit` DESC [ RunTime:0.003632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719245 LIMIT 2 [ RunTime:0.006713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719245 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='645-13' and brandshort='Dwyer' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-13' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.002805s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719245 AND `partno` = '645-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.005068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32706760 [ RunTime:0.012481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58551144 LIMIT 5 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58551144 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58551144 ORDER BY `unit` DESC [ RunTime:0.000818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58551144 LIMIT 2 [ RunTime:0.003812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58551144 ORDER BY `minOrder` ASC [ RunTime:0.011178s ]
select * from pdf where partno='645-1-3/4' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.001505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-3/4' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.007201s ]
SELECT `id` FROM `stock` WHERE `id` <> 58551144 AND `partno` = '645-1-3/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.016340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196127 [ RunTime:0.023033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550976 LIMIT 5 [ RunTime:0.026453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550976 ORDER BY `minOrder` ASC [ RunTime:0.004026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550976 ORDER BY `unit` DESC [ RunTime:0.003185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550976 LIMIT 2 [ RunTime:0.017968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550976 ORDER BY `minOrder` ASC [ RunTime:0.006744s ]
select * from pdf where partno='645-1-7/16' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.014600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-7/16' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.022908s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550976 AND `partno` = '645-1-7/16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.009484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11196061 [ RunTime:0.008067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550846 LIMIT 5 [ RunTime:0.041527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550846 ORDER BY `minOrder` ASC [ RunTime:0.016288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550846 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550846 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550846 ORDER BY `minOrder` ASC [ RunTime:0.003818s ]
select * from pdf where partno='645-1-1/2' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.009124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-1/2' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.007087s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550846 AND `partno` = '645-1-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.011390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12184204 [ RunTime:0.018976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550641 LIMIT 5 [ RunTime:0.002488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550641 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550641 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550641 LIMIT 2 [ RunTime:0.003251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550641 ORDER BY `minOrder` ASC [ RunTime:0.001583s ]
select * from pdf where partno='645-1-3/8' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.011549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-3/8' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.019887s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550641 AND `partno` = '645-1-3/8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.011012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550553 LIMIT 5 [ RunTime:0.007658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550553 ORDER BY `minOrder` ASC [ RunTime:0.006701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550553 ORDER BY `unit` DESC [ RunTime:0.009188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550553 LIMIT 2 [ RunTime:0.019822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550553 ORDER BY `minOrder` ASC [ RunTime:0.004905s ]
select * from pdf where partno='645-1-1/4' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.002851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-1/4' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.001329s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550553 AND `partno` = '645-1-1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.007704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195875 [ RunTime:0.006401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58550517 LIMIT 5 [ RunTime:0.002000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550517 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58550517 ORDER BY `unit` DESC [ RunTime:0.000818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58550517 LIMIT 2 [ RunTime:0.005341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58550517 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
select * from pdf where partno='645-1-7/32' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.000909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '645-1-7/32' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.000986s ]
SELECT `id` FROM `stock` WHERE `id` <> 58550517 AND `partno` = '645-1-7/32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.000753s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001068s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004527s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002022s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001069s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012417s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007535s ]
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 '645-1%' OR `brand` LIKE '645-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004057s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '645-1%' OR `brand` LIKE '645-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002619s ]