SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002044s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&page=3&srecordnum=1120&status=4' [ RunTime:0.020167s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001923s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.033092s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001764s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.028539s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001819s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.019170s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003639s ]
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 `s`.`status` = '4' AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.107257s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213 LIMIT 4 [ RunTime:0.065468s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.073522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213 ORDER BY `minOrder` ASC [ RunTime:0.050631s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213 ORDER BY `unit` DESC [ RunTime:0.073624s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.034877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213 LIMIT 2 [ RunTime:0.031570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213 ORDER BY `minOrder` ASC [ RunTime:0.020056s ]
select * from pdf where partno='640545-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.051507s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '640545-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.028217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212 LIMIT 4 [ RunTime:0.018702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212 ORDER BY `minOrder` ASC [ RunTime:0.032290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16212 ORDER BY `unit` DESC [ RunTime:0.064268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16212 LIMIT 2 [ RunTime:0.020958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212 ORDER BY `minOrder` ASC [ RunTime:0.038178s ]
select * from pdf where partno='0461164281.' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.065227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0461164281.' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.054215s ]
SELECT `id` FROM `stock` WHERE `id` <> 16212 AND `partno` = '0461164281.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.091208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1890 [ RunTime:0.029621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16211 LIMIT 4 [ RunTime:0.022093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211 ORDER BY `minOrder` ASC [ RunTime:0.069482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16211 ORDER BY `unit` DESC [ RunTime:0.019289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16211 LIMIT 2 [ RunTime:0.019601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16211 ORDER BY `minOrder` ASC [ RunTime:0.016418s ]
select * from pdf where partno='1123580000' and brandshort='WEIDMULLER' limit 1 [ RunTime:0.006055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1123580000' OR `brand` LIKE 'WEIDMULLER%' ) ) LIMIT 1 [ RunTime:0.018472s ]
SELECT `id` FROM `stock` WHERE `id` <> 16211 AND `partno` = '1123580000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.004483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9091 [ RunTime:0.005931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17147746 [ RunTime:0.014650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210 LIMIT 4 [ RunTime:0.081461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210 ORDER BY `minOrder` ASC [ RunTime:0.041629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16210 ORDER BY `unit` DESC [ RunTime:0.040400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16210 LIMIT 2 [ RunTime:0.078445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210 ORDER BY `minOrder` ASC [ RunTime:0.094259s ]
select * from pdf where partno='ERA6AEB103V' and brandshort='PANASONIC' limit 1 [ RunTime:0.054557s ]
select foldpath,foldpath2,filename from pdf_file where id=1488371 limit 1 [ RunTime:0.078296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERA6AEB103V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.104538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209 LIMIT 4 [ RunTime:0.074198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209 ORDER BY `minOrder` ASC [ RunTime:0.094521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209 ORDER BY `unit` DESC [ RunTime:0.051872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209 LIMIT 2 [ RunTime:0.094037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209 ORDER BY `minOrder` ASC [ RunTime:0.019062s ]
select * from pdf where partno='353620350' and brandshort='MOLEX' limit 1 [ RunTime:0.099591s ]
select foldpath,foldpath2,filename from pdf_file where id=849183 limit 1 [ RunTime:0.067844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '353620350' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.070172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208 LIMIT 4 [ RunTime:0.079407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208 ORDER BY `minOrder` ASC [ RunTime:0.124001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208 ORDER BY `unit` DESC [ RunTime:0.045075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208 LIMIT 2 [ RunTime:0.040727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208 ORDER BY `minOrder` ASC [ RunTime:0.026676s ]
select * from pdf where partno='BCX56-10TX' and brandshort='NEXPERIA' limit 1 [ RunTime:0.050837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BCX56-10TX' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.094724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207 LIMIT 4 [ RunTime:0.030404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207 ORDER BY `minOrder` ASC [ RunTime:0.021531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16207 ORDER BY `unit` DESC [ RunTime:0.029718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16207 LIMIT 2 [ RunTime:0.041270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207 ORDER BY `minOrder` ASC [ RunTime:0.011354s ]
select * from pdf where partno='BSC014NE2LSIATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.026208s ]
select foldpath,foldpath2,filename from pdf_file where id=1350976 limit 1 [ RunTime:0.042615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSC014NE2LSIATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.008677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16206 LIMIT 4 [ RunTime:0.028817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206 ORDER BY `minOrder` ASC [ RunTime:0.026885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16206 ORDER BY `unit` DESC [ RunTime:0.051351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16206 LIMIT 2 [ RunTime:0.037256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16206 ORDER BY `minOrder` ASC [ RunTime:0.073075s ]
select * from pdf where partno='5103308-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.023155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103308-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006615s ]
SELECT `id` FROM `stock` WHERE `id` <> 16206 AND `partno` = '5103308-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.021051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2633 [ RunTime:0.107392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205 LIMIT 4 [ RunTime:0.042772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205 ORDER BY `minOrder` ASC [ RunTime:0.068678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16205 ORDER BY `unit` DESC [ RunTime:0.059139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16205 LIMIT 2 [ RunTime:0.211322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205 ORDER BY `minOrder` ASC [ RunTime:0.069433s ]
select * from pdf where partno='AD7684BRMZRL7' and brandshort='ANALOG DEVICES' limit 1 [ RunTime:0.052941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AD7684BRMZRL7' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.052620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16204 LIMIT 4 [ RunTime:0.062217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16204 ORDER BY `minOrder` ASC [ RunTime:0.051535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16204 ORDER BY `unit` DESC [ RunTime:0.102684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16204 LIMIT 2 [ RunTime:0.081859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16204 ORDER BY `minOrder` ASC [ RunTime:0.057910s ]
select * from pdf where partno='ERJ6ENF10R0V' and brandshort='PANASONIC' limit 1 [ RunTime:0.069235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ6ENF10R0V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.029838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16203 LIMIT 4 [ RunTime:0.034296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203 ORDER BY `minOrder` ASC [ RunTime:0.042061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16203 ORDER BY `unit` DESC [ RunTime:0.017993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16203 LIMIT 2 [ RunTime:0.046508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203 ORDER BY `minOrder` ASC [ RunTime:0.071522s ]
select * from pdf where partno='BUK7S0R7-40HJ' and brandshort='NEXPERIA' limit 1 [ RunTime:0.000814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BUK7S0R7-40HJ' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.092026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16202 LIMIT 4 [ RunTime:0.061611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16202 ORDER BY `minOrder` ASC [ RunTime:0.107189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16202 ORDER BY `unit` DESC [ RunTime:0.052698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16202 LIMIT 2 [ RunTime:0.138475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16202 ORDER BY `minOrder` ASC [ RunTime:0.016485s ]
select * from pdf where partno='ERJ-PB3B6192V' and brandshort='PANASONIC' limit 1 [ RunTime:0.093258s ]
select foldpath,foldpath2,filename from pdf_file where id=1976083 limit 1 [ RunTime:0.088071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ-PB3B6192V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.052940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16201 LIMIT 4 [ RunTime:0.019437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201 ORDER BY `minOrder` ASC [ RunTime:0.054755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16201 ORDER BY `unit` DESC [ RunTime:0.038989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16201 LIMIT 2 [ RunTime:0.032462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16201 ORDER BY `minOrder` ASC [ RunTime:0.019271s ]
select * from pdf where partno='MMSZ5250B' and brandshort='DIODES INC.' limit 1 [ RunTime:0.068693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMSZ5250B' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.058390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16200 LIMIT 4 [ RunTime:0.053316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16200 ORDER BY `minOrder` ASC [ RunTime:0.036307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16200 ORDER BY `unit` DESC [ RunTime:0.123900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16200 LIMIT 2 [ RunTime:0.070646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16200 ORDER BY `minOrder` ASC [ RunTime:0.010159s ]
select * from pdf where partno='779678-01' and brandshort='NI' limit 1 [ RunTime:0.041937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '779678-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.028037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16199 LIMIT 4 [ RunTime:0.027852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16199 ORDER BY `minOrder` ASC [ RunTime:0.076251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16199 ORDER BY `unit` DESC [ RunTime:0.070672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16199 LIMIT 2 [ RunTime:0.023105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16199 ORDER BY `minOrder` ASC [ RunTime:0.038401s ]
select * from pdf where partno='CRCW06030000Z0EA' and brandshort='VISHAY' limit 1 [ RunTime:0.071092s ]
select foldpath,foldpath2,filename from pdf_file where id=1141019 limit 1 [ RunTime:0.055075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW06030000Z0EA' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.043587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16198 LIMIT 4 [ RunTime:0.047020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16198 ORDER BY `minOrder` ASC [ RunTime:0.107722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16198 ORDER BY `unit` DESC [ RunTime:0.067185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16198 LIMIT 2 [ RunTime:0.037926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16198 ORDER BY `minOrder` ASC [ RunTime:0.029651s ]
select * from pdf where partno='3-644615-4' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.048044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3-644615-4' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.127477s ]
SELECT `id` FROM `stock` WHERE `id` <> 16198 AND `partno` = '3-644615-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.027056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11025 [ RunTime:0.033287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197 LIMIT 4 [ RunTime:0.051802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197 ORDER BY `minOrder` ASC [ RunTime:0.019592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197 ORDER BY `unit` DESC [ RunTime:0.024287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197 LIMIT 2 [ RunTime:0.098495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197 ORDER BY `minOrder` ASC [ RunTime:0.011974s ]
select * from pdf where partno='US1MFA' and brandshort='ONSEMI' limit 1 [ RunTime:0.060568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US1MFA' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.020383s ]
SELECT `id` FROM `stock` WHERE `id` <> 16197 AND `partno` = 'US1MFA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.054165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11237 [ RunTime:0.021776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079576 [ RunTime:0.024310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196 LIMIT 4 [ RunTime:0.012841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196 ORDER BY `minOrder` ASC [ RunTime:0.023471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196 ORDER BY `unit` DESC [ RunTime:0.013359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196 LIMIT 2 [ RunTime:0.023920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196 ORDER BY `minOrder` ASC [ RunTime:0.013318s ]
select * from pdf where partno='03-09-1032' and brandshort='MOLEX' limit 1 [ RunTime:0.013400s ]
select foldpath,foldpath2,filename from pdf_file where id=821118 limit 1 [ RunTime:0.008863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '03-09-1032' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.021533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16195 LIMIT 4 [ RunTime:0.075897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16195 ORDER BY `minOrder` ASC [ RunTime:0.041830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16195 ORDER BY `unit` DESC [ RunTime:0.058944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16195 LIMIT 2 [ RunTime:0.044017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16195 ORDER BY `minOrder` ASC [ RunTime:0.008381s ]
select * from pdf where partno='CRCW0402300KFKED' and brandshort='VISHAY' limit 1 [ RunTime:0.021855s ]
select foldpath,foldpath2,filename from pdf_file where id=1245034 limit 1 [ RunTime:0.007003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW0402300KFKED' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.013709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194 LIMIT 4 [ RunTime:0.017635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.024549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16194 ORDER BY `unit` DESC [ RunTime:0.022792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16194 LIMIT 2 [ RunTime:0.058285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194 ORDER BY `minOrder` ASC [ RunTime:0.005904s ]
select * from pdf where partno='61794-1.' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.032839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '61794-1.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.023849s ]
SELECT `id` FROM `stock` WHERE `id` <> 16194 AND `partno` = '61794-1.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.011649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3963 [ RunTime:0.024479s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.034120s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.047788s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.023358s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (21,17,252,16,29,132,127,117,40,481,541,282,671,615,23,577,20,86,377,313,156,148,204,636,39,643,410,113,186,544,369,516,277,134,601,347,105,482,623,133,121,106,432,512,592,326,35,279,152,309,403,517,376,676,296,287,420,490,621,293) [ RunTime:0.010421s ]