SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002504s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005522s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422447 LIMIT 5 [ RunTime:0.002001s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422447 ORDER BY `minOrder` ASC [ RunTime:0.001507s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422447 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422447 LIMIT 2 [ RunTime:0.003549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422447 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301399 LIMIT 5 [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301399 ORDER BY `minOrder` ASC [ RunTime:0.000831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32301399 ORDER BY `unit` DESC [ RunTime:0.003499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32301399 LIMIT 2 [ RunTime:0.001648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301399 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='2510949-1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.004751s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510949-1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.001193s ]
SELECT `id` FROM `stock` WHERE `id` <> 32301399 AND `partno` = '2510949-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273429 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273429 LIMIT 5 [ RunTime:0.000854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273429 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32273429 ORDER BY `unit` DESC [ RunTime:0.002358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32273429 LIMIT 2 [ RunTime:0.001593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273429 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='2510949-1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.000454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510949-1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.000396s ]
SELECT `id` FROM `stock` WHERE `id` <> 32273429 AND `partno` = '2510949-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301399 [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301578 LIMIT 5 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301578 ORDER BY `minOrder` ASC [ RunTime:0.003061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32301578 ORDER BY `unit` DESC [ RunTime:0.002147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32301578 LIMIT 2 [ RunTime:0.002875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301578 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='2510950-1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.000680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510950-1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.005773s ]
SELECT `id` FROM `stock` WHERE `id` <> 32301578 AND `partno` = '2510950-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.001564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273612 [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273612 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273612 ORDER BY `minOrder` ASC [ RunTime:0.002214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32273612 ORDER BY `unit` DESC [ RunTime:0.000530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32273612 LIMIT 2 [ RunTime:0.001398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273612 ORDER BY `minOrder` ASC [ RunTime:0.003066s ]
select * from pdf where partno='2510950-1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.000649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510950-1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 32273612 AND `partno` = '2510950-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301578 [ RunTime:0.001346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301467 LIMIT 5 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301467 ORDER BY `minOrder` ASC [ RunTime:0.009576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32301467 ORDER BY `unit` DESC [ RunTime:0.000887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32301467 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32301467 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='2510943-1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.000870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510943-1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 32301467 AND `partno` = '2510943-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.000686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273665 [ RunTime:0.009143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273665 LIMIT 5 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273665 ORDER BY `minOrder` ASC [ RunTime:0.000977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32273665 ORDER BY `unit` DESC [ RunTime:0.003754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32273665 LIMIT 2 [ RunTime:0.007179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273665 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='2510943-1' and brandshort='te connectivity / linx technologies' limit 1 [ RunTime:0.000581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510943-1' OR `brand` LIKE 'te connectivity / linx technologies%' ) ) LIMIT 1 [ RunTime:0.000401s ]
SELECT `id` FROM `stock` WHERE `id` <> 32273665 AND `partno` = '2510943-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / linx technologies%' ) [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32301467 [ RunTime:0.002827s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48077007 LIMIT 5 [ RunTime:0.001892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48077007 ORDER BY `minOrder` ASC [ RunTime:0.002072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48077007 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48077007 LIMIT 2 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48077007 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='2510981-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510981-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000524s ]
SELECT `id` FROM `stock` WHERE `id` <> 48077007 AND `partno` = '2510981-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.005894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267634 [ RunTime:0.007447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267634 LIMIT 5 [ RunTime:0.001569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267634 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267634 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267634 LIMIT 2 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267634 ORDER BY `minOrder` ASC [ RunTime:0.001654s ]
select * from pdf where partno='2510981-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510981-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000327s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267634 AND `partno` = '2510981-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.003212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48077007 [ RunTime:0.007897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53785508 LIMIT 5 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53785508 ORDER BY `minOrder` ASC [ RunTime:0.001095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53785508 ORDER BY `unit` DESC [ RunTime:0.007527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53785508 LIMIT 2 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53785508 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='2510983-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510983-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000478s ]
SELECT `id` FROM `stock` WHERE `id` <> 53785508 AND `partno` = '2510983-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48077045 LIMIT 5 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48077045 ORDER BY `minOrder` ASC [ RunTime:0.004515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48077045 ORDER BY `unit` DESC [ RunTime:0.001249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48077045 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48077045 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='2510969-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510969-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.004480s ]
SELECT `id` FROM `stock` WHERE `id` <> 48077045 AND `partno` = '2510969-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.002494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267672 [ RunTime:0.002114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48077044 LIMIT 5 [ RunTime:0.001045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48077044 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48077044 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48077044 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48077044 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='2510968-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510968-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.003169s ]
SELECT `id` FROM `stock` WHERE `id` <> 48077044 AND `partno` = '2510968-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.001971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267671 [ RunTime:0.002661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076977 LIMIT 5 [ RunTime:0.001265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076977 ORDER BY `minOrder` ASC [ RunTime:0.007904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076977 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076977 LIMIT 2 [ RunTime:0.004590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076977 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='2510950-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.001008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510950-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.001594s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076977 AND `partno` = '2510950-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267603 [ RunTime:0.001458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076976 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076976 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076976 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076976 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076976 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='2510955-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510955-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.003808s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076976 AND `partno` = '2510955-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.001570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267602 [ RunTime:0.001123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076969 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076969 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076969 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076969 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076969 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='2510975-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510975-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.002400s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076969 AND `partno` = '2510975-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267596 [ RunTime:0.002134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076968 LIMIT 5 [ RunTime:0.004030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076968 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076968 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076968 LIMIT 2 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076968 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='2510957-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.001136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510957-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.004007s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076968 AND `partno` = '2510957-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.001794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267595 [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076967 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076967 ORDER BY `minOrder` ASC [ RunTime:0.004447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076967 ORDER BY `unit` DESC [ RunTime:0.005564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076967 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076967 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='2510959-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.001421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510959-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.004389s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076967 AND `partno` = '2510959-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.006980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267594 [ RunTime:0.001233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076966 LIMIT 5 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076966 ORDER BY `minOrder` ASC [ RunTime:0.003693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076966 ORDER BY `unit` DESC [ RunTime:0.003308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076966 LIMIT 2 [ RunTime:0.008653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076966 ORDER BY `minOrder` ASC [ RunTime:0.002985s ]
select * from pdf where partno='2510973-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.001130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510973-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000748s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076966 AND `partno` = '2510973-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.002971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267593 [ RunTime:0.006238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076941 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076941 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48076941 ORDER BY `unit` DESC [ RunTime:0.002812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48076941 LIMIT 2 [ RunTime:0.001494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48076941 ORDER BY `minOrder` ASC [ RunTime:0.001203s ]
select * from pdf where partno='2510954-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.002196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510954-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.004040s ]
SELECT `id` FROM `stock` WHERE `id` <> 48076941 AND `partno` = '2510954-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.002017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267569 [ RunTime:0.001439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267672 LIMIT 5 [ RunTime:0.001077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267672 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267672 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267672 LIMIT 2 [ RunTime:0.002479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267672 ORDER BY `minOrder` ASC [ RunTime:0.002596s ]
select * from pdf where partno='2510969-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510969-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000441s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267672 AND `partno` = '2510969-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48077045 [ RunTime:0.000827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267671 LIMIT 5 [ RunTime:0.002870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267671 ORDER BY `minOrder` ASC [ RunTime:0.008158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267671 ORDER BY `unit` DESC [ RunTime:0.002864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267671 LIMIT 2 [ RunTime:0.003095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267671 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='2510968-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510968-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000376s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267671 AND `partno` = '2510968-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.001231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48077044 [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267603 LIMIT 5 [ RunTime:0.000805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267603 ORDER BY `minOrder` ASC [ RunTime:0.000936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267603 ORDER BY `unit` DESC [ RunTime:0.001618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267603 LIMIT 2 [ RunTime:0.003675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267603 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
select * from pdf where partno='2510950-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510950-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267603 AND `partno` = '2510950-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.006945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076977 [ RunTime:0.003846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267602 LIMIT 5 [ RunTime:0.002102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267602 ORDER BY `minOrder` ASC [ RunTime:0.001897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267602 ORDER BY `unit` DESC [ RunTime:0.000840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267602 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267602 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='2510955-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510955-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000421s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267602 AND `partno` = '2510955-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076976 [ RunTime:0.003317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267596 LIMIT 5 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267596 ORDER BY `minOrder` ASC [ RunTime:0.002352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267596 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267596 LIMIT 2 [ RunTime:0.005645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267596 ORDER BY `minOrder` ASC [ RunTime:0.004485s ]
select * from pdf where partno='2510975-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510975-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000483s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267596 AND `partno` = '2510975-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.002167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076969 [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267595 LIMIT 5 [ RunTime:0.001217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267595 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267595 ORDER BY `unit` DESC [ RunTime:0.008046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267595 LIMIT 2 [ RunTime:0.014012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267595 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='2510957-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510957-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000459s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267595 AND `partno` = '2510957-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076968 [ RunTime:0.008556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267594 LIMIT 5 [ RunTime:0.001823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267594 ORDER BY `minOrder` ASC [ RunTime:0.003251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267594 ORDER BY `unit` DESC [ RunTime:0.001038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267594 LIMIT 2 [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267594 ORDER BY `minOrder` ASC [ RunTime:0.009660s ]
select * from pdf where partno='2510959-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510959-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000480s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267594 AND `partno` = '2510959-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.003086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076967 [ RunTime:0.001288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35267593 LIMIT 5 [ RunTime:0.001000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267593 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35267593 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35267593 LIMIT 2 [ RunTime:0.003519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35267593 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='2510973-1' and brandshort='TE Connectivity Linx' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2510973-1' OR `brand` LIKE 'TE Connectivity Linx%' ) ) LIMIT 1 [ RunTime:0.000709s ]
SELECT `id` FROM `stock` WHERE `id` <> 35267593 AND `partno` = '2510973-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity linx%' ) [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48076966 [ RunTime:0.004439s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002357s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008347s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001752s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002767s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023486s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002469s ]
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 '25109%' OR `brand` LIKE '25109%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001748s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25109%' OR `brand` LIKE '25109%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004223s ]