SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002209s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=3PS-187-2-WT&search=1' [ RunTime:0.002426s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002047s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002132s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.003805s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001404s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.018678s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001857s ]
SELECT * FROM `stock_search` WHERE `partno` = '3PS-187-2-WT' LIMIT 1 [ RunTime:0.010267s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 20:17:10' WHERE `partno` = '3PS-187-2-WT' [ RunTime:0.004216s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002690s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028699s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14402383 LIMIT 5 [ RunTime:0.050756s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14402383 ORDER BY `minOrder` ASC [ RunTime:0.028238s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14402383 ORDER BY `unit` DESC [ RunTime:0.038908s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14402383 LIMIT 2 [ RunTime:0.108946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14402383 ORDER BY `minOrder` ASC [ RunTime:0.006329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532702 LIMIT 5 [ RunTime:0.038056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532702 ORDER BY `minOrder` ASC [ RunTime:0.071760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13532702 ORDER BY `unit` DESC [ RunTime:0.032201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13532702 LIMIT 2 [ RunTime:0.125708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532702 ORDER BY `minOrder` ASC [ RunTime:0.050919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532824 LIMIT 5 [ RunTime:0.075080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532824 ORDER BY `minOrder` ASC [ RunTime:0.082060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13532824 ORDER BY `unit` DESC [ RunTime:0.114929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13532824 LIMIT 2 [ RunTime:0.068064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13532824 ORDER BY `minOrder` ASC [ RunTime:0.055976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16418050 LIMIT 5 [ RunTime:0.037926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16418050 ORDER BY `minOrder` ASC [ RunTime:0.066633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16418050 ORDER BY `unit` DESC [ RunTime:0.114452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16418050 LIMIT 2 [ RunTime:0.112874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16418050 ORDER BY `minOrder` ASC [ RunTime:0.014136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16418045 LIMIT 5 [ RunTime:0.055099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16418045 ORDER BY `minOrder` ASC [ RunTime:0.046889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16418045 ORDER BY `unit` DESC [ RunTime:0.105740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16418045 LIMIT 2 [ RunTime:0.033102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16418045 ORDER BY `minOrder` ASC [ RunTime:0.024154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404513 LIMIT 5 [ RunTime:0.017563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404513 ORDER BY `minOrder` ASC [ RunTime:0.030485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14404513 ORDER BY `unit` DESC [ RunTime:0.023845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14404513 LIMIT 2 [ RunTime:0.037707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404513 ORDER BY `minOrder` ASC [ RunTime:0.011836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404512 LIMIT 5 [ RunTime:0.012932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404512 ORDER BY `minOrder` ASC [ RunTime:0.019213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14404512 ORDER BY `unit` DESC [ RunTime:0.035481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14404512 LIMIT 2 [ RunTime:0.018393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404512 ORDER BY `minOrder` ASC [ RunTime:0.013661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404157 LIMIT 5 [ RunTime:0.027440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404157 ORDER BY `minOrder` ASC [ RunTime:0.032758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14404157 ORDER BY `unit` DESC [ RunTime:0.007438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14404157 LIMIT 2 [ RunTime:0.023739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404157 ORDER BY `minOrder` ASC [ RunTime:0.019856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404156 LIMIT 5 [ RunTime:0.011447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404156 ORDER BY `minOrder` ASC [ RunTime:0.016949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14404156 ORDER BY `unit` DESC [ RunTime:0.041788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14404156 LIMIT 2 [ RunTime:0.006387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404156 ORDER BY `minOrder` ASC [ RunTime:0.026881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13534606 LIMIT 5 [ RunTime:0.044107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534606 ORDER BY `minOrder` ASC [ RunTime:0.030578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13534606 ORDER BY `unit` DESC [ RunTime:0.036827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13534606 LIMIT 2 [ RunTime:0.014305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534606 ORDER BY `minOrder` ASC [ RunTime:0.021075s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010263s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63109293 LIMIT 5 [ RunTime:0.017540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109293 ORDER BY `minOrder` ASC [ RunTime:0.005571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63109293 ORDER BY `unit` DESC [ RunTime:0.001288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63109293 LIMIT 2 [ RunTime:0.023025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109293 ORDER BY `minOrder` ASC [ RunTime:0.007387s ]
select * from pdf where partno='3PS-187-2-WT-S' and brandshort='Brady Corporation' limit 1 [ RunTime:0.047488s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-S' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017707s ]
SELECT `id` FROM `stock` WHERE `id` <> 63109293 AND `partno` = '3PS-187-2-WT-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14402383 [ RunTime:0.007219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63109324 LIMIT 5 [ RunTime:0.011564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109324 ORDER BY `minOrder` ASC [ RunTime:0.011586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63109324 ORDER BY `unit` DESC [ RunTime:0.037384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63109324 LIMIT 2 [ RunTime:0.017917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109324 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
select * from pdf where partno='3PS-187-2-WT-2' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-2' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015362s ]
SELECT `id` FROM `stock` WHERE `id` <> 63109324 AND `partno` = '3PS-187-2-WT-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532702 [ RunTime:0.013090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63109325 LIMIT 5 [ RunTime:0.020632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109325 ORDER BY `minOrder` ASC [ RunTime:0.031624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63109325 ORDER BY `unit` DESC [ RunTime:0.006535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63109325 LIMIT 2 [ RunTime:0.012891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109325 ORDER BY `minOrder` ASC [ RunTime:0.001716s ]
select * from pdf where partno='3PS-187-2-WT' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021001s ]
SELECT `id` FROM `stock` WHERE `id` <> 63109325 AND `partno` = '3PS-187-2-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.042536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13532824 [ RunTime:0.020840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63118351 LIMIT 5 [ RunTime:0.027175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63118351 ORDER BY `minOrder` ASC [ RunTime:0.016572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63118351 ORDER BY `unit` DESC [ RunTime:0.015484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63118351 LIMIT 2 [ RunTime:0.026301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63118351 ORDER BY `minOrder` ASC [ RunTime:0.008049s ]
select * from pdf where partno='3PS-187-2-WT-J' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-J' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007235s ]
SELECT `id` FROM `stock` WHERE `id` <> 63118351 AND `partno` = '3PS-187-2-WT-J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13534606 [ RunTime:0.009353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63117782 LIMIT 5 [ RunTime:0.006191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63117782 ORDER BY `minOrder` ASC [ RunTime:0.037983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63117782 ORDER BY `unit` DESC [ RunTime:0.029454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63117782 LIMIT 2 [ RunTime:0.007111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63117782 ORDER BY `minOrder` ASC [ RunTime:0.008914s ]
select * from pdf where partno='3PS-187-2-WT-3' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-3' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008854s ]
SELECT `id` FROM `stock` WHERE `id` <> 63117782 AND `partno` = '3PS-187-2-WT-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.011253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404513 [ RunTime:0.002539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63117781 LIMIT 5 [ RunTime:0.002146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63117781 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63117781 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63117781 LIMIT 2 [ RunTime:0.004790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63117781 ORDER BY `minOrder` ASC [ RunTime:0.001958s ]
select * from pdf where partno='3PS-187-2-WT-4' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-4' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003628s ]
SELECT `id` FROM `stock` WHERE `id` <> 63117781 AND `partno` = '3PS-187-2-WT-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404512 [ RunTime:0.003448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63116870 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63116870 ORDER BY `minOrder` ASC [ RunTime:0.006551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63116870 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63116870 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63116870 ORDER BY `minOrder` ASC [ RunTime:0.002634s ]
select * from pdf where partno='3PS-187-2-WT-SC' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-SC' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010607s ]
SELECT `id` FROM `stock` WHERE `id` <> 63116870 AND `partno` = '3PS-187-2-WT-SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404157 [ RunTime:0.004503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63116869 LIMIT 5 [ RunTime:0.002110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63116869 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63116869 ORDER BY `unit` DESC [ RunTime:0.012769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63116869 LIMIT 2 [ RunTime:0.009660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63116869 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='3PS-187-2-WT-SC-2' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-SC-2' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001317s ]
SELECT `id` FROM `stock` WHERE `id` <> 63116869 AND `partno` = '3PS-187-2-WT-SC-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404156 [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63115975 LIMIT 5 [ RunTime:0.005890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63115975 ORDER BY `minOrder` ASC [ RunTime:0.002211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63115975 ORDER BY `unit` DESC [ RunTime:0.002360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63115975 LIMIT 2 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63115975 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='3PS-187-2-WT-S-2' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-S-2' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002455s ]
SELECT `id` FROM `stock` WHERE `id` <> 63115975 AND `partno` = '3PS-187-2-WT-S-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16418050 [ RunTime:0.003694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63115946 LIMIT 5 [ RunTime:0.010519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63115946 ORDER BY `minOrder` ASC [ RunTime:0.001624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63115946 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63115946 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63115946 ORDER BY `minOrder` ASC [ RunTime:0.001482s ]
select * from pdf where partno='3PS-187-2-WT-S-4' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3PS-187-2-WT-S-4' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000824s ]
SELECT `id` FROM `stock` WHERE `id` <> 63115946 AND `partno` = '3PS-187-2-WT-S-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16418045 [ RunTime:0.000639s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001273s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003457s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001325s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001141s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001084s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004955s ]
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 '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002812s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3PS-187-2-WT%' OR `brand` LIKE '3PS-187-2-WT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005846s ]