SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002378s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000587s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002445s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.187' ) [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002070s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000322s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 127 LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 127 [ RunTime:0.000235s ]
SELECT `id`,`name` FROM `product_type` WHERE `typeid` = 21 [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001448s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `status` <> 2 AND `categoryid` = 127 ) [ RunTime:0.001057s ]
SELECT `s`.`id`,`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 ( `status` <> 2 AND `categoryid` = 127 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 180,20 [ RunTime:0.005557s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3440 LIMIT 4 [ RunTime:0.000200s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3440 ORDER BY `minOrder` ASC [ RunTime:0.000198s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3440 ORDER BY `unit` DESC [ RunTime:0.000158s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3440 LIMIT 2 [ RunTime:0.000154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3440 ORDER BY `minOrder` ASC [ RunTime:0.000158s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPG-1608ZGC' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5377 LIMIT 4 [ RunTime:0.000156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5377 ORDER BY `minOrder` ASC [ RunTime:0.000152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5377 ORDER BY `unit` DESC [ RunTime:0.000148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5377 LIMIT 2 [ RunTime:0.000144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5377 ORDER BY `minOrder` ASC [ RunTime:0.000178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-2012EC' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14694 LIMIT 4 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14694 ORDER BY `unit` DESC [ RunTime:0.006566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14694 LIMIT 2 [ RunTime:0.022468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14694 ORDER BY `minOrder` ASC [ RunTime:0.006562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '113-314-01' OR `brand` LIKE 'MARL%' ) ) LIMIT 1 [ RunTime:0.001580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9051 LIMIT 4 [ RunTime:0.003236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9051 ORDER BY `minOrder` ASC [ RunTime:0.019369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9051 ORDER BY `unit` DESC [ RunTime:0.006590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9051 LIMIT 2 [ RunTime:0.005069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9051 ORDER BY `minOrder` ASC [ RunTime:0.006267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SML-E12Y8WT86' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.004554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3443 LIMIT 4 [ RunTime:0.004233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3443 ORDER BY `minOrder` ASC [ RunTime:0.002640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3443 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3443 LIMIT 2 [ RunTime:0.005002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3443 ORDER BY `minOrder` ASC [ RunTime:0.002059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPHCM-2012SECK' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.007178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5043 LIMIT 4 [ RunTime:0.008008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5043 ORDER BY `minOrder` ASC [ RunTime:0.007645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5043 ORDER BY `unit` DESC [ RunTime:0.005687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5043 LIMIT 2 [ RunTime:0.003947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5043 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L-1334GT' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5814 LIMIT 4 [ RunTime:0.003513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5814 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5814 ORDER BY `unit` DESC [ RunTime:0.009139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5814 LIMIT 2 [ RunTime:0.005089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5814 ORDER BY `minOrder` ASC [ RunTime:0.004262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPTR-3216QBC-D' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10615 LIMIT 4 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10615 ORDER BY `minOrder` ASC [ RunTime:0.004639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10615 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10615 LIMIT 2 [ RunTime:0.009845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10615 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2213831-2' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.014251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7051 LIMIT 4 [ RunTime:0.005590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7051 ORDER BY `minOrder` ASC [ RunTime:0.007881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7051 ORDER BY `unit` DESC [ RunTime:0.004837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7051 LIMIT 2 [ RunTime:0.006599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7051 ORDER BY `minOrder` ASC [ RunTime:0.002696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPTBD-3216SURKCGKC' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2770 LIMIT 4 [ RunTime:0.007672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2770 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2770 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2770 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2770 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCL053GD' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.004703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2561 LIMIT 4 [ RunTime:0.005411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2561 ORDER BY `minOrder` ASC [ RunTime:0.015136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2561 ORDER BY `unit` DESC [ RunTime:0.004074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2561 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2561 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '555-2303F' OR `brand` LIKE 'DIALIGHT%' ) ) LIMIT 1 [ RunTime:0.001293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12636 LIMIT 4 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12636 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12636 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12636 LIMIT 2 [ RunTime:0.004050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12636 ORDER BY `minOrder` ASC [ RunTime:0.007628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SML-522MD8WT86' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.006275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8244 LIMIT 4 [ RunTime:0.008627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8244 ORDER BY `minOrder` ASC [ RunTime:0.008102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8244 ORDER BY `unit` DESC [ RunTime:0.001846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8244 LIMIT 2 [ RunTime:0.012794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8244 ORDER BY `minOrder` ASC [ RunTime:0.003929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CAT4104VP2-GT3' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.024712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8425 LIMIT 4 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8425 ORDER BY `minOrder` ASC [ RunTime:0.003205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8425 ORDER BY `unit` DESC [ RunTime:0.001016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8425 LIMIT 2 [ RunTime:0.008234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8425 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KPT-2012LVSECK-J4-PRV' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4672 LIMIT 4 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4672 ORDER BY `minOrder` ASC [ RunTime:0.000798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4672 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4672 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4672 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE-3081' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693 LIMIT 4 [ RunTime:0.001508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693 ORDER BY `minOrder` ASC [ RunTime:0.001436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693 ORDER BY `unit` DESC [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '113-305-01' OR `brand` LIKE 'MARL%' ) ) LIMIT 1 [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10017 LIMIT 4 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10017 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10017 ORDER BY `unit` DESC [ RunTime:0.000248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10017 LIMIT 2 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10017 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='150040YS73240' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.000559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '150040YS73240' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2771 LIMIT 4 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2771 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2771 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2771 LIMIT 2 [ RunTime:0.003554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2771 ORDER BY `minOrder` ASC [ RunTime:0.003507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCL034SYC' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.003194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2428 LIMIT 4 [ RunTime:0.006258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2428 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2428 ORDER BY `unit` DESC [ RunTime:0.003707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2428 LIMIT 2 [ RunTime:0.005620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2428 ORDER BY `minOrder` ASC [ RunTime:0.002332s ]
select * from pdf where partno='OVLBR4C7' and brandshort='TT ELECTRONICS / OPTEK TECHNOLOGY' limit 1 [ RunTime:0.003303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OVLBR4C7' OR `brand` LIKE 'TT ELECTRONICS / OPTEK TECHNOLOGY%' ) ) LIMIT 1 [ RunTime:0.003791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14495 LIMIT 4 [ RunTime:0.001959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14495 ORDER BY `minOrder` ASC [ RunTime:0.001728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14495 ORDER BY `unit` DESC [ RunTime:0.001939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14495 LIMIT 2 [ RunTime:0.007125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14495 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LED3-16' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.000183s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 AND `categoryid` = 127 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000219s ]