SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002247s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=9-146256-0&search=1' [ RunTime:0.001988s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001798s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000587s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001357s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000228s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001957s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001461s ]
SELECT * FROM `stock_search` WHERE `partno` = '9-146256-0' LIMIT 1 [ RunTime:0.000819s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 21:06:12' WHERE `partno` = '9-146256-0' [ RunTime:0.001690s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001446s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007664s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485311 LIMIT 5 [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485311 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15485311 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15485311 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485311 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='9-146256-0-01' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16218440 LIMIT 5 [ RunTime:0.004025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16218440 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16218440 ORDER BY `unit` DESC [ RunTime:0.005948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16218440 LIMIT 2 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16218440 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16222861 LIMIT 5 [ RunTime:0.002066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16222861 ORDER BY `minOrder` ASC [ RunTime:0.004967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16222861 ORDER BY `unit` DESC [ RunTime:0.009941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16222861 LIMIT 2 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16222861 ORDER BY `minOrder` ASC [ RunTime:0.005831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486823 LIMIT 5 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486823 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486823 ORDER BY `unit` DESC [ RunTime:0.017785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486823 LIMIT 2 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486823 ORDER BY `minOrder` ASC [ RunTime:0.008181s ]
select * from pdf where partno='9-146256-0-03' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850164 LIMIT 5 [ RunTime:0.010655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850164 ORDER BY `minOrder` ASC [ RunTime:0.008137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19850164 ORDER BY `unit` DESC [ RunTime:0.010975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19850164 LIMIT 2 [ RunTime:0.009136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850164 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12776506 LIMIT 5 [ RunTime:0.019419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12776506 ORDER BY `minOrder` ASC [ RunTime:0.007962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12776506 ORDER BY `unit` DESC [ RunTime:0.007463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12776506 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12776506 ORDER BY `minOrder` ASC [ RunTime:0.004167s ]
select * from pdf where partno='9-146256-0-08' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12778655 LIMIT 5 [ RunTime:0.016488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12778655 ORDER BY `minOrder` ASC [ RunTime:0.010071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12778655 ORDER BY `unit` DESC [ RunTime:0.008754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12778655 LIMIT 2 [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12778655 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
select * from pdf where partno='9-146256-0-10' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19825806 LIMIT 5 [ RunTime:0.010332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19825806 ORDER BY `minOrder` ASC [ RunTime:0.012415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19825806 ORDER BY `unit` DESC [ RunTime:0.009379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19825806 LIMIT 2 [ RunTime:0.003737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19825806 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829510 LIMIT 5 [ RunTime:0.013573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829510 ORDER BY `minOrder` ASC [ RunTime:0.007675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19829510 ORDER BY `unit` DESC [ RunTime:0.009866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19829510 LIMIT 2 [ RunTime:0.001561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829510 ORDER BY `minOrder` ASC [ RunTime:0.001454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831667 LIMIT 5 [ RunTime:0.009831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19831667 ORDER BY `minOrder` ASC [ RunTime:0.004119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19831667 ORDER BY `unit` DESC [ RunTime:0.010494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19831667 LIMIT 2 [ RunTime:0.012903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19831667 ORDER BY `minOrder` ASC [ RunTime:0.008601s ]
select * from pdf where partno='9-146256-0-25' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19827192 LIMIT 5 [ RunTime:0.004651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19827192 ORDER BY `minOrder` ASC [ RunTime:0.004097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19827192 ORDER BY `unit` DESC [ RunTime:0.020736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19827192 LIMIT 2 [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19827192 ORDER BY `minOrder` ASC [ RunTime:0.002932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16221611 LIMIT 5 [ RunTime:0.002930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16221611 ORDER BY `minOrder` ASC [ RunTime:0.003821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16221611 ORDER BY `unit` DESC [ RunTime:0.019655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16221611 LIMIT 2 [ RunTime:0.003536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16221611 ORDER BY `minOrder` ASC [ RunTime:0.001469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829810 LIMIT 5 [ RunTime:0.001849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829810 ORDER BY `minOrder` ASC [ RunTime:0.016051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19829810 ORDER BY `unit` DESC [ RunTime:0.011130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19829810 LIMIT 2 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829810 ORDER BY `minOrder` ASC [ RunTime:0.001312s ]
select * from pdf where partno='9-146256-0-16' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829104 LIMIT 5 [ RunTime:0.012184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829104 ORDER BY `minOrder` ASC [ RunTime:0.011131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19829104 ORDER BY `unit` DESC [ RunTime:0.014862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19829104 LIMIT 2 [ RunTime:0.005568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829104 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
select * from pdf where partno='9-146256-0-14' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484041 LIMIT 5 [ RunTime:0.011311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484041 ORDER BY `minOrder` ASC [ RunTime:0.003953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15484041 ORDER BY `unit` DESC [ RunTime:0.008851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15484041 LIMIT 2 [ RunTime:0.002115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484041 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='9-146256-0-09' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761905 LIMIT 5 [ RunTime:0.005700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761905 ORDER BY `minOrder` ASC [ RunTime:0.005964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12761905 ORDER BY `unit` DESC [ RunTime:0.006248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12761905 LIMIT 2 [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761905 ORDER BY `minOrder` ASC [ RunTime:0.002024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761323 LIMIT 5 [ RunTime:0.001757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761323 ORDER BY `minOrder` ASC [ RunTime:0.005074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12761323 ORDER BY `unit` DESC [ RunTime:0.002281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12761323 LIMIT 2 [ RunTime:0.003474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761323 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='9-146256-0-37' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759755 LIMIT 5 [ RunTime:0.005193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759755 ORDER BY `minOrder` ASC [ RunTime:0.005273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759755 ORDER BY `unit` DESC [ RunTime:0.002510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759755 LIMIT 2 [ RunTime:0.008029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759755 ORDER BY `minOrder` ASC [ RunTime:0.004521s ]
select * from pdf where partno='9-146256-0-32' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757761 LIMIT 5 [ RunTime:0.009391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757761 ORDER BY `minOrder` ASC [ RunTime:0.007337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12757761 ORDER BY `unit` DESC [ RunTime:0.006231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12757761 LIMIT 2 [ RunTime:0.005052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757761 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
select * from pdf where partno='9-146256-0-27' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757205 LIMIT 5 [ RunTime:0.003956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757205 ORDER BY `minOrder` ASC [ RunTime:0.005584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12757205 ORDER BY `unit` DESC [ RunTime:0.005763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12757205 LIMIT 2 [ RunTime:0.005750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757205 ORDER BY `minOrder` ASC [ RunTime:0.001468s ]
select * from pdf where partno='9-146256-0-26' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004167s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006883s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59463280 LIMIT 5 [ RunTime:0.007015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59463280 ORDER BY `minOrder` ASC [ RunTime:0.005939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59463280 ORDER BY `unit` DESC [ RunTime:0.004572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59463280 LIMIT 2 [ RunTime:0.001320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59463280 ORDER BY `minOrder` ASC [ RunTime:0.001766s ]
select * from pdf where partno='9-146256-0-01' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-01' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001630s ]
SELECT `id` FROM `stock` WHERE `id` <> 59463280 AND `partno` = '9-146256-0-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485311 [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435505 LIMIT 5 [ RunTime:0.003510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435505 ORDER BY `minOrder` ASC [ RunTime:0.016002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435505 ORDER BY `unit` DESC [ RunTime:0.006514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435505 LIMIT 2 [ RunTime:0.007686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435505 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='9-146256-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001581s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435505 AND `partno` = '9-146256-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850164 [ RunTime:0.009018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59470630 LIMIT 5 [ RunTime:0.011108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59470630 ORDER BY `minOrder` ASC [ RunTime:0.005629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59470630 ORDER BY `unit` DESC [ RunTime:0.011672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59470630 LIMIT 2 [ RunTime:0.007955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59470630 ORDER BY `minOrder` ASC [ RunTime:0.005379s ]
select * from pdf where partno='9-146256-0-02' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-02' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001182s ]
SELECT `id` FROM `stock` WHERE `id` <> 59470630 AND `partno` = '9-146256-0-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16218440 [ RunTime:0.008248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59486468 LIMIT 5 [ RunTime:0.002145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59486468 ORDER BY `minOrder` ASC [ RunTime:0.006317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59486468 ORDER BY `unit` DESC [ RunTime:0.004905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59486468 LIMIT 2 [ RunTime:0.005971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59486468 ORDER BY `minOrder` ASC [ RunTime:0.004739s ]
select * from pdf where partno='9-146256-0-05' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-05' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009176s ]
SELECT `id` FROM `stock` WHERE `id` <> 59486468 AND `partno` = '9-146256-0-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16222861 [ RunTime:0.008348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59477585 LIMIT 5 [ RunTime:0.002750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59477585 ORDER BY `minOrder` ASC [ RunTime:0.006466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59477585 ORDER BY `unit` DESC [ RunTime:0.018427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59477585 LIMIT 2 [ RunTime:0.011132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59477585 ORDER BY `minOrder` ASC [ RunTime:0.008496s ]
select * from pdf where partno='9-146256-0-03' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-03' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012663s ]
SELECT `id` FROM `stock` WHERE `id` <> 59477585 AND `partno` = '9-146256-0-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486823 [ RunTime:0.012111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59497997 LIMIT 5 [ RunTime:0.015567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59497997 ORDER BY `minOrder` ASC [ RunTime:0.011673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59497997 ORDER BY `unit` DESC [ RunTime:0.016853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59497997 LIMIT 2 [ RunTime:0.018567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59497997 ORDER BY `minOrder` ASC [ RunTime:0.013902s ]
select * from pdf where partno='9-146256-0-10' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-10' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015665s ]
SELECT `id` FROM `stock` WHERE `id` <> 59497997 AND `partno` = '9-146256-0-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.027545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12778655 [ RunTime:0.017913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59494651 LIMIT 5 [ RunTime:0.013100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59494651 ORDER BY `minOrder` ASC [ RunTime:0.024485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59494651 ORDER BY `unit` DESC [ RunTime:0.000763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59494651 LIMIT 2 [ RunTime:0.011456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59494651 ORDER BY `minOrder` ASC [ RunTime:0.003364s ]
select * from pdf where partno='9-146256-0-08' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-08' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008717s ]
SELECT `id` FROM `stock` WHERE `id` <> 59494651 AND `partno` = '9-146256-0-08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12776506 [ RunTime:0.011089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59489554 LIMIT 5 [ RunTime:0.008610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59489554 ORDER BY `minOrder` ASC [ RunTime:0.017477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59489554 ORDER BY `unit` DESC [ RunTime:0.014724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59489554 LIMIT 2 [ RunTime:0.025059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59489554 ORDER BY `minOrder` ASC [ RunTime:0.006230s ]
select * from pdf where partno='9-146256-0-06' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-06' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012223s ]
SELECT `id` FROM `stock` WHERE `id` <> 59489554 AND `partno` = '9-146256-0-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.062782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19825806 [ RunTime:0.024903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59502468 LIMIT 5 [ RunTime:0.017274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59502468 ORDER BY `minOrder` ASC [ RunTime:0.017647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59502468 ORDER BY `unit` DESC [ RunTime:0.039504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59502468 LIMIT 2 [ RunTime:0.006128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59502468 ORDER BY `minOrder` ASC [ RunTime:0.017266s ]
select * from pdf where partno='9-146256-0-15' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-15' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000965s ]
SELECT `id` FROM `stock` WHERE `id` <> 59502468 AND `partno` = '9-146256-0-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829510 [ RunTime:0.017320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59492670 LIMIT 5 [ RunTime:0.014028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59492670 ORDER BY `minOrder` ASC [ RunTime:0.031921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59492670 ORDER BY `unit` DESC [ RunTime:0.008570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59492670 LIMIT 2 [ RunTime:0.027989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59492670 ORDER BY `minOrder` ASC [ RunTime:0.002366s ]
select * from pdf where partno='9-146256-0-07' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-07' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012863s ]
SELECT `id` FROM `stock` WHERE `id` <> 59492670 AND `partno` = '9-146256-0-07' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19827192 [ RunTime:0.017225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59482687 LIMIT 5 [ RunTime:0.008576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59482687 ORDER BY `minOrder` ASC [ RunTime:0.033011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59482687 ORDER BY `unit` DESC [ RunTime:0.023235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59482687 LIMIT 2 [ RunTime:0.019634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59482687 ORDER BY `minOrder` ASC [ RunTime:0.014767s ]
select * from pdf where partno='9-146256-0-04' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.042735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-04' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015756s ]
SELECT `id` FROM `stock` WHERE `id` <> 59482687 AND `partno` = '9-146256-0-04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.031772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16221611 [ RunTime:0.008845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59501804 LIMIT 5 [ RunTime:0.006822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59501804 ORDER BY `minOrder` ASC [ RunTime:0.023218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59501804 ORDER BY `unit` DESC [ RunTime:0.021427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59501804 LIMIT 2 [ RunTime:0.013538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59501804 ORDER BY `minOrder` ASC [ RunTime:0.010397s ]
select * from pdf where partno='9-146256-0-14' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-14' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.043016s ]
SELECT `id` FROM `stock` WHERE `id` <> 59501804 AND `partno` = '9-146256-0-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829104 [ RunTime:0.011405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59506720 LIMIT 5 [ RunTime:0.027262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59506720 ORDER BY `minOrder` ASC [ RunTime:0.017976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59506720 ORDER BY `unit` DESC [ RunTime:0.011397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59506720 LIMIT 2 [ RunTime:0.023244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59506720 ORDER BY `minOrder` ASC [ RunTime:0.008552s ]
select * from pdf where partno='9-146256-0-25' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-25' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012923s ]
SELECT `id` FROM `stock` WHERE `id` <> 59506720 AND `partno` = '9-146256-0-25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831667 [ RunTime:0.014633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59561126 LIMIT 5 [ RunTime:0.024492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59561126 ORDER BY `minOrder` ASC [ RunTime:0.016649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59561126 ORDER BY `unit` DESC [ RunTime:0.016534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59561126 LIMIT 2 [ RunTime:0.020638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59561126 ORDER BY `minOrder` ASC [ RunTime:0.008805s ]
select * from pdf where partno='9-146256-0-16' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-16' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024302s ]
SELECT `id` FROM `stock` WHERE `id` <> 59561126 AND `partno` = '9-146256-0-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.041574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829810 [ RunTime:0.024942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59556334 LIMIT 5 [ RunTime:0.010506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59556334 ORDER BY `minOrder` ASC [ RunTime:0.049516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59556334 ORDER BY `unit` DESC [ RunTime:0.032244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59556334 LIMIT 2 [ RunTime:0.035427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59556334 ORDER BY `minOrder` ASC [ RunTime:0.014796s ]
select * from pdf where partno='9-146256-0-09' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-09' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018609s ]
SELECT `id` FROM `stock` WHERE `id` <> 59556334 AND `partno` = '9-146256-0-09' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484041 [ RunTime:0.039833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59733362 LIMIT 5 [ RunTime:0.016428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733362 ORDER BY `minOrder` ASC [ RunTime:0.024281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59733362 ORDER BY `unit` DESC [ RunTime:0.033264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59733362 LIMIT 2 [ RunTime:0.027199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59733362 ORDER BY `minOrder` ASC [ RunTime:0.020331s ]
select * from pdf where partno='9-146256-0-39' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-39' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.028783s ]
SELECT `id` FROM `stock` WHERE `id` <> 59733362 AND `partno` = '9-146256-0-39' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761905 [ RunTime:0.040293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59732775 LIMIT 5 [ RunTime:0.002857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732775 ORDER BY `minOrder` ASC [ RunTime:0.008798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59732775 ORDER BY `unit` DESC [ RunTime:0.015052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59732775 LIMIT 2 [ RunTime:0.008942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732775 ORDER BY `minOrder` ASC [ RunTime:0.003107s ]
select * from pdf where partno='9-146256-0-38' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-38' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014566s ]
SELECT `id` FROM `stock` WHERE `id` <> 59732775 AND `partno` = '9-146256-0-38' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11587663 [ RunTime:0.005115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59732201 LIMIT 5 [ RunTime:0.008210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732201 ORDER BY `minOrder` ASC [ RunTime:0.006880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59732201 ORDER BY `unit` DESC [ RunTime:0.018643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59732201 LIMIT 2 [ RunTime:0.012344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732201 ORDER BY `minOrder` ASC [ RunTime:0.005162s ]
select * from pdf where partno='9-146256-0-37' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-37' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015549s ]
SELECT `id` FROM `stock` WHERE `id` <> 59732201 AND `partno` = '9-146256-0-37' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761323 [ RunTime:0.012861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59731526 LIMIT 5 [ RunTime:0.002397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59731526 ORDER BY `minOrder` ASC [ RunTime:0.012723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59731526 ORDER BY `unit` DESC [ RunTime:0.017388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59731526 LIMIT 2 [ RunTime:0.014679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59731526 ORDER BY `minOrder` ASC [ RunTime:0.004024s ]
select * from pdf where partno='9-146256-0-36' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.013912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-36' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024058s ]
SELECT `id` FROM `stock` WHERE `id` <> 59731526 AND `partno` = '9-146256-0-36' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59730851 LIMIT 5 [ RunTime:0.011359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730851 ORDER BY `minOrder` ASC [ RunTime:0.025248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59730851 ORDER BY `unit` DESC [ RunTime:0.006139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59730851 LIMIT 2 [ RunTime:0.011302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59730851 ORDER BY `minOrder` ASC [ RunTime:0.013228s ]
select * from pdf where partno='9-146256-0-35' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.030609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-146256-0-35' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019935s ]
SELECT `id` FROM `stock` WHERE `id` <> 59730851 AND `partno` = '9-146256-0-35' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007396s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004219s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010081s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010291s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018743s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022082s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025722s ]
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 '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013012s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9-146256-0%' OR `brand` LIKE '9-146256-0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018025s ]