SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002337s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=U45&search=1' [ RunTime:0.004140s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001759s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001147s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001747s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.000908s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001318s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001495s ]
SELECT * FROM `stock_search` WHERE `partno` = 'U45' LIMIT 1 [ RunTime:0.004686s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-28 14:46:05' WHERE `partno` = 'U45' [ RunTime:0.001669s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001247s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013946s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359480 LIMIT 5 [ RunTime:0.024620s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15359480 ORDER BY `minOrder` ASC [ RunTime:0.001855s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15359480 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15359480 LIMIT 2 [ RunTime:0.009643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15359480 ORDER BY `minOrder` ASC [ RunTime:0.007547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265490 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265490 ORDER BY `minOrder` ASC [ RunTime:0.013112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265490 ORDER BY `unit` DESC [ RunTime:0.009538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265490 LIMIT 2 [ RunTime:0.030920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265490 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265087 LIMIT 5 [ RunTime:0.045974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265087 ORDER BY `minOrder` ASC [ RunTime:0.018631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265087 ORDER BY `unit` DESC [ RunTime:0.011947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265087 LIMIT 2 [ RunTime:0.011384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265087 ORDER BY `minOrder` ASC [ RunTime:0.036264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265227 LIMIT 5 [ RunTime:0.018339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265227 ORDER BY `minOrder` ASC [ RunTime:0.039066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265227 ORDER BY `unit` DESC [ RunTime:0.010424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265227 LIMIT 2 [ RunTime:0.024815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265227 ORDER BY `minOrder` ASC [ RunTime:0.005798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140520 LIMIT 5 [ RunTime:0.002831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140520 ORDER BY `minOrder` ASC [ RunTime:0.017544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17140520 ORDER BY `unit` DESC [ RunTime:0.027038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17140520 LIMIT 2 [ RunTime:0.005989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17140520 ORDER BY `minOrder` ASC [ RunTime:0.011684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535463 LIMIT 5 [ RunTime:0.014252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535463 ORDER BY `minOrder` ASC [ RunTime:0.044973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535463 ORDER BY `unit` DESC [ RunTime:0.042096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535463 LIMIT 2 [ RunTime:0.018663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535463 ORDER BY `minOrder` ASC [ RunTime:0.016287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535462 LIMIT 5 [ RunTime:0.018329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535462 ORDER BY `minOrder` ASC [ RunTime:0.049491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535462 ORDER BY `unit` DESC [ RunTime:0.038842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535462 LIMIT 2 [ RunTime:0.048009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535462 ORDER BY `minOrder` ASC [ RunTime:0.010859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535461 LIMIT 5 [ RunTime:0.015562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535461 ORDER BY `minOrder` ASC [ RunTime:0.012483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535461 ORDER BY `unit` DESC [ RunTime:0.017578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535461 LIMIT 2 [ RunTime:0.016158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535461 ORDER BY `minOrder` ASC [ RunTime:0.008902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535460 LIMIT 5 [ RunTime:0.006894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535460 ORDER BY `minOrder` ASC [ RunTime:0.023836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535460 ORDER BY `unit` DESC [ RunTime:0.009555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535460 LIMIT 2 [ RunTime:0.013159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535460 ORDER BY `minOrder` ASC [ RunTime:0.030354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535459 LIMIT 5 [ RunTime:0.034530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535459 ORDER BY `minOrder` ASC [ RunTime:0.012339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535459 ORDER BY `unit` DESC [ RunTime:0.033979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535459 LIMIT 2 [ RunTime:0.005614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535459 ORDER BY `minOrder` ASC [ RunTime:0.017339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535458 LIMIT 5 [ RunTime:0.004367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535458 ORDER BY `minOrder` ASC [ RunTime:0.032085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535458 ORDER BY `unit` DESC [ RunTime:0.026716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535458 LIMIT 2 [ RunTime:0.055272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535458 ORDER BY `minOrder` ASC [ RunTime:0.019770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535456 LIMIT 5 [ RunTime:0.020999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535456 ORDER BY `minOrder` ASC [ RunTime:0.015429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535456 ORDER BY `unit` DESC [ RunTime:0.023306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535456 LIMIT 2 [ RunTime:0.029701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535456 ORDER BY `minOrder` ASC [ RunTime:0.023752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535128 LIMIT 5 [ RunTime:0.030549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535128 ORDER BY `minOrder` ASC [ RunTime:0.016274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535128 ORDER BY `unit` DESC [ RunTime:0.010882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535128 LIMIT 2 [ RunTime:0.020159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535128 ORDER BY `minOrder` ASC [ RunTime:0.011296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535127 LIMIT 5 [ RunTime:0.015378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535127 ORDER BY `minOrder` ASC [ RunTime:0.019645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535127 ORDER BY `unit` DESC [ RunTime:0.003458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535127 LIMIT 2 [ RunTime:0.010110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535127 ORDER BY `minOrder` ASC [ RunTime:0.003464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535126 LIMIT 5 [ RunTime:0.016738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535126 ORDER BY `minOrder` ASC [ RunTime:0.042220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535126 ORDER BY `unit` DESC [ RunTime:0.025289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535126 LIMIT 2 [ RunTime:0.025240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535126 ORDER BY `minOrder` ASC [ RunTime:0.004621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535125 LIMIT 5 [ RunTime:0.022879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535125 ORDER BY `minOrder` ASC [ RunTime:0.010809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535125 ORDER BY `unit` DESC [ RunTime:0.011414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535125 LIMIT 2 [ RunTime:0.009496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535125 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535124 LIMIT 5 [ RunTime:0.009427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535124 ORDER BY `minOrder` ASC [ RunTime:0.006048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535124 ORDER BY `unit` DESC [ RunTime:0.006324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535124 LIMIT 2 [ RunTime:0.023913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535124 ORDER BY `minOrder` ASC [ RunTime:0.003512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535121 LIMIT 5 [ RunTime:0.009728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535121 ORDER BY `minOrder` ASC [ RunTime:0.015950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19535121 ORDER BY `unit` DESC [ RunTime:0.013308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19535121 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19535121 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531429 LIMIT 5 [ RunTime:0.004786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531429 ORDER BY `minOrder` ASC [ RunTime:0.011721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19531429 ORDER BY `unit` DESC [ RunTime:0.028838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19531429 LIMIT 2 [ RunTime:0.011151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531429 ORDER BY `minOrder` ASC [ RunTime:0.005986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531419 LIMIT 5 [ RunTime:0.005485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531419 ORDER BY `minOrder` ASC [ RunTime:0.010589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19531419 ORDER BY `unit` DESC [ RunTime:0.003920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19531419 LIMIT 2 [ RunTime:0.019284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531419 ORDER BY `minOrder` ASC [ RunTime:0.015387s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51083382 LIMIT 5 [ RunTime:0.018268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083382 ORDER BY `minOrder` ASC [ RunTime:0.006231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51083382 ORDER BY `unit` DESC [ RunTime:0.015354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51083382 LIMIT 2 [ RunTime:0.017085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51083382 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
select * from pdf where partno='u4536' and brandshort='apem' limit 1 [ RunTime:0.014047s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u4536' OR `brand` LIKE 'apem%' ) ) LIMIT 1 [ RunTime:0.023086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310674 LIMIT 5 [ RunTime:0.011976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310674 ORDER BY `minOrder` ASC [ RunTime:0.032697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32310674 ORDER BY `unit` DESC [ RunTime:0.027532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32310674 LIMIT 2 [ RunTime:0.022095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310674 ORDER BY `minOrder` ASC [ RunTime:0.004604s ]
select * from pdf where partno='u457-025-ag2' and brandshort='tripp lite' limit 1 [ RunTime:0.044088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u457-025-ag2' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.048398s ]
SELECT `id` FROM `stock` WHERE `id` <> 32310674 AND `partno` = 'u457-025-ag2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.025702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265087 [ RunTime:0.041388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082227 LIMIT 5 [ RunTime:0.031663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082227 ORDER BY `minOrder` ASC [ RunTime:0.030509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082227 ORDER BY `unit` DESC [ RunTime:0.008574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082227 LIMIT 2 [ RunTime:0.001439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082227 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
select * from pdf where partno='u452-000-sd-a' and brandshort='tripp lite' limit 1 [ RunTime:0.008128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'u452-000-sd-a' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.000830s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082227 AND `partno` = 'u452-000-sd-a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.028204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359480 [ RunTime:0.004579s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57440844 LIMIT 5 [ RunTime:0.029030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57440844 ORDER BY `minOrder` ASC [ RunTime:0.015327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57440844 ORDER BY `unit` DESC [ RunTime:0.036667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57440844 LIMIT 2 [ RunTime:0.036507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57440844 ORDER BY `minOrder` ASC [ RunTime:0.030577s ]
select * from pdf where partno='U452-000-SD-A' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.044578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U452-000-SD-A' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.027625s ]
SELECT `id` FROM `stock` WHERE `id` <> 57440844 AND `partno` = 'U452-000-SD-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.028356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359480 [ RunTime:0.027729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438172 LIMIT 5 [ RunTime:0.019773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438172 ORDER BY `minOrder` ASC [ RunTime:0.038767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438172 ORDER BY `unit` DESC [ RunTime:0.023777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438172 LIMIT 2 [ RunTime:0.015530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438172 ORDER BY `minOrder` ASC [ RunTime:0.020301s ]
select * from pdf where partno='U457-1M2-NVME-L' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.024198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U457-1M2-NVME-L' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.042438s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438172 AND `partno` = 'U457-1M2-NVME-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.018135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265490 [ RunTime:0.033457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57435672 LIMIT 5 [ RunTime:0.018372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57435672 ORDER BY `minOrder` ASC [ RunTime:0.041079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57435672 ORDER BY `unit` DESC [ RunTime:0.025532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57435672 LIMIT 2 [ RunTime:0.022501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57435672 ORDER BY `minOrder` ASC [ RunTime:0.016533s ]
select * from pdf where partno='U457-025-G1-WPG' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.032560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U457-025-G1-WPG' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.012317s ]
SELECT `id` FROM `stock` WHERE `id` <> 57435672 AND `partno` = 'U457-025-G1-WPG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.008655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265227 [ RunTime:0.015827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57435944 LIMIT 5 [ RunTime:0.016410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57435944 ORDER BY `minOrder` ASC [ RunTime:0.007609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57435944 ORDER BY `unit` DESC [ RunTime:0.003156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57435944 LIMIT 2 [ RunTime:0.034419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57435944 ORDER BY `minOrder` ASC [ RunTime:0.007196s ]
select * from pdf where partno='U457-025-AG2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.017707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U457-025-AG2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.004005s ]
SELECT `id` FROM `stock` WHERE `id` <> 57435944 AND `partno` = 'U457-025-AG2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.006823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265087 [ RunTime:0.005158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57440868 LIMIT 5 [ RunTime:0.006120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57440868 ORDER BY `minOrder` ASC [ RunTime:0.022231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57440868 ORDER BY `unit` DESC [ RunTime:0.008928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57440868 LIMIT 2 [ RunTime:0.015033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57440868 ORDER BY `minOrder` ASC [ RunTime:0.014685s ]
select * from pdf where partno='U452-003' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.019857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U452-003' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.007192s ]
SELECT `id` FROM `stock` WHERE `id` <> 57440868 AND `partno` = 'U452-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.032753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359487 [ RunTime:0.038092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57436673 LIMIT 5 [ RunTime:0.019397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57436673 ORDER BY `minOrder` ASC [ RunTime:0.013142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57436673 ORDER BY `unit` DESC [ RunTime:0.022094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57436673 LIMIT 2 [ RunTime:0.029644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57436673 ORDER BY `minOrder` ASC [ RunTime:0.019001s ]
select * from pdf where partno='U457-1M2-SATAG2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.024186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U457-1M2-SATAG2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.024400s ]
SELECT `id` FROM `stock` WHERE `id` <> 57436673 AND `partno` = 'U457-1M2-SATAG2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.017230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264087 [ RunTime:0.010730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57436537 LIMIT 5 [ RunTime:0.014875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57436537 ORDER BY `minOrder` ASC [ RunTime:0.010786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57436537 ORDER BY `unit` DESC [ RunTime:0.023083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57436537 LIMIT 2 [ RunTime:0.018117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57436537 ORDER BY `minOrder` ASC [ RunTime:0.016831s ]
select * from pdf where partno='U457-2M2-SATAG2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.013506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U457-2M2-SATAG2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.047647s ]
SELECT `id` FROM `stock` WHERE `id` <> 57436537 AND `partno` = 'U457-2M2-SATAG2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.022759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359931 [ RunTime:0.023762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57436409 LIMIT 5 [ RunTime:0.029554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57436409 ORDER BY `minOrder` ASC [ RunTime:0.009362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57436409 ORDER BY `unit` DESC [ RunTime:0.007811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57436409 LIMIT 2 [ RunTime:0.011371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57436409 ORDER BY `minOrder` ASC [ RunTime:0.007528s ]
select * from pdf where partno='U457-025-CG2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.026218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U457-025-CG2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.010323s ]
SELECT `id` FROM `stock` WHERE `id` <> 57436409 AND `partno` = 'U457-025-CG2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.010143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19263934 [ RunTime:0.007092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51596313 LIMIT 5 [ RunTime:0.031687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51596313 ORDER BY `minOrder` ASC [ RunTime:0.035706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51596313 ORDER BY `unit` DESC [ RunTime:0.013981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51596313 LIMIT 2 [ RunTime:0.017555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51596313 ORDER BY `minOrder` ASC [ RunTime:0.008467s ]
select * from pdf where partno='U454638MM' and brandshort='APEM Inc.' limit 1 [ RunTime:0.052455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U454638MM' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.008985s ]
SELECT `id` FROM `stock` WHERE `id` <> 51596313 AND `partno` = 'U454638MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.044973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531429 [ RunTime:0.030190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51596299 LIMIT 5 [ RunTime:0.017945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51596299 ORDER BY `minOrder` ASC [ RunTime:0.011876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51596299 ORDER BY `unit` DESC [ RunTime:0.011635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51596299 LIMIT 2 [ RunTime:0.017694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51596299 ORDER BY `minOrder` ASC [ RunTime:0.006723s ]
select * from pdf where partno='U4546' and brandshort='APEM Inc.' limit 1 [ RunTime:0.013002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4546' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.020845s ]
SELECT `id` FROM `stock` WHERE `id` <> 51596299 AND `partno` = 'U4546' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.019288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531419 [ RunTime:0.004939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463882 LIMIT 5 [ RunTime:0.007005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463882 ORDER BY `minOrder` ASC [ RunTime:0.014138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463882 ORDER BY `unit` DESC [ RunTime:0.025861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463882 LIMIT 2 [ RunTime:0.024662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463882 ORDER BY `minOrder` ASC [ RunTime:0.025947s ]
select * from pdf where partno='U45' and brandshort='APEM Inc.' limit 1 [ RunTime:0.012543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U45' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.013898s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463882 AND `partno` = 'U45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.012716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15433359 [ RunTime:0.015862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463855 LIMIT 5 [ RunTime:0.011904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463855 ORDER BY `minOrder` ASC [ RunTime:0.015176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463855 ORDER BY `unit` DESC [ RunTime:0.019469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463855 LIMIT 2 [ RunTime:0.013354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463855 ORDER BY `minOrder` ASC [ RunTime:0.003194s ]
select * from pdf where partno='U4527' and brandshort='APEM Inc.' limit 1 [ RunTime:0.009788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4527' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.003975s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463855 AND `partno` = 'U4527' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.013128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535463 [ RunTime:0.008673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463854 LIMIT 5 [ RunTime:0.027187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463854 ORDER BY `minOrder` ASC [ RunTime:0.032261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463854 ORDER BY `unit` DESC [ RunTime:0.008257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463854 LIMIT 2 [ RunTime:0.042261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463854 ORDER BY `minOrder` ASC [ RunTime:0.018062s ]
select * from pdf where partno='U4523' and brandshort='APEM Inc.' limit 1 [ RunTime:0.013086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4523' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.007181s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463854 AND `partno` = 'U4523' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.016594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535462 [ RunTime:0.018761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463853 LIMIT 5 [ RunTime:0.029334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463853 ORDER BY `minOrder` ASC [ RunTime:0.009489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463853 ORDER BY `unit` DESC [ RunTime:0.014415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463853 LIMIT 2 [ RunTime:0.004888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463853 ORDER BY `minOrder` ASC [ RunTime:0.016530s ]
select * from pdf where partno='U4521' and brandshort='APEM Inc.' limit 1 [ RunTime:0.013698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4521' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.015451s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463853 AND `partno` = 'U4521' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.013998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535461 [ RunTime:0.029355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463852 LIMIT 5 [ RunTime:0.023073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463852 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463852 ORDER BY `unit` DESC [ RunTime:0.015470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463852 LIMIT 2 [ RunTime:0.013888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463852 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
select * from pdf where partno='U4525' and brandshort='APEM Inc.' limit 1 [ RunTime:0.017545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4525' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.015439s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463852 AND `partno` = 'U4525' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.014856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535460 [ RunTime:0.010609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463851 LIMIT 5 [ RunTime:0.001846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463851 ORDER BY `minOrder` ASC [ RunTime:0.014293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463851 ORDER BY `unit` DESC [ RunTime:0.014404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463851 LIMIT 2 [ RunTime:0.016309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463851 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
select * from pdf where partno='U4524' and brandshort='APEM Inc.' limit 1 [ RunTime:0.003842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4524' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.008967s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463851 AND `partno` = 'U4524' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.014890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535459 [ RunTime:0.010644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463850 LIMIT 5 [ RunTime:0.001873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463850 ORDER BY `minOrder` ASC [ RunTime:0.005593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463850 ORDER BY `unit` DESC [ RunTime:0.000496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463850 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463850 ORDER BY `minOrder` ASC [ RunTime:0.007196s ]
select * from pdf where partno='U4526' and brandshort='APEM Inc.' limit 1 [ RunTime:0.025756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4526' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.006313s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463850 AND `partno` = 'U4526' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.014555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535458 [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463849 LIMIT 5 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463849 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463849 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463849 LIMIT 2 [ RunTime:0.006904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463849 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='U4522' and brandshort='APEM Inc.' limit 1 [ RunTime:0.000644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4522' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.006255s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463849 AND `partno` = 'U4522' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.004425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535456 [ RunTime:0.021284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463327 LIMIT 5 [ RunTime:0.004564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463327 ORDER BY `minOrder` ASC [ RunTime:0.019227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463327 ORDER BY `unit` DESC [ RunTime:0.007453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463327 LIMIT 2 [ RunTime:0.005437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463327 ORDER BY `minOrder` ASC [ RunTime:0.001807s ]
select * from pdf where partno='U4536' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4536' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.000702s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463327 AND `partno` = 'U4536' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.015797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535128 [ RunTime:0.005048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51463326 LIMIT 5 [ RunTime:0.013807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463326 ORDER BY `minOrder` ASC [ RunTime:0.008958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51463326 ORDER BY `unit` DESC [ RunTime:0.005182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51463326 LIMIT 2 [ RunTime:0.003754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51463326 ORDER BY `minOrder` ASC [ RunTime:0.003838s ]
select * from pdf where partno='U4537' and brandshort='APEM Inc.' limit 1 [ RunTime:0.012631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'U4537' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.000600s ]
SELECT `id` FROM `stock` WHERE `id` <> 51463326 AND `partno` = 'U4537' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19535127 [ RunTime:0.001389s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003393s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003068s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001133s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002399s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002131s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006467s ]
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 'U45%' OR `brand` LIKE 'U45%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001461s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'U45%' OR `brand` LIKE 'U45%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000783s ]