SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002396s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=202G&search=1' [ RunTime:0.007235s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003461s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002261s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001589s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.001602s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001384s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001492s ]
SELECT * FROM `stock_search` WHERE `partno` = '202G' LIMIT 1 [ RunTime:0.000763s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-22 23:03:46' WHERE `partno` = '202G' [ RunTime:0.009493s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001876s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013771s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044023 LIMIT 5 [ RunTime:0.011915s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044023 ORDER BY `minOrder` ASC [ RunTime:0.004287s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044023 ORDER BY `unit` DESC [ RunTime:0.003252s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044023 LIMIT 2 [ RunTime:0.007806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044023 ORDER BY `minOrder` ASC [ RunTime:0.006383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261296 LIMIT 5 [ RunTime:0.007624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261296 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15261296 ORDER BY `unit` DESC [ RunTime:0.004394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15261296 LIMIT 2 [ RunTime:0.004121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261296 ORDER BY `minOrder` ASC [ RunTime:0.007604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14432072 LIMIT 5 [ RunTime:0.012895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14432072 ORDER BY `minOrder` ASC [ RunTime:0.003140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14432072 ORDER BY `unit` DESC [ RunTime:0.005995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14432072 LIMIT 2 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14432072 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431915 LIMIT 5 [ RunTime:0.004263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431915 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431915 ORDER BY `unit` DESC [ RunTime:0.003618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431915 LIMIT 2 [ RunTime:0.008277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431915 ORDER BY `minOrder` ASC [ RunTime:0.009816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431914 LIMIT 5 [ RunTime:0.002092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431914 ORDER BY `minOrder` ASC [ RunTime:0.001695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431914 ORDER BY `unit` DESC [ RunTime:0.006530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431914 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431914 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431777 LIMIT 5 [ RunTime:0.005194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431777 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431777 ORDER BY `unit` DESC [ RunTime:0.007435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431777 LIMIT 2 [ RunTime:0.001413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431777 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431775 LIMIT 5 [ RunTime:0.011121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431775 ORDER BY `minOrder` ASC [ RunTime:0.000925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431775 ORDER BY `unit` DESC [ RunTime:0.003460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431775 LIMIT 2 [ RunTime:0.010334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431775 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431734 LIMIT 5 [ RunTime:0.004586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431734 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431734 ORDER BY `unit` DESC [ RunTime:0.004220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431734 LIMIT 2 [ RunTime:0.012942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431734 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
select * from pdf where partno='202G632-55-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.008190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431697 LIMIT 5 [ RunTime:0.007115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431697 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431697 ORDER BY `unit` DESC [ RunTime:0.007014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431697 LIMIT 2 [ RunTime:0.007430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431697 ORDER BY `minOrder` ASC [ RunTime:0.003101s ]
select * from pdf where partno='202G232-55-0-CS5326' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.010156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431690 LIMIT 5 [ RunTime:0.019704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431690 ORDER BY `minOrder` ASC [ RunTime:0.062445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431690 ORDER BY `unit` DESC [ RunTime:0.045281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431690 LIMIT 2 [ RunTime:0.055725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431690 ORDER BY `minOrder` ASC [ RunTime:0.039747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431686 LIMIT 5 [ RunTime:0.073223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431686 ORDER BY `minOrder` ASC [ RunTime:0.041074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431686 ORDER BY `unit` DESC [ RunTime:0.097458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431686 LIMIT 2 [ RunTime:0.109677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431686 ORDER BY `minOrder` ASC [ RunTime:0.023274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431663 LIMIT 5 [ RunTime:0.026944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431663 ORDER BY `minOrder` ASC [ RunTime:0.019209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431663 ORDER BY `unit` DESC [ RunTime:0.009523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431663 LIMIT 2 [ RunTime:0.022271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431663 ORDER BY `minOrder` ASC [ RunTime:0.004774s ]
select * from pdf where partno='202G211-55-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431432 LIMIT 5 [ RunTime:0.007859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431432 ORDER BY `minOrder` ASC [ RunTime:0.018871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431432 ORDER BY `unit` DESC [ RunTime:0.032683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431432 LIMIT 2 [ RunTime:0.003831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431432 ORDER BY `minOrder` ASC [ RunTime:0.000612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431430 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431430 ORDER BY `minOrder` ASC [ RunTime:0.010966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431430 ORDER BY `unit` DESC [ RunTime:0.011377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431430 LIMIT 2 [ RunTime:0.001362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431430 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='202G611-780-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.007381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431426 LIMIT 5 [ RunTime:0.002967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431426 ORDER BY `minOrder` ASC [ RunTime:0.005034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431426 ORDER BY `unit` DESC [ RunTime:0.004054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431426 LIMIT 2 [ RunTime:0.004431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431426 ORDER BY `minOrder` ASC [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431291 LIMIT 5 [ RunTime:0.001213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431291 ORDER BY `minOrder` ASC [ RunTime:0.016408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431291 ORDER BY `unit` DESC [ RunTime:0.004911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431291 LIMIT 2 [ RunTime:0.002666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431291 ORDER BY `minOrder` ASC [ RunTime:0.002534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431269 LIMIT 5 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431269 ORDER BY `minOrder` ASC [ RunTime:0.005642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431269 ORDER BY `unit` DESC [ RunTime:0.006745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431269 LIMIT 2 [ RunTime:0.002160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431269 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='202G632-780-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431203 LIMIT 5 [ RunTime:0.004341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431203 ORDER BY `minOrder` ASC [ RunTime:0.004980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14431203 ORDER BY `unit` DESC [ RunTime:0.006205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14431203 LIMIT 2 [ RunTime:0.002352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14431203 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
select * from pdf where partno='202G621-780-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13563503 LIMIT 5 [ RunTime:0.003165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13563503 ORDER BY `minOrder` ASC [ RunTime:0.011652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13563503 ORDER BY `unit` DESC [ RunTime:0.009826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13563503 LIMIT 2 [ RunTime:0.003300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13563503 ORDER BY `minOrder` ASC [ RunTime:0.003343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13563063 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13563063 ORDER BY `minOrder` ASC [ RunTime:0.004628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13563063 ORDER BY `unit` DESC [ RunTime:0.006395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13563063 LIMIT 2 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13563063 ORDER BY `minOrder` ASC [ RunTime:0.007477s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32236383 LIMIT 5 [ RunTime:0.005780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236383 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32236383 ORDER BY `unit` DESC [ RunTime:0.005074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32236383 LIMIT 2 [ RunTime:0.010042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236383 ORDER BY `minOrder` ASC [ RunTime:0.001826s ]
select * from pdf where partno='202g cc bc-3lp' and brandshort='displaytech' limit 1 [ RunTime:0.009519s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202g cc bc-3lp' OR `brand` LIKE 'displaytech%' ) ) LIMIT 1 [ RunTime:0.004018s ]
SELECT `id` FROM `stock` WHERE `id` <> 32236383 AND `partno` = '202g cc bc-3lp' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%displaytech%' ) [ RunTime:0.002642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261296 [ RunTime:0.003344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32204406 LIMIT 5 [ RunTime:0.004638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204406 ORDER BY `minOrder` ASC [ RunTime:0.004253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32204406 ORDER BY `unit` DESC [ RunTime:0.007975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32204406 LIMIT 2 [ RunTime:0.001728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204406 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
select * from pdf where partno='202g211-55-0' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.011825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202g211-55-0' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000605s ]
SELECT `id` FROM `stock` WHERE `id` <> 32204406 AND `partno` = '202g211-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000682s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56364772 LIMIT 5 [ RunTime:0.004447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364772 ORDER BY `minOrder` ASC [ RunTime:0.004632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56364772 ORDER BY `unit` DESC [ RunTime:0.001318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56364772 LIMIT 2 [ RunTime:0.006527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56364772 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='202G642-55-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.009758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G642-55-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.004732s ]
SELECT `id` FROM `stock` WHERE `id` <> 56364772 AND `partno` = '202G642-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431777 [ RunTime:0.007089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56370056 LIMIT 5 [ RunTime:0.010407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370056 ORDER BY `minOrder` ASC [ RunTime:0.005902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56370056 ORDER BY `unit` DESC [ RunTime:0.008232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56370056 LIMIT 2 [ RunTime:0.001280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370056 ORDER BY `minOrder` ASC [ RunTime:0.001084s ]
select * from pdf where partno='202G253-780-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G253-780-3' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.012005s ]
SELECT `id` FROM `stock` WHERE `id` <> 56370056 AND `partno` = '202G253-780-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.005844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562411 [ RunTime:0.005331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56370051 LIMIT 5 [ RunTime:0.001612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370051 ORDER BY `minOrder` ASC [ RunTime:0.002039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56370051 ORDER BY `unit` DESC [ RunTime:0.009093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56370051 LIMIT 2 [ RunTime:0.001552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370051 ORDER BY `minOrder` ASC [ RunTime:0.004580s ]
select * from pdf where partno='202G632-55-0-CS5325' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G632-55-0-CS5325' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003745s ]
SELECT `id` FROM `stock` WHERE `id` <> 56370051 AND `partno` = '202G632-55-0-CS5325' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56370038 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370038 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56370038 ORDER BY `unit` DESC [ RunTime:0.009274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56370038 LIMIT 2 [ RunTime:0.002345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370038 ORDER BY `minOrder` ASC [ RunTime:0.001441s ]
select * from pdf where partno='202G621-55-0-CS5325' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G621-55-0-CS5325' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003693s ]
SELECT `id` FROM `stock` WHERE `id` <> 56370038 AND `partno` = '202G621-55-0-CS5325' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56370003 LIMIT 5 [ RunTime:0.003062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370003 ORDER BY `minOrder` ASC [ RunTime:0.002004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56370003 ORDER BY `unit` DESC [ RunTime:0.008005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56370003 LIMIT 2 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56370003 ORDER BY `minOrder` ASC [ RunTime:0.000955s ]
select * from pdf where partno='202G632-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G632-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002276s ]
SELECT `id` FROM `stock` WHERE `id` <> 56370003 AND `partno` = '202G632-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369991 LIMIT 5 [ RunTime:0.003529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369991 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369991 ORDER BY `unit` DESC [ RunTime:0.008489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369991 LIMIT 2 [ RunTime:0.004655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369991 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
select * from pdf where partno='202G232-55-0-CS5326' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G232-55-0-CS5326' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005865s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369991 AND `partno` = '202G232-55-0-CS5326' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369982 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369982 ORDER BY `minOrder` ASC [ RunTime:0.001606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369982 ORDER BY `unit` DESC [ RunTime:0.007287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369982 LIMIT 2 [ RunTime:0.002940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369982 ORDER BY `minOrder` ASC [ RunTime:0.003595s ]
select * from pdf where partno='202G232-55-01-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G232-55-01-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002123s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369982 AND `partno` = '202G232-55-01-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369943 LIMIT 5 [ RunTime:0.003858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369943 ORDER BY `minOrder` ASC [ RunTime:0.004555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369943 ORDER BY `unit` DESC [ RunTime:0.006019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369943 LIMIT 2 [ RunTime:0.001462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369943 ORDER BY `minOrder` ASC [ RunTime:0.003425s ]
select * from pdf where partno='202G232-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G232-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007157s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369943 AND `partno` = '202G232-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369940 LIMIT 5 [ RunTime:0.006269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369940 ORDER BY `minOrder` ASC [ RunTime:0.001955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369940 ORDER BY `unit` DESC [ RunTime:0.013969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369940 LIMIT 2 [ RunTime:0.005790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369940 ORDER BY `minOrder` ASC [ RunTime:0.005041s ]
select * from pdf where partno='202G611-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G611-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008935s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369940 AND `partno` = '202G611-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369923 LIMIT 5 [ RunTime:0.003495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369923 ORDER BY `minOrder` ASC [ RunTime:0.007013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369923 ORDER BY `unit` DESC [ RunTime:0.008096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369923 LIMIT 2 [ RunTime:0.007316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369923 ORDER BY `minOrder` ASC [ RunTime:0.007351s ]
select * from pdf where partno='202G621-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G621-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006488s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369923 AND `partno` = '202G621-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369911 LIMIT 5 [ RunTime:0.017191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369911 ORDER BY `minOrder` ASC [ RunTime:0.017258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369911 ORDER BY `unit` DESC [ RunTime:0.047235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369911 LIMIT 2 [ RunTime:0.039581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369911 ORDER BY `minOrder` ASC [ RunTime:0.012035s ]
select * from pdf where partno='202G253-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.026553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G253-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016811s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369911 AND `partno` = '202G253-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369905 LIMIT 5 [ RunTime:0.009796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369905 ORDER BY `minOrder` ASC [ RunTime:0.063612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369905 ORDER BY `unit` DESC [ RunTime:0.125538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369905 LIMIT 2 [ RunTime:0.032405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369905 ORDER BY `minOrder` ASC [ RunTime:0.032599s ]
select * from pdf where partno='202G221-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G221-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.047723s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369905 AND `partno` = '202G221-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.114758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369879 LIMIT 5 [ RunTime:0.089278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369879 ORDER BY `minOrder` ASC [ RunTime:0.064448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369879 ORDER BY `unit` DESC [ RunTime:0.113822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369879 LIMIT 2 [ RunTime:0.019095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369879 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
select * from pdf where partno='202G242-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.034006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G242-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.058398s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369879 AND `partno` = '202G242-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.065842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369859 LIMIT 5 [ RunTime:0.077085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369859 ORDER BY `minOrder` ASC [ RunTime:0.042472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369859 ORDER BY `unit` DESC [ RunTime:0.009411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369859 LIMIT 2 [ RunTime:0.016020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369859 ORDER BY `minOrder` ASC [ RunTime:0.004371s ]
select * from pdf where partno='202G211-55-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G211-55-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009730s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369859 AND `partno` = '202G211-55-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.035807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369562 LIMIT 5 [ RunTime:0.034750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369562 ORDER BY `minOrder` ASC [ RunTime:0.027142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369562 ORDER BY `unit` DESC [ RunTime:0.068486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369562 LIMIT 2 [ RunTime:0.063500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369562 ORDER BY `minOrder` ASC [ RunTime:0.016286s ]
select * from pdf where partno='202G232-780-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G232-780-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017821s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369562 AND `partno` = '202G232-780-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.034529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369551 LIMIT 5 [ RunTime:0.058888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369551 ORDER BY `minOrder` ASC [ RunTime:0.054430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369551 ORDER BY `unit` DESC [ RunTime:0.046941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369551 LIMIT 2 [ RunTime:0.040718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369551 ORDER BY `minOrder` ASC [ RunTime:0.007526s ]
select * from pdf where partno='202G211-780-09-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.028246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G211-780-09-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023305s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369551 AND `partno` = '202G211-780-09-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369435 LIMIT 5 [ RunTime:0.076227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369435 ORDER BY `minOrder` ASC [ RunTime:0.011504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369435 ORDER BY `unit` DESC [ RunTime:0.020327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369435 LIMIT 2 [ RunTime:0.023864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369435 ORDER BY `minOrder` ASC [ RunTime:0.012920s ]
select * from pdf where partno='202G253-780-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G253-780-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018540s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369435 AND `partno` = '202G253-780-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369373 LIMIT 5 [ RunTime:0.008568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369373 ORDER BY `minOrder` ASC [ RunTime:0.026982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369373 ORDER BY `unit` DESC [ RunTime:0.011505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369373 LIMIT 2 [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369373 ORDER BY `minOrder` ASC [ RunTime:0.004490s ]
select * from pdf where partno='202G242-780-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.052075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G242-780-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024303s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369373 AND `partno` = '202G242-780-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.041382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369329 LIMIT 5 [ RunTime:0.006097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369329 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369329 ORDER BY `unit` DESC [ RunTime:0.017345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369329 LIMIT 2 [ RunTime:0.021418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369329 ORDER BY `minOrder` ASC [ RunTime:0.016843s ]
select * from pdf where partno='202G242-780-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.022966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G242-780-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.003147s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369329 AND `partno` = '202G242-780-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.014087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14431426 [ RunTime:0.035780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56369129 LIMIT 5 [ RunTime:0.069921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369129 ORDER BY `minOrder` ASC [ RunTime:0.071996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56369129 ORDER BY `unit` DESC [ RunTime:0.045636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56369129 LIMIT 2 [ RunTime:0.011995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56369129 ORDER BY `minOrder` ASC [ RunTime:0.057058s ]
select * from pdf where partno='202G642-780-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.034027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202G642-780-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016106s ]
SELECT `id` FROM `stock` WHERE `id` <> 56369129 AND `partno` = '202G642-780-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009572s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014784s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015097s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010455s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009904s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017669s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025643s ]
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 '202G%' OR `brand` LIKE '202G%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017258s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '202G%' OR `brand` LIKE '202G%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022090s ]