SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002416s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.25' , `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=2936&search=1' [ RunTime:0.003626s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003766s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004565s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002658s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.25' ) [ RunTime:0.000739s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002280s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002319s ]
SELECT * FROM `stock_search` WHERE `partno` = '2936' LIMIT 1 [ RunTime:0.000752s ]
UPDATE `stock_search` SET `count` = 16 , `updatetime` = '2026-10-23 12:13:50' WHERE `partno` = '2936' [ RunTime:0.004143s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002777s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019029s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667941 LIMIT 5 [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667941 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667941 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667941 LIMIT 2 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667941 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668545 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668545 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668545 ORDER BY `unit` DESC [ RunTime:0.000260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668545 LIMIT 2 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668545 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313758 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313758 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313758 ORDER BY `unit` DESC [ RunTime:0.000273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313758 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313758 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668644 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668644 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668644 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668644 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668644 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668721 LIMIT 5 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668721 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668721 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668721 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668721 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='293654-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668725 LIMIT 5 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668725 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668725 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668725 LIMIT 2 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668725 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668796 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668796 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668796 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668796 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668796 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
select * from pdf where partno='293653-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668650 LIMIT 5 [ RunTime:0.001448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668650 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668650 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668650 LIMIT 2 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668650 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668635 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668635 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668635 ORDER BY `unit` DESC [ RunTime:0.000266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668635 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668635 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313920 LIMIT 5 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313920 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313920 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313920 LIMIT 2 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313920 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668557 LIMIT 5 [ RunTime:0.002135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668557 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668557 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668557 LIMIT 2 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668557 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668540 LIMIT 5 [ RunTime:0.002186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668540 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668540 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668540 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668540 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668539 LIMIT 5 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668539 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668539 ORDER BY `unit` DESC [ RunTime:0.000273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668539 LIMIT 2 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668539 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668972 LIMIT 5 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668972 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668972 ORDER BY `unit` DESC [ RunTime:0.000257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668972 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668972 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668850 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668850 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668850 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668850 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668850 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='293699-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668801 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668801 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668801 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668801 LIMIT 2 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668801 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='293650-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668665 LIMIT 5 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668665 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668665 ORDER BY `unit` DESC [ RunTime:0.000264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668665 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668665 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='293654-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668660 LIMIT 5 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668660 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668660 ORDER BY `unit` DESC [ RunTime:0.000268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668660 LIMIT 2 [ RunTime:0.000253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668660 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668657 LIMIT 5 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668657 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668657 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668657 LIMIT 2 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668657 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668656 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668656 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668656 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668656 LIMIT 2 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668656 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71808333 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808333 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71808333 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71808333 LIMIT 2 [ RunTime:0.000265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808333 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='293648-2' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.000711s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293648-2' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.000400s ]
SELECT `id` FROM `stock` WHERE `id` <> 71808333 AND `partno` = '293648-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070613 LIMIT 5 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070613 ORDER BY `minOrder` ASC [ RunTime:0.000899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070613 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070613 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070613 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='293606-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293606-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000348s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070613 AND `partno` = '293606-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277807 LIMIT 5 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277807 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277807 ORDER BY `unit` DESC [ RunTime:0.000268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277807 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277807 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='293687-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293687-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000337s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277807 AND `partno` = '293687-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163305 [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163305 LIMIT 5 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163305 ORDER BY `minOrder` ASC [ RunTime:0.002711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163305 ORDER BY `unit` DESC [ RunTime:0.000270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163305 LIMIT 2 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163305 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='293687-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293687-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000344s ]
SELECT `id` FROM `stock` WHERE `id` <> 32163305 AND `partno` = '293687-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277807 [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070552 LIMIT 5 [ RunTime:0.000251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070552 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070552 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070552 LIMIT 2 [ RunTime:0.000251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070552 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='293688-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293688-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000328s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070552 AND `partno` = '293688-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070270 LIMIT 5 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070270 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070270 ORDER BY `unit` DESC [ RunTime:0.000266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070270 LIMIT 2 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070270 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='293687-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293687-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000341s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070270 AND `partno` = '293687-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277804 LIMIT 5 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277804 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277804 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277804 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277804 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
select * from pdf where partno='293656-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293656-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000301s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277804 AND `partno` = '293656-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163302 [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163302 LIMIT 5 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163302 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163302 ORDER BY `unit` DESC [ RunTime:0.000221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163302 LIMIT 2 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163302 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
select * from pdf where partno='293656-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293656-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000264s ]
SELECT `id` FROM `stock` WHERE `id` <> 32163302 AND `partno` = '293656-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277804 [ RunTime:0.000209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070550 LIMIT 5 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070550 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070550 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070550 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070550 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
select * from pdf where partno='293615-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293615-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000263s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070550 AND `partno` = '293615-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71808264 LIMIT 5 [ RunTime:0.000206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808264 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71808264 ORDER BY `unit` DESC [ RunTime:0.000206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71808264 LIMIT 2 [ RunTime:0.000200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808264 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='293660-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293660-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000309s ]
SELECT `id` FROM `stock` WHERE `id` <> 71808264 AND `partno` = '293660-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070616 LIMIT 5 [ RunTime:0.000258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070616 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070616 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070616 LIMIT 2 [ RunTime:0.000239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070616 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
select * from pdf where partno='293657-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293657-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000309s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070616 AND `partno` = '293657-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277806 LIMIT 5 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277806 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277806 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277806 LIMIT 2 [ RunTime:0.000202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277806 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='293673-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293673-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000260s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277806 AND `partno` = '293673-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163304 [ RunTime:0.000248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163304 LIMIT 5 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163304 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163304 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163304 LIMIT 2 [ RunTime:0.000199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163304 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='293673-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293673-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000292s ]
SELECT `id` FROM `stock` WHERE `id` <> 32163304 AND `partno` = '293673-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277806 [ RunTime:0.000206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070615 LIMIT 5 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070615 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070615 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070615 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070615 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='293616-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293616-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000257s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070615 AND `partno` = '293616-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51070614 LIMIT 5 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070614 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51070614 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51070614 LIMIT 2 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51070614 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='293607-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293607-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000316s ]
SELECT `id` FROM `stock` WHERE `id` <> 51070614 AND `partno` = '293607-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71808209 LIMIT 5 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808209 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71808209 ORDER BY `unit` DESC [ RunTime:0.000264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71808209 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808209 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='293658-1' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.000364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293658-1' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.000323s ]
SELECT `id` FROM `stock` WHERE `id` <> 71808209 AND `partno` = '293658-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / p&b%' ) [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71808265 LIMIT 5 [ RunTime:0.000213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808265 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71808265 ORDER BY `unit` DESC [ RunTime:0.000212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71808265 LIMIT 2 [ RunTime:0.000200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71808265 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='293660-6' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293660-6' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000322s ]
SELECT `id` FROM `stock` WHERE `id` <> 71808265 AND `partno` = '293660-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71763157 LIMIT 5 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71763157 ORDER BY `minOrder` ASC [ RunTime:0.003854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71763157 ORDER BY `unit` DESC [ RunTime:0.000221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71763157 LIMIT 2 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71763157 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='2936' and brandshort='jkl components' limit 1 [ RunTime:0.000407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2936' OR `brand` LIKE 'jkl components%' ) ) LIMIT 1 [ RunTime:0.000390s ]
SELECT `id` FROM `stock` WHERE `id` <> 71763157 AND `partno` = '2936' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jkl components%' ) [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18912762 [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277884 LIMIT 5 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277884 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277884 ORDER BY `unit` DESC [ RunTime:0.000220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277884 LIMIT 2 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277884 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='293655-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293655-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.009639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163382 LIMIT 5 [ RunTime:0.000257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163382 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163382 ORDER BY `unit` DESC [ RunTime:0.000216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163382 LIMIT 2 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163382 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
select * from pdf where partno='293655-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293655-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.008437s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927141 LIMIT 5 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927141 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927141 ORDER BY `unit` DESC [ RunTime:0.000218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927141 LIMIT 2 [ RunTime:0.000203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927141 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='293649-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293649-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000271s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927141 AND `partno` = '293649-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668648 [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67808602 LIMIT 5 [ RunTime:0.000224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808602 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67808602 ORDER BY `unit` DESC [ RunTime:0.000215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67808602 LIMIT 2 [ RunTime:0.000202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808602 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
select * from pdf where partno='293660-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293660-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000256s ]
SELECT `id` FROM `stock` WHERE `id` <> 67808602 AND `partno` = '293660-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667941 [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927145 LIMIT 5 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927145 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927145 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927145 LIMIT 2 [ RunTime:0.000199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927145 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
select * from pdf where partno='293615-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293615-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000253s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927145 AND `partno` = '293615-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668616 [ RunTime:0.000228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927171 LIMIT 5 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927171 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927171 ORDER BY `unit` DESC [ RunTime:0.000241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927171 LIMIT 2 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927171 ORDER BY `minOrder` ASC [ RunTime:0.000228s ]
select * from pdf where partno='293653-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293653-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000252s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927171 AND `partno` = '293653-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668542 [ RunTime:0.000234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927185 LIMIT 5 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927185 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927185 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927185 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927185 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='293650-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293650-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000254s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927185 AND `partno` = '293650-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668559 [ RunTime:0.000229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927161 LIMIT 5 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927161 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927161 ORDER BY `unit` DESC [ RunTime:0.000223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927161 LIMIT 2 [ RunTime:0.000240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927161 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='293652-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293652-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000257s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927161 AND `partno` = '293652-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668627 [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927184 LIMIT 5 [ RunTime:0.000207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927184 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927184 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927184 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927184 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='293696-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293696-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000254s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927184 AND `partno` = '293696-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668656 [ RunTime:0.000226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927202 LIMIT 5 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927202 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927202 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927202 LIMIT 2 [ RunTime:0.000200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927202 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='293648-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293648-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000255s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927202 AND `partno` = '293648-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313915 [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927132 LIMIT 5 [ RunTime:0.000209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927132 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927132 ORDER BY `unit` DESC [ RunTime:0.000210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927132 LIMIT 2 [ RunTime:0.000202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927132 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
select * from pdf where partno='293652-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293652-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000273s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927132 AND `partno` = '293652-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668638 [ RunTime:0.000227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927180 LIMIT 5 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927180 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927180 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927180 LIMIT 2 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927180 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
select * from pdf where partno='293605-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293605-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000253s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927180 AND `partno` = '293605-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668553 [ RunTime:0.000239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927140 LIMIT 5 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927140 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927140 ORDER BY `unit` DESC [ RunTime:0.000205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927140 LIMIT 2 [ RunTime:0.000198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927140 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
select * from pdf where partno='293602-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293602-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000249s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927140 AND `partno` = '293602-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668544 [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927159 LIMIT 5 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927159 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927159 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927159 LIMIT 2 [ RunTime:0.000198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927159 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
select * from pdf where partno='293651-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293651-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000260s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927159 AND `partno` = '293651-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668545 [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67808689 LIMIT 5 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808689 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67808689 ORDER BY `unit` DESC [ RunTime:0.000252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67808689 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808689 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='293607-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293607-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000259s ]
SELECT `id` FROM `stock` WHERE `id` <> 67808689 AND `partno` = '293607-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454152 [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927162 LIMIT 5 [ RunTime:0.000202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927162 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927162 ORDER BY `unit` DESC [ RunTime:0.000210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927162 LIMIT 2 [ RunTime:0.000215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927162 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
select * from pdf where partno='293688-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293688-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000306s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927162 AND `partno` = '293688-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668628 [ RunTime:0.000225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67808603 LIMIT 5 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808603 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67808603 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67808603 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808603 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='293660-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293660-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000304s ]
SELECT `id` FROM `stock` WHERE `id` <> 67808603 AND `partno` = '293660-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313758 [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927129 LIMIT 5 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927129 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927129 ORDER BY `unit` DESC [ RunTime:0.000206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927129 LIMIT 2 [ RunTime:0.000199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927129 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
select * from pdf where partno='293653-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293653-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000308s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927129 AND `partno` = '293653-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668634 [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927160 LIMIT 5 [ RunTime:0.000202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927160 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927160 ORDER BY `unit` DESC [ RunTime:0.000204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927160 LIMIT 2 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927160 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='293688-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293688-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000249s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927160 AND `partno` = '293688-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668531 [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67808666 LIMIT 5 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808666 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67808666 ORDER BY `unit` DESC [ RunTime:0.000206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67808666 LIMIT 2 [ RunTime:0.000200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67808666 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
select * from pdf where partno='293682-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293682-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000254s ]
SELECT `id` FROM `stock` WHERE `id` <> 67808666 AND `partno` = '293682-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667970 [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927187 LIMIT 5 [ RunTime:0.000212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927187 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927187 ORDER BY `unit` DESC [ RunTime:0.000204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927187 LIMIT 2 [ RunTime:0.000201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927187 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
select * from pdf where partno='293611-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293611-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000254s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927187 AND `partno` = '293611-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668660 [ RunTime:0.000228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68927049 LIMIT 5 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927049 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68927049 ORDER BY `unit` DESC [ RunTime:0.000215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68927049 LIMIT 2 [ RunTime:0.000197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68927049 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='293650-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '293650-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000251s ]
SELECT `id` FROM `stock` WHERE `id` <> 68927049 AND `partno` = '293650-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668801 [ RunTime:0.000232s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000477s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000410s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000389s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000392s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000380s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000378s ]
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 '2936%' OR `brand` LIKE '2936%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000414s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2936%' OR `brand` LIKE '2936%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000838s ]