SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001601s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.87' , `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=CJT&search=1' [ RunTime:0.007079s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001740s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007566s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001636s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.87' ) [ RunTime:0.003748s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002048s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005812s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001267s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CJT' LIMIT 1 [ RunTime:0.017540s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-18 08:44:01' WHERE `partno` = 'CJT' [ RunTime:0.022412s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001477s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032085s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.022128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880372 LIMIT 5 [ RunTime:0.012447s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880372 ORDER BY `minOrder` ASC [ RunTime:0.025384s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880372 ORDER BY `unit` DESC [ RunTime:0.026417s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880372 LIMIT 2 [ RunTime:0.023636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880372 ORDER BY `minOrder` ASC [ RunTime:0.011833s ]
select * from pdf where partno='CJT-T-P-HH-ST-TH1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071703 LIMIT 5 [ RunTime:0.016667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071703 ORDER BY `minOrder` ASC [ RunTime:0.041013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071703 ORDER BY `unit` DESC [ RunTime:0.019583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071703 LIMIT 2 [ RunTime:0.055672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071703 ORDER BY `minOrder` ASC [ RunTime:0.007920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13194205 LIMIT 5 [ RunTime:0.031496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13194205 ORDER BY `minOrder` ASC [ RunTime:0.012489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13194205 ORDER BY `unit` DESC [ RunTime:0.020019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13194205 LIMIT 2 [ RunTime:0.020509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13194205 ORDER BY `minOrder` ASC [ RunTime:0.014372s ]
select * from pdf where partno='CJT' and brandshort='Panduit Corp' limit 1 [ RunTime:0.013860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354050 LIMIT 5 [ RunTime:0.017716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354050 ORDER BY `minOrder` ASC [ RunTime:0.025669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354050 ORDER BY `unit` DESC [ RunTime:0.014197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354050 LIMIT 2 [ RunTime:0.018986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354050 ORDER BY `minOrder` ASC [ RunTime:0.009620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072021 LIMIT 5 [ RunTime:0.011791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072021 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072021 ORDER BY `unit` DESC [ RunTime:0.014244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072021 LIMIT 2 [ RunTime:0.007067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072021 ORDER BY `minOrder` ASC [ RunTime:0.002210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071958 LIMIT 5 [ RunTime:0.006966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071958 ORDER BY `minOrder` ASC [ RunTime:0.019047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071958 ORDER BY `unit` DESC [ RunTime:0.015875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071958 LIMIT 2 [ RunTime:0.012403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071958 ORDER BY `minOrder` ASC [ RunTime:0.021314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17880386 LIMIT 5 [ RunTime:0.036078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17880386 ORDER BY `minOrder` ASC [ RunTime:0.022505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17880386 ORDER BY `unit` DESC [ RunTime:0.009054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17880386 LIMIT 2 [ RunTime:0.025872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17880386 ORDER BY `minOrder` ASC [ RunTime:0.011196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20126110 LIMIT 5 [ RunTime:0.020453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20126110 ORDER BY `minOrder` ASC [ RunTime:0.036204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20126110 ORDER BY `unit` DESC [ RunTime:0.001143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20126110 LIMIT 2 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20126110 ORDER BY `minOrder` ASC [ RunTime:0.010952s ]
select * from pdf where partno='A2541WV-4P' and brandshort='CJT' limit 1 [ RunTime:0.023638s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.029696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20125826 LIMIT 5 [ RunTime:0.007264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20125826 ORDER BY `minOrder` ASC [ RunTime:0.006247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20125826 ORDER BY `unit` DESC [ RunTime:0.036657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20125826 LIMIT 2 [ RunTime:0.010652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20125826 ORDER BY `minOrder` ASC [ RunTime:0.007233s ]
select * from pdf where partno='A2541WV-2P' and brandshort='CJT' limit 1 [ RunTime:0.013010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2541WV-2P' OR `brand` LIKE 'CJT(长江连接 器%' ) ) LIMIT 1 [ RunTime:0.041945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072034 LIMIT 5 [ RunTime:0.009597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072034 ORDER BY `minOrder` ASC [ RunTime:0.009687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072034 ORDER BY `unit` DESC [ RunTime:0.014844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072034 LIMIT 2 [ RunTime:0.022282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072034 ORDER BY `minOrder` ASC [ RunTime:0.024760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072033 LIMIT 5 [ RunTime:0.029055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072033 ORDER BY `minOrder` ASC [ RunTime:0.043799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072033 ORDER BY `unit` DESC [ RunTime:0.030124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072033 LIMIT 2 [ RunTime:0.015144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072033 ORDER BY `minOrder` ASC [ RunTime:0.001351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072032 LIMIT 5 [ RunTime:0.006361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072032 ORDER BY `minOrder` ASC [ RunTime:0.012347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072032 ORDER BY `unit` DESC [ RunTime:0.003738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072032 LIMIT 2 [ RunTime:0.009415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072032 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072031 LIMIT 5 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072031 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072031 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072031 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072031 ORDER BY `minOrder` ASC [ RunTime:0.002205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072019 LIMIT 5 [ RunTime:0.009548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072019 ORDER BY `minOrder` ASC [ RunTime:0.011686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072019 ORDER BY `unit` DESC [ RunTime:0.000594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072019 LIMIT 2 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072019 ORDER BY `minOrder` ASC [ RunTime:0.002461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072018 LIMIT 5 [ RunTime:0.010846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072018 ORDER BY `minOrder` ASC [ RunTime:0.029540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072018 ORDER BY `unit` DESC [ RunTime:0.013017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072018 LIMIT 2 [ RunTime:0.009644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072018 ORDER BY `minOrder` ASC [ RunTime:0.008451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072017 LIMIT 5 [ RunTime:0.013795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072017 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072017 ORDER BY `unit` DESC [ RunTime:0.005290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072017 LIMIT 2 [ RunTime:0.008137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072017 ORDER BY `minOrder` ASC [ RunTime:0.003345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072010 LIMIT 5 [ RunTime:0.011128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072010 ORDER BY `minOrder` ASC [ RunTime:0.008427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072010 ORDER BY `unit` DESC [ RunTime:0.009862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072010 LIMIT 2 [ RunTime:0.013624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072010 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072009 LIMIT 5 [ RunTime:0.001662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072009 ORDER BY `minOrder` ASC [ RunTime:0.005874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072009 ORDER BY `unit` DESC [ RunTime:0.008576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072009 LIMIT 2 [ RunTime:0.008638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072009 ORDER BY `minOrder` ASC [ RunTime:0.004729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17886691 LIMIT 5 [ RunTime:0.013626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17886691 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17886691 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17886691 LIMIT 2 [ RunTime:0.005735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17886691 ORDER BY `minOrder` ASC [ RunTime:0.007560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17886686 LIMIT 5 [ RunTime:0.009504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17886686 ORDER BY `minOrder` ASC [ RunTime:0.002128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17886686 ORDER BY `unit` DESC [ RunTime:0.013188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17886686 LIMIT 2 [ RunTime:0.006851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17886686 ORDER BY `minOrder` ASC [ RunTime:0.012232s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279780 LIMIT 5 [ RunTime:0.002815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279780 ORDER BY `minOrder` ASC [ RunTime:0.000896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279780 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279780 LIMIT 2 [ RunTime:0.003527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279780 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='cjt5e88tgbl' and brandshort='panduit' limit 1 [ RunTime:0.005746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'cjt5e88tgbl' OR `brand` LIKE 'panduit%' ) ) LIMIT 1 [ RunTime:0.005481s ]
SELECT `id` FROM `stock` WHERE `id` <> 32279780 AND `partno` = 'cjt5e88tgbl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit%' ) [ RunTime:0.000958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369803 [ RunTime:0.000962s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908598 LIMIT 5 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908598 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908598 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908598 LIMIT 2 [ RunTime:0.003387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908598 ORDER BY `minOrder` ASC [ RunTime:0.003471s ]
select * from pdf where partno='CJT-T-P-HH-ST-TH1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT-T-P-HH-ST-TH1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908687 LIMIT 5 [ RunTime:0.018255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908687 ORDER BY `minOrder` ASC [ RunTime:0.028819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908687 ORDER BY `unit` DESC [ RunTime:0.007227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908687 LIMIT 2 [ RunTime:0.022591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908687 ORDER BY `minOrder` ASC [ RunTime:0.013776s ]
select * from pdf where partno='CJT-T-P-HH-RA-BH1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT-T-P-HH-RA-BH1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002539s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908687 AND `partno` = 'CJT-T-P-HH-RA-BH1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61908615 LIMIT 5 [ RunTime:0.026204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908615 ORDER BY `minOrder` ASC [ RunTime:0.007404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61908615 ORDER BY `unit` DESC [ RunTime:0.019195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61908615 LIMIT 2 [ RunTime:0.045988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61908615 ORDER BY `minOrder` ASC [ RunTime:0.007030s ]
select * from pdf where partno='CJT-T-P-HH-RA-TH1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT-T-P-HH-RA-TH1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007731s ]
SELECT `id` FROM `stock` WHERE `id` <> 61908615 AND `partno` = 'CJT-T-P-HH-RA-TH1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418894 LIMIT 5 [ RunTime:0.007683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418894 ORDER BY `minOrder` ASC [ RunTime:0.033488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418894 ORDER BY `unit` DESC [ RunTime:0.013757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418894 LIMIT 2 [ RunTime:0.013625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418894 ORDER BY `minOrder` ASC [ RunTime:0.004537s ]
select * from pdf where partno='CJT688TGWH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT688TGWH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.010566s ]
SELECT `id` FROM `stock` WHERE `id` <> 60418894 AND `partno` = 'CJT688TGWH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.006929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071703 [ RunTime:0.003125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419104 LIMIT 5 [ RunTime:0.008426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419104 ORDER BY `minOrder` ASC [ RunTime:0.008965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419104 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419104 LIMIT 2 [ RunTime:0.002546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419104 ORDER BY `minOrder` ASC [ RunTime:0.007249s ]
select * from pdf where partno='CJT688TGBU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT688TGBU' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.009729s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419104 AND `partno` = 'CJT688TGBU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.008526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354050 [ RunTime:0.001253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60998769 LIMIT 5 [ RunTime:0.001747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60998769 ORDER BY `minOrder` ASC [ RunTime:0.003488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60998769 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60998769 LIMIT 2 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60998769 ORDER BY `minOrder` ASC [ RunTime:0.010238s ]
select * from pdf where partno='CJT' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.016471s ]
SELECT `id` FROM `stock` WHERE `id` <> 60998769 AND `partno` = 'CJT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13194205 [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546932 LIMIT 5 [ RunTime:0.003255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546932 ORDER BY `minOrder` ASC [ RunTime:0.000945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546932 ORDER BY `unit` DESC [ RunTime:0.000786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546932 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546932 ORDER BY `minOrder` ASC [ RunTime:0.006348s ]
select * from pdf where partno='CJT-X' and brandshort='Panduit Corp' limit 1 [ RunTime:0.012854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT-X' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004562s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546932 AND `partno` = 'CJT-X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.008079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182399 [ RunTime:0.016562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419647 LIMIT 5 [ RunTime:0.003031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419647 ORDER BY `minOrder` ASC [ RunTime:0.016239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419647 ORDER BY `unit` DESC [ RunTime:0.009599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419647 LIMIT 2 [ RunTime:0.028661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419647 ORDER BY `minOrder` ASC [ RunTime:0.003071s ]
select * from pdf where partno='CJT688TGBL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT688TGBL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.038738s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419647 AND `partno` = 'CJT688TGBL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.011153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072021 [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419484 LIMIT 5 [ RunTime:0.009399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419484 ORDER BY `minOrder` ASC [ RunTime:0.004852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419484 ORDER BY `unit` DESC [ RunTime:0.011885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419484 LIMIT 2 [ RunTime:0.008744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419484 ORDER BY `minOrder` ASC [ RunTime:0.008984s ]
select * from pdf where partno='CJT688TGIW' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT688TGIW' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000894s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419484 AND `partno` = 'CJT688TGIW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071958 [ RunTime:0.001863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61929004 LIMIT 5 [ RunTime:0.010024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61929004 ORDER BY `minOrder` ASC [ RunTime:0.005086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61929004 ORDER BY `unit` DESC [ RunTime:0.000791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61929004 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61929004 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
select * from pdf where partno='CJT-T-P-GF-RA-BH1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT-T-P-GF-RA-BH1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005739s ]
SELECT `id` FROM `stock` WHERE `id` <> 61929004 AND `partno` = 'CJT-T-P-GF-RA-BH1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12876361 [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60425505 LIMIT 5 [ RunTime:0.006307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60425505 ORDER BY `minOrder` ASC [ RunTime:0.009164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60425505 ORDER BY `unit` DESC [ RunTime:0.001998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60425505 LIMIT 2 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60425505 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='CJT6X88TGWH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGWH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001103s ]
SELECT `id` FROM `stock` WHERE `id` <> 60425505 AND `partno` = 'CJT6X88TGWH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369552 [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419679 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419679 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419679 ORDER BY `unit` DESC [ RunTime:0.000659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419679 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419679 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
select * from pdf where partno='CJT6X88TGEI' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGEI' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001563s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419679 AND `partno` = 'CJT6X88TGEI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354269 [ RunTime:0.001170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419678 LIMIT 5 [ RunTime:0.008918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419678 ORDER BY `minOrder` ASC [ RunTime:0.003332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419678 ORDER BY `unit` DESC [ RunTime:0.007615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419678 LIMIT 2 [ RunTime:0.002951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419678 ORDER BY `minOrder` ASC [ RunTime:0.004745s ]
select * from pdf where partno='CJT6X88TGAW' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGAW' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003131s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419678 AND `partno` = 'CJT6X88TGAW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.001360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072031 [ RunTime:0.002013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419676 LIMIT 5 [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419676 ORDER BY `minOrder` ASC [ RunTime:0.008120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419676 ORDER BY `unit` DESC [ RunTime:0.013678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419676 LIMIT 2 [ RunTime:0.002153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419676 ORDER BY `minOrder` ASC [ RunTime:0.002643s ]
select * from pdf where partno='CJT6X88TGBL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGBL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003818s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419676 AND `partno` = 'CJT6X88TGBL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072032 [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419675 LIMIT 5 [ RunTime:0.009071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419675 ORDER BY `minOrder` ASC [ RunTime:0.003378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419675 ORDER BY `unit` DESC [ RunTime:0.000917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419675 LIMIT 2 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419675 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='CJT6X88TGVL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.004916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGVL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.006024s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419675 AND `partno` = 'CJT6X88TGVL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.005157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354271 [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419674 LIMIT 5 [ RunTime:0.004669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419674 ORDER BY `minOrder` ASC [ RunTime:0.003505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419674 ORDER BY `unit` DESC [ RunTime:0.006770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419674 LIMIT 2 [ RunTime:0.010964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419674 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='CJT6X88TGRD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGRD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005364s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419674 AND `partno` = 'CJT6X88TGRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354270 [ RunTime:0.001451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419673 LIMIT 5 [ RunTime:0.012504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419673 ORDER BY `minOrder` ASC [ RunTime:0.002436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419673 ORDER BY `unit` DESC [ RunTime:0.012645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419673 LIMIT 2 [ RunTime:0.007514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419673 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='CJT6X88TGIW' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGIW' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003226s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419673 AND `partno` = 'CJT6X88TGIW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.003816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369813 [ RunTime:0.021364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419670 LIMIT 5 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419670 ORDER BY `minOrder` ASC [ RunTime:0.003861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419670 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419670 LIMIT 2 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419670 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='CJT6X88TGIG' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGIG' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000950s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419670 AND `partno` = 'CJT6X88TGIG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369812 [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419669 LIMIT 5 [ RunTime:0.007129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419669 ORDER BY `minOrder` ASC [ RunTime:0.005049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419669 ORDER BY `unit` DESC [ RunTime:0.025772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419669 LIMIT 2 [ RunTime:0.017563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419669 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='CJT6X88TGYL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.001399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGYL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007054s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419669 AND `partno` = 'CJT6X88TGYL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.004417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354272 [ RunTime:0.003166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419668 LIMIT 5 [ RunTime:0.011057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419668 ORDER BY `minOrder` ASC [ RunTime:0.002537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419668 ORDER BY `unit` DESC [ RunTime:0.005666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419668 LIMIT 2 [ RunTime:0.004747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419668 ORDER BY `minOrder` ASC [ RunTime:0.002721s ]
select * from pdf where partno='CJT6X88TGBU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CJT6X88TGBU' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001461s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419668 AND `partno` = 'CJT6X88TGBU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.013202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072033 [ RunTime:0.002704s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000772s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006919s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012063s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007909s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013861s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021341s ]
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 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019070 LIMIT 5 [ RunTime:0.020732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019070 ORDER BY `minOrder` ASC [ RunTime:0.022459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019070 ORDER BY `unit` DESC [ RunTime:0.014715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019070 LIMIT 2 [ RunTime:0.016828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019070 ORDER BY `minOrder` ASC [ RunTime:0.008989s ]
select * from pdf where partno='A2006-TP' and brandshort='CJT' limit 1 [ RunTime:0.034345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2006-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.022246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019071 LIMIT 5 [ RunTime:0.019443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019071 ORDER BY `minOrder` ASC [ RunTime:0.016884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019071 ORDER BY `unit` DESC [ RunTime:0.033126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019071 LIMIT 2 [ RunTime:0.023157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019071 ORDER BY `minOrder` ASC [ RunTime:0.024261s ]
select * from pdf where partno='A2008-TP-A' and brandshort='CJT' limit 1 [ RunTime:0.018991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2008-TP-A' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.072488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018874 LIMIT 5 [ RunTime:0.028144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018874 ORDER BY `minOrder` ASC [ RunTime:0.076554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018874 ORDER BY `unit` DESC [ RunTime:0.072154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018874 LIMIT 2 [ RunTime:0.135191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018874 ORDER BY `minOrder` ASC [ RunTime:0.068725s ]
select * from pdf where partno='A1257-TP' and brandshort='CJT' limit 1 [ RunTime:0.088840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1257-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.037493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014347 LIMIT 5 [ RunTime:0.050118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014347 ORDER BY `minOrder` ASC [ RunTime:0.107323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014347 ORDER BY `unit` DESC [ RunTime:0.048891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014347 LIMIT 2 [ RunTime:0.166299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014347 ORDER BY `minOrder` ASC [ RunTime:0.044921s ]
select * from pdf where partno='A1251-TP' and brandshort='CJT' limit 1 [ RunTime:0.075787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1251-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.050519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018575 LIMIT 5 [ RunTime:0.126494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018575 ORDER BY `minOrder` ASC [ RunTime:0.060343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018575 ORDER BY `unit` DESC [ RunTime:0.050059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018575 LIMIT 2 [ RunTime:0.057292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018575 ORDER BY `minOrder` ASC [ RunTime:0.015026s ]
select * from pdf where partno='A1257WV-S-4P-LCP' and brandshort='CJT' limit 1 [ RunTime:0.026653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1257WV-S-4P-LCP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.038071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32114992 LIMIT 5 [ RunTime:0.087075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32114992 ORDER BY `minOrder` ASC [ RunTime:0.056646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32114992 ORDER BY `unit` DESC [ RunTime:0.012824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32114992 LIMIT 2 [ RunTime:0.053717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32114992 ORDER BY `minOrder` ASC [ RunTime:0.029857s ]
select * from pdf where partno='A2001-TP' and brandshort='CJT' limit 1 [ RunTime:0.041698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2001-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.048610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019001 LIMIT 5 [ RunTime:0.108133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019001 ORDER BY `minOrder` ASC [ RunTime:0.046781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019001 ORDER BY `unit` DESC [ RunTime:0.087367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019001 LIMIT 2 [ RunTime:0.053687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019001 ORDER BY `minOrder` ASC [ RunTime:0.021116s ]
select * from pdf where partno='A1257WV-S-5P-LCP' and brandshort='CJT' limit 1 [ RunTime:0.005583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1257WV-S-5P-LCP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.020039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019077 LIMIT 5 [ RunTime:0.032852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019077 ORDER BY `minOrder` ASC [ RunTime:0.039385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019077 ORDER BY `unit` DESC [ RunTime:0.018751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019077 LIMIT 2 [ RunTime:0.018800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019077 ORDER BY `minOrder` ASC [ RunTime:0.014528s ]
select * from pdf where partno='C3030F-TP-A' and brandshort='CJT' limit 1 [ RunTime:0.020263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C3030F-TP-A' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.017517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019975 LIMIT 5 [ RunTime:0.011791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019975 ORDER BY `minOrder` ASC [ RunTime:0.027319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019975 ORDER BY `unit` DESC [ RunTime:0.008684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019975 LIMIT 2 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019975 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='A2501-TP' and brandshort='CJT' limit 1 [ RunTime:0.002769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2501-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.013589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019082 LIMIT 5 [ RunTime:0.027112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019082 ORDER BY `minOrder` ASC [ RunTime:0.004693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019082 ORDER BY `unit` DESC [ RunTime:0.011200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019082 LIMIT 2 [ RunTime:0.003100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019082 ORDER BY `minOrder` ASC [ RunTime:0.009530s ]
select * from pdf where partno='A2547-TP' and brandshort='CJT' limit 1 [ RunTime:0.007123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2547-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.007677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019320 LIMIT 5 [ RunTime:0.008492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019320 ORDER BY `minOrder` ASC [ RunTime:0.010644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019320 ORDER BY `unit` DESC [ RunTime:0.018889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019320 LIMIT 2 [ RunTime:0.018133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019320 ORDER BY `minOrder` ASC [ RunTime:0.006208s ]
select * from pdf where partno='A2508-TP' and brandshort='CJT' limit 1 [ RunTime:0.011927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2508-TP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.027243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018960 LIMIT 5 [ RunTime:0.025114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018960 ORDER BY `minOrder` ASC [ RunTime:0.011884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018960 ORDER BY `unit` DESC [ RunTime:0.003713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018960 LIMIT 2 [ RunTime:0.010924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018960 ORDER BY `minOrder` ASC [ RunTime:0.008330s ]
select * from pdf where partno='A1251WV-S-4P' and brandshort='CJT' limit 1 [ RunTime:0.003131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1251WV-S-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.013268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019184 LIMIT 5 [ RunTime:0.017217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019184 ORDER BY `minOrder` ASC [ RunTime:0.003004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019184 ORDER BY `unit` DESC [ RunTime:0.019921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019184 LIMIT 2 [ RunTime:0.002001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019184 ORDER BY `minOrder` ASC [ RunTime:0.009286s ]
select * from pdf where partno='A1251WR-S-2P' and brandshort='CJT' limit 1 [ RunTime:0.004313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1251WR-S-2P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.015263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019148 LIMIT 5 [ RunTime:0.018276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019148 ORDER BY `minOrder` ASC [ RunTime:0.008020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019148 ORDER BY `unit` DESC [ RunTime:0.021368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019148 LIMIT 2 [ RunTime:0.015851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019148 ORDER BY `minOrder` ASC [ RunTime:0.010174s ]
select * from pdf where partno='A3963WV-3P' and brandshort='CJT' limit 1 [ RunTime:0.015698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3963WV-3P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.008371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018946 LIMIT 5 [ RunTime:0.021990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018946 ORDER BY `minOrder` ASC [ RunTime:0.010909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018946 ORDER BY `unit` DESC [ RunTime:0.009807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018946 LIMIT 2 [ RunTime:0.005905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018946 ORDER BY `minOrder` ASC [ RunTime:0.003849s ]
select * from pdf where partno='A2508WV-4P' and brandshort='CJT' limit 1 [ RunTime:0.009926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2508WV-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.021680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014741 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014741 ORDER BY `minOrder` ASC [ RunTime:0.026131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014741 ORDER BY `unit` DESC [ RunTime:0.005025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014741 LIMIT 2 [ RunTime:0.002835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014741 ORDER BY `minOrder` ASC [ RunTime:0.003904s ]
select * from pdf where partno='A2547-GP' and brandshort='CJT' limit 1 [ RunTime:0.008917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2547-GP' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.022213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019744 LIMIT 5 [ RunTime:0.027011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019744 ORDER BY `minOrder` ASC [ RunTime:0.006962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019744 ORDER BY `unit` DESC [ RunTime:0.002415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019744 LIMIT 2 [ RunTime:0.013104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019744 ORDER BY `minOrder` ASC [ RunTime:0.002774s ]
select * from pdf where partno='A2006WR-2x4P' and brandshort='CJT' limit 1 [ RunTime:0.006434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2006WR-2x4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.001609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019782 LIMIT 5 [ RunTime:0.018155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019782 ORDER BY `minOrder` ASC [ RunTime:0.011335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019782 ORDER BY `unit` DESC [ RunTime:0.025425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019782 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019782 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
select * from pdf where partno='A2006WV-2x5P' and brandshort='CJT' limit 1 [ RunTime:0.023757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A2006WV-2x5P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.013758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58018738 LIMIT 5 [ RunTime:0.019863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018738 ORDER BY `minOrder` ASC [ RunTime:0.011400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58018738 ORDER BY `unit` DESC [ RunTime:0.007772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58018738 LIMIT 2 [ RunTime:0.014166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58018738 ORDER BY `minOrder` ASC [ RunTime:0.025242s ]
select * from pdf where partno='A1257WR-S-4P' and brandshort='CJT' limit 1 [ RunTime:0.014713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1257WR-S-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.062897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019177 LIMIT 5 [ RunTime:0.018289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019177 ORDER BY `minOrder` ASC [ RunTime:0.034997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019177 ORDER BY `unit` DESC [ RunTime:0.026587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019177 LIMIT 2 [ RunTime:0.048906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019177 ORDER BY `minOrder` ASC [ RunTime:0.003269s ]
select * from pdf where partno='A3963WV-4P' and brandshort='CJT' limit 1 [ RunTime:0.023625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3963WV-4P' OR `brand` LIKE 'CJT(长江连接器)%' ) ) LIMIT 1 [ RunTime:0.023880s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CJT%' OR `brand` LIKE 'CJT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027994s ]