SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001884s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=BSE-1&search=1' [ RunTime:0.004383s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002080s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002108s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002333s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.006559s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001902s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005701s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001890s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BSE-1' LIMIT 1 [ RunTime:0.012408s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-10 07:11:30' WHERE `partno` = 'BSE-1' [ RunTime:0.005976s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002359s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027454s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793293 LIMIT 5 [ RunTime:0.008629s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793293 ORDER BY `minOrder` ASC [ RunTime:0.009920s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12793293 ORDER BY `unit` DESC [ RunTime:0.010387s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12793293 LIMIT 2 [ RunTime:0.002765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12793293 ORDER BY `minOrder` ASC [ RunTime:0.002613s ]
select * from pdf where partno='BSE-120-01-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792867 LIMIT 5 [ RunTime:0.005598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792867 ORDER BY `minOrder` ASC [ RunTime:0.006770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792867 ORDER BY `unit` DESC [ RunTime:0.007495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792867 LIMIT 2 [ RunTime:0.008665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792867 ORDER BY `minOrder` ASC [ RunTime:0.014634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792789 LIMIT 5 [ RunTime:0.014410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792789 ORDER BY `minOrder` ASC [ RunTime:0.014266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792789 ORDER BY `unit` DESC [ RunTime:0.014073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792789 LIMIT 2 [ RunTime:0.005005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792789 ORDER BY `minOrder` ASC [ RunTime:0.005543s ]
select * from pdf where partno='BSE-120-01-H-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12790877 LIMIT 5 [ RunTime:0.022100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12790877 ORDER BY `minOrder` ASC [ RunTime:0.012403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12790877 ORDER BY `unit` DESC [ RunTime:0.017408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12790877 LIMIT 2 [ RunTime:0.028064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12790877 ORDER BY `minOrder` ASC [ RunTime:0.011498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12790876 LIMIT 5 [ RunTime:0.011188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12790876 ORDER BY `minOrder` ASC [ RunTime:0.019744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12790876 ORDER BY `unit` DESC [ RunTime:0.015288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12790876 LIMIT 2 [ RunTime:0.013588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12790876 ORDER BY `minOrder` ASC [ RunTime:0.030196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12789456 LIMIT 5 [ RunTime:0.018014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12789456 ORDER BY `minOrder` ASC [ RunTime:0.017297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12789456 ORDER BY `unit` DESC [ RunTime:0.039696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12789456 LIMIT 2 [ RunTime:0.009592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12789456 ORDER BY `minOrder` ASC [ RunTime:0.021294s ]
select * from pdf where partno='BSE-120-01-C-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12789421 LIMIT 5 [ RunTime:0.040866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12789421 ORDER BY `minOrder` ASC [ RunTime:0.037698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12789421 ORDER BY `unit` DESC [ RunTime:0.090882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12789421 LIMIT 2 [ RunTime:0.048524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12789421 ORDER BY `minOrder` ASC [ RunTime:0.015066s ]
select * from pdf where partno='BSE-120-01-C-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12787398 LIMIT 5 [ RunTime:0.012239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12787398 ORDER BY `minOrder` ASC [ RunTime:0.043260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12787398 ORDER BY `unit` DESC [ RunTime:0.009180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12787398 LIMIT 2 [ RunTime:0.012134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12787398 ORDER BY `minOrder` ASC [ RunTime:0.006351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786086 LIMIT 5 [ RunTime:0.059221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786086 ORDER BY `minOrder` ASC [ RunTime:0.014566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12786086 ORDER BY `unit` DESC [ RunTime:0.044849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12786086 LIMIT 2 [ RunTime:0.008733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786086 ORDER BY `minOrder` ASC [ RunTime:0.001507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12785638 LIMIT 5 [ RunTime:0.011609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785638 ORDER BY `minOrder` ASC [ RunTime:0.036084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12785638 ORDER BY `unit` DESC [ RunTime:0.052120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12785638 LIMIT 2 [ RunTime:0.023996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785638 ORDER BY `minOrder` ASC [ RunTime:0.008853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784691 LIMIT 5 [ RunTime:0.020684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784691 ORDER BY `minOrder` ASC [ RunTime:0.014330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12784691 ORDER BY `unit` DESC [ RunTime:0.024351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12784691 LIMIT 2 [ RunTime:0.005757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12784691 ORDER BY `minOrder` ASC [ RunTime:0.007928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11610505 LIMIT 5 [ RunTime:0.016319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610505 ORDER BY `minOrder` ASC [ RunTime:0.014292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11610505 ORDER BY `unit` DESC [ RunTime:0.015896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11610505 LIMIT 2 [ RunTime:0.016971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11610505 ORDER BY `minOrder` ASC [ RunTime:0.007366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609082 LIMIT 5 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609082 ORDER BY `minOrder` ASC [ RunTime:0.022392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609082 ORDER BY `unit` DESC [ RunTime:0.002048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609082 LIMIT 2 [ RunTime:0.013336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609082 ORDER BY `minOrder` ASC [ RunTime:0.013647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608739 LIMIT 5 [ RunTime:0.027287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608739 ORDER BY `minOrder` ASC [ RunTime:0.016545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608739 ORDER BY `unit` DESC [ RunTime:0.010098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608739 LIMIT 2 [ RunTime:0.012510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608739 ORDER BY `minOrder` ASC [ RunTime:0.018179s ]
select * from pdf where partno='BSE-100-01-F-D-A-FL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608738 LIMIT 5 [ RunTime:0.011155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608738 ORDER BY `minOrder` ASC [ RunTime:0.008382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608738 ORDER BY `unit` DESC [ RunTime:0.002102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608738 LIMIT 2 [ RunTime:0.005532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608738 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
select * from pdf where partno='BSE-100-01-C-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11607790 LIMIT 5 [ RunTime:0.009122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11607790 ORDER BY `minOrder` ASC [ RunTime:0.011058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11607790 ORDER BY `unit` DESC [ RunTime:0.006822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11607790 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11607790 ORDER BY `minOrder` ASC [ RunTime:0.012874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606628 LIMIT 5 [ RunTime:0.007528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606628 ORDER BY `minOrder` ASC [ RunTime:0.020355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11606628 ORDER BY `unit` DESC [ RunTime:0.012502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11606628 LIMIT 2 [ RunTime:0.002012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606628 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606195 LIMIT 5 [ RunTime:0.000962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606195 ORDER BY `minOrder` ASC [ RunTime:0.006806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11606195 ORDER BY `unit` DESC [ RunTime:0.006203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11606195 LIMIT 2 [ RunTime:0.013638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606195 ORDER BY `minOrder` ASC [ RunTime:0.021407s ]
select * from pdf where partno='BSE-120-01-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605622 LIMIT 5 [ RunTime:0.005553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605622 ORDER BY `minOrder` ASC [ RunTime:0.004950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11605622 ORDER BY `unit` DESC [ RunTime:0.000957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11605622 LIMIT 2 [ RunTime:0.013822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605622 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605395 LIMIT 5 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605395 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11605395 ORDER BY `unit` DESC [ RunTime:0.018157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11605395 LIMIT 2 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605395 ORDER BY `minOrder` ASC [ RunTime:0.002490s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32279508 LIMIT 5 [ RunTime:0.019322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279508 ORDER BY `minOrder` ASC [ RunTime:0.005981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32279508 ORDER BY `unit` DESC [ RunTime:0.009499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32279508 LIMIT 2 [ RunTime:0.008946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32279508 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='bse-1' and brandshort='neutrik' limit 1 [ RunTime:0.002138s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bse-1' OR `brand` LIKE 'neutrik%' ) ) LIMIT 1 [ RunTime:0.013184s ]
SELECT `id` FROM `stock` WHERE `id` <> 32279508 AND `partno` = 'bse-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%neutrik%' ) [ RunTime:0.008084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62119885 [ RunTime:0.027102s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59358990 LIMIT 5 [ RunTime:0.012345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358990 ORDER BY `minOrder` ASC [ RunTime:0.026620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59358990 ORDER BY `unit` DESC [ RunTime:0.003056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59358990 LIMIT 2 [ RunTime:0.018416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358990 ORDER BY `minOrder` ASC [ RunTime:0.001648s ]
select * from pdf where partno='BSE-120-01-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-F-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013345s ]
SELECT `id` FROM `stock` WHERE `id` <> 59358990 AND `partno` = 'BSE-120-01-F-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12793293 [ RunTime:0.004717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62119885 LIMIT 5 [ RunTime:0.002997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62119885 ORDER BY `minOrder` ASC [ RunTime:0.003312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62119885 ORDER BY `unit` DESC [ RunTime:0.020149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62119885 LIMIT 2 [ RunTime:0.013897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62119885 ORDER BY `minOrder` ASC [ RunTime:0.008232s ]
select * from pdf where partno='BSE-1' and brandshort='Neutrik Americas, Inc.' limit 1 [ RunTime:0.005495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-1' OR `brand` LIKE 'Neutrik Americas, Inc.%' ) ) LIMIT 1 [ RunTime:0.008913s ]
SELECT `id` FROM `stock` WHERE `id` <> 62119885 AND `partno` = 'BSE-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%neutrik americas, inc.%' ) [ RunTime:0.016145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59383787 LIMIT 5 [ RunTime:0.015459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59383787 ORDER BY `minOrder` ASC [ RunTime:0.015824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59383787 ORDER BY `unit` DESC [ RunTime:0.001815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59383787 LIMIT 2 [ RunTime:0.011531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59383787 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='BSE-120-01-C-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-C-D-EM2' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006532s ]
SELECT `id` FROM `stock` WHERE `id` <> 59383787 AND `partno` = 'BSE-120-01-C-D-EM2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12789456 [ RunTime:0.005134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59383626 LIMIT 5 [ RunTime:0.014314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59383626 ORDER BY `minOrder` ASC [ RunTime:0.019661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59383626 ORDER BY `unit` DESC [ RunTime:0.002902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59383626 LIMIT 2 [ RunTime:0.019411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59383626 ORDER BY `minOrder` ASC [ RunTime:0.008200s ]
select * from pdf where partno='BSE-120-01-C-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-C-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001945s ]
SELECT `id` FROM `stock` WHERE `id` <> 59383626 AND `partno` = 'BSE-120-01-C-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12789421 [ RunTime:0.002910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59382524 LIMIT 5 [ RunTime:0.003838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59382524 ORDER BY `minOrder` ASC [ RunTime:0.007999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59382524 ORDER BY `unit` DESC [ RunTime:0.006387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59382524 LIMIT 2 [ RunTime:0.007211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59382524 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
select * from pdf where partno='BSE-100-01-C-D-A-FL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-C-D-A-FL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012912s ]
SELECT `id` FROM `stock` WHERE `id` <> 59382524 AND `partno` = 'BSE-100-01-C-D-A-FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11607790 [ RunTime:0.009841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59381300 LIMIT 5 [ RunTime:0.024992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59381300 ORDER BY `minOrder` ASC [ RunTime:0.006829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59381300 ORDER BY `unit` DESC [ RunTime:0.013028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59381300 LIMIT 2 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59381300 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
select * from pdf where partno='BSE-120-01-L-D-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-L-D-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008006s ]
SELECT `id` FROM `stock` WHERE `id` <> 59381300 AND `partno` = 'BSE-120-01-L-D-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59379758 LIMIT 5 [ RunTime:0.009892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59379758 ORDER BY `minOrder` ASC [ RunTime:0.027726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59379758 ORDER BY `unit` DESC [ RunTime:0.011161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59379758 LIMIT 2 [ RunTime:0.008402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59379758 ORDER BY `minOrder` ASC [ RunTime:0.011823s ]
select * from pdf where partno='BSE-120-01-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-H-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000993s ]
SELECT `id` FROM `stock` WHERE `id` <> 59379758 AND `partno` = 'BSE-120-01-H-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606195 [ RunTime:0.006147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59379685 LIMIT 5 [ RunTime:0.003055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59379685 ORDER BY `minOrder` ASC [ RunTime:0.000882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59379685 ORDER BY `unit` DESC [ RunTime:0.003254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59379685 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59379685 ORDER BY `minOrder` ASC [ RunTime:0.006035s ]
select * from pdf where partno='BSE-100-01-F-D-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-F-D-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007518s ]
SELECT `id` FROM `stock` WHERE `id` <> 59379685 AND `partno` = 'BSE-100-01-F-D-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59378534 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59378534 ORDER BY `minOrder` ASC [ RunTime:0.002845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59378534 ORDER BY `unit` DESC [ RunTime:0.003480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59378534 LIMIT 2 [ RunTime:0.020377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59378534 ORDER BY `minOrder` ASC [ RunTime:0.018000s ]
select * from pdf where partno='BSE-100-01-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-H-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029387s ]
SELECT `id` FROM `stock` WHERE `id` <> 59378534 AND `partno` = 'BSE-100-01-H-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606628 [ RunTime:0.015786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59377113 LIMIT 5 [ RunTime:0.004068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59377113 ORDER BY `minOrder` ASC [ RunTime:0.004918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59377113 ORDER BY `unit` DESC [ RunTime:0.004820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59377113 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59377113 ORDER BY `minOrder` ASC [ RunTime:0.008948s ]
select * from pdf where partno='BSE-120-01-L-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-L-D-EM2' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019265s ]
SELECT `id` FROM `stock` WHERE `id` <> 59377113 AND `partno` = 'BSE-120-01-L-D-EM2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12787398 [ RunTime:0.003671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59375681 LIMIT 5 [ RunTime:0.002444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59375681 ORDER BY `minOrder` ASC [ RunTime:0.009684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59375681 ORDER BY `unit` DESC [ RunTime:0.008982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59375681 LIMIT 2 [ RunTime:0.012448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59375681 ORDER BY `minOrder` ASC [ RunTime:0.001549s ]
select * from pdf where partno='BSE-120-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018233s ]
SELECT `id` FROM `stock` WHERE `id` <> 59375681 AND `partno` = 'BSE-120-01-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605395 [ RunTime:0.017799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374856 LIMIT 5 [ RunTime:0.015539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374856 ORDER BY `minOrder` ASC [ RunTime:0.015399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374856 ORDER BY `unit` DESC [ RunTime:0.004505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374856 LIMIT 2 [ RunTime:0.008895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374856 ORDER BY `minOrder` ASC [ RunTime:0.003678s ]
select * from pdf where partno='BSE-120-01-L-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-L-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020416s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374856 AND `partno` = 'BSE-120-01-L-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374729 LIMIT 5 [ RunTime:0.058070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374729 ORDER BY `minOrder` ASC [ RunTime:0.019054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374729 ORDER BY `unit` DESC [ RunTime:0.044828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374729 LIMIT 2 [ RunTime:0.014091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374729 ORDER BY `minOrder` ASC [ RunTime:0.013815s ]
select * from pdf where partno='BSE-100-01-F-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-F-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.053655s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374729 AND `partno` = 'BSE-100-01-F-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605622 [ RunTime:0.008709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374555 LIMIT 5 [ RunTime:0.022230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374555 ORDER BY `minOrder` ASC [ RunTime:0.015497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374555 ORDER BY `unit` DESC [ RunTime:0.019338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374555 LIMIT 2 [ RunTime:0.037830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374555 ORDER BY `minOrder` ASC [ RunTime:0.019237s ]
select * from pdf where partno='BSE-100-01-L-D-FL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-L-D-FL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027720s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374555 AND `partno` = 'BSE-100-01-L-D-FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786086 [ RunTime:0.027566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59374520 LIMIT 5 [ RunTime:0.017507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374520 ORDER BY `minOrder` ASC [ RunTime:0.009662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59374520 ORDER BY `unit` DESC [ RunTime:0.005388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59374520 LIMIT 2 [ RunTime:0.014492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59374520 ORDER BY `minOrder` ASC [ RunTime:0.011621s ]
select * from pdf where partno='BSE-120-01-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-F-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032114s ]
SELECT `id` FROM `stock` WHERE `id` <> 59374520 AND `partno` = 'BSE-120-01-F-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605052 [ RunTime:0.036357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59373608 LIMIT 5 [ RunTime:0.055525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59373608 ORDER BY `minOrder` ASC [ RunTime:0.017902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59373608 ORDER BY `unit` DESC [ RunTime:0.012013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59373608 LIMIT 2 [ RunTime:0.018702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59373608 ORDER BY `minOrder` ASC [ RunTime:0.027299s ]
select * from pdf where partno='BSE-100-01-F-D-FL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-F-D-FL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026646s ]
SELECT `id` FROM `stock` WHERE `id` <> 59373608 AND `partno` = 'BSE-100-01-F-D-FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12785638 [ RunTime:0.059615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59371658 LIMIT 5 [ RunTime:0.019279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59371658 ORDER BY `minOrder` ASC [ RunTime:0.030295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59371658 ORDER BY `unit` DESC [ RunTime:0.038300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59371658 LIMIT 2 [ RunTime:0.014731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59371658 ORDER BY `minOrder` ASC [ RunTime:0.023073s ]
select * from pdf where partno='BSE-100-01-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-F-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.058146s ]
SELECT `id` FROM `stock` WHERE `id` <> 59371658 AND `partno` = 'BSE-100-01-F-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12784691 [ RunTime:0.019119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59361747 LIMIT 5 [ RunTime:0.033923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59361747 ORDER BY `minOrder` ASC [ RunTime:0.036482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59361747 ORDER BY `unit` DESC [ RunTime:0.022880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59361747 LIMIT 2 [ RunTime:0.044606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59361747 ORDER BY `minOrder` ASC [ RunTime:0.022591s ]
select * from pdf where partno='BSE-120-01-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-L-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014290s ]
SELECT `id` FROM `stock` WHERE `id` <> 59361747 AND `partno` = 'BSE-120-01-L-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.041661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792867 [ RunTime:0.063808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59361613 LIMIT 5 [ RunTime:0.042169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59361613 ORDER BY `minOrder` ASC [ RunTime:0.014084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59361613 ORDER BY `unit` DESC [ RunTime:0.049307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59361613 LIMIT 2 [ RunTime:0.037524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59361613 ORDER BY `minOrder` ASC [ RunTime:0.019279s ]
select * from pdf where partno='BSE-100-01-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-100-01-L-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033310s ]
SELECT `id` FROM `stock` WHERE `id` <> 59361613 AND `partno` = 'BSE-100-01-L-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.049221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11610505 [ RunTime:0.045667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59361277 LIMIT 5 [ RunTime:0.023717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59361277 ORDER BY `minOrder` ASC [ RunTime:0.033686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59361277 ORDER BY `unit` DESC [ RunTime:0.059023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59361277 LIMIT 2 [ RunTime:0.112613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59361277 ORDER BY `minOrder` ASC [ RunTime:0.028179s ]
select * from pdf where partno='BSE-120-01-H-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSE-120-01-H-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.065957s ]
SELECT `id` FROM `stock` WHERE `id` <> 59361277 AND `partno` = 'BSE-120-01-H-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.072779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792789 [ RunTime:0.010550s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011218s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068255s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030242s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011216s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030655s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048449s ]
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 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043150s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSE-1%' OR `brand` LIKE 'BSE-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.042797s ]