SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002200s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=15KPA43&search=1' [ RunTime:0.004498s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002642s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000606s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002274s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000700s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002011s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003394s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002183s ]
SELECT * FROM `stock_search` WHERE `partno` = '15KPA43' LIMIT 1 [ RunTime:0.006117s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-19 13:33:38' WHERE `partno` = '15KPA43' [ RunTime:0.005577s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002521s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025127s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.030006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664133 LIMIT 5 [ RunTime:0.015458s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664133 ORDER BY `minOrder` ASC [ RunTime:0.005476s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664133 ORDER BY `unit` DESC [ RunTime:0.021718s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664133 LIMIT 2 [ RunTime:0.007929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664133 ORDER BY `minOrder` ASC [ RunTime:0.008845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802436 LIMIT 5 [ RunTime:0.013834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802436 ORDER BY `minOrder` ASC [ RunTime:0.077390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802436 ORDER BY `unit` DESC [ RunTime:0.047783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802436 LIMIT 2 [ RunTime:0.060253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802436 ORDER BY `minOrder` ASC [ RunTime:0.040023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906405 LIMIT 5 [ RunTime:0.010648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906405 ORDER BY `minOrder` ASC [ RunTime:0.128187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906405 ORDER BY `unit` DESC [ RunTime:0.085563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906405 LIMIT 2 [ RunTime:0.060882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906405 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
select * from pdf where partno='15KPA43A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.070515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823704 LIMIT 5 [ RunTime:0.081386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823704 ORDER BY `minOrder` ASC [ RunTime:0.044526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823704 ORDER BY `unit` DESC [ RunTime:0.019525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823704 LIMIT 2 [ RunTime:0.040899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823704 ORDER BY `minOrder` ASC [ RunTime:0.019761s ]
select * from pdf where partno='15KPA43CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.052994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799407 LIMIT 5 [ RunTime:0.058750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799407 ORDER BY `minOrder` ASC [ RunTime:0.030318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799407 ORDER BY `unit` DESC [ RunTime:0.025678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799407 LIMIT 2 [ RunTime:0.073589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799407 ORDER BY `minOrder` ASC [ RunTime:0.026666s ]
select * from pdf where partno='15KPA43CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.040867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684178 LIMIT 5 [ RunTime:0.029738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684178 ORDER BY `minOrder` ASC [ RunTime:0.065286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684178 ORDER BY `unit` DESC [ RunTime:0.022975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684178 LIMIT 2 [ RunTime:0.037145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684178 ORDER BY `minOrder` ASC [ RunTime:0.016261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683340 LIMIT 5 [ RunTime:0.066063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683340 ORDER BY `minOrder` ASC [ RunTime:0.064321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683340 ORDER BY `unit` DESC [ RunTime:0.011985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683340 LIMIT 2 [ RunTime:0.044812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683340 ORDER BY `minOrder` ASC [ RunTime:0.007735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683339 LIMIT 5 [ RunTime:0.021005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683339 ORDER BY `minOrder` ASC [ RunTime:0.009039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683339 ORDER BY `unit` DESC [ RunTime:0.002295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683339 LIMIT 2 [ RunTime:0.024297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683339 ORDER BY `minOrder` ASC [ RunTime:0.008325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681456 LIMIT 5 [ RunTime:0.004844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681456 ORDER BY `minOrder` ASC [ RunTime:0.001363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681456 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681456 LIMIT 2 [ RunTime:0.008492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681456 ORDER BY `minOrder` ASC [ RunTime:0.010847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680340 LIMIT 5 [ RunTime:0.004542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680340 ORDER BY `minOrder` ASC [ RunTime:0.004445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680340 ORDER BY `unit` DESC [ RunTime:0.009822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680340 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680340 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680339 LIMIT 5 [ RunTime:0.002131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680339 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680339 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680339 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680339 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827982 LIMIT 5 [ RunTime:0.003365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827982 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827982 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827982 LIMIT 2 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827982 ORDER BY `minOrder` ASC [ RunTime:0.010113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827981 LIMIT 5 [ RunTime:0.014455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827981 ORDER BY `minOrder` ASC [ RunTime:0.005033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827981 ORDER BY `unit` DESC [ RunTime:0.003787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827981 LIMIT 2 [ RunTime:0.010396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827981 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823572 LIMIT 5 [ RunTime:0.010349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823572 ORDER BY `minOrder` ASC [ RunTime:0.010342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823572 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823572 LIMIT 2 [ RunTime:0.003220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823572 ORDER BY `minOrder` ASC [ RunTime:0.006153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822278 LIMIT 5 [ RunTime:0.000964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822278 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14822278 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14822278 LIMIT 2 [ RunTime:0.001178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14822278 ORDER BY `minOrder` ASC [ RunTime:0.009518s ]
select * from pdf where partno='15KPA43A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821827 LIMIT 5 [ RunTime:0.008155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821827 ORDER BY `minOrder` ASC [ RunTime:0.016991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821827 ORDER BY `unit` DESC [ RunTime:0.009838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821827 LIMIT 2 [ RunTime:0.009219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821827 ORDER BY `minOrder` ASC [ RunTime:0.011143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821807 LIMIT 5 [ RunTime:0.015563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821807 ORDER BY `minOrder` ASC [ RunTime:0.005033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821807 ORDER BY `unit` DESC [ RunTime:0.001241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821807 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821807 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931027 LIMIT 5 [ RunTime:0.009060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931027 ORDER BY `minOrder` ASC [ RunTime:0.004106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931027 ORDER BY `unit` DESC [ RunTime:0.013291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931027 LIMIT 2 [ RunTime:0.018941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931027 ORDER BY `minOrder` ASC [ RunTime:0.003236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931026 LIMIT 5 [ RunTime:0.001419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931026 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931026 ORDER BY `unit` DESC [ RunTime:0.002603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931026 LIMIT 2 [ RunTime:0.034588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931026 ORDER BY `minOrder` ASC [ RunTime:0.027903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925604 LIMIT 5 [ RunTime:0.011425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925604 ORDER BY `minOrder` ASC [ RunTime:0.006019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925604 ORDER BY `unit` DESC [ RunTime:0.014848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925604 LIMIT 2 [ RunTime:0.020762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925604 ORDER BY `minOrder` ASC [ RunTime:0.033707s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042415s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42165945 LIMIT 5 [ RunTime:0.025766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42165945 ORDER BY `minOrder` ASC [ RunTime:0.042942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42165945 ORDER BY `unit` DESC [ RunTime:0.031932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42165945 LIMIT 2 [ RunTime:0.021638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42165945 ORDER BY `minOrder` ASC [ RunTime:0.018817s ]
select * from pdf where partno='15KPA43A' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.020270s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.035883s ]
SELECT `id` FROM `stock` WHERE `id` <> 42165945 AND `partno` = '15KPA43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.036322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802436 [ RunTime:0.023004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42165879 LIMIT 5 [ RunTime:0.049453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42165879 ORDER BY `minOrder` ASC [ RunTime:0.059831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42165879 ORDER BY `unit` DESC [ RunTime:0.018666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42165879 LIMIT 2 [ RunTime:0.065703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42165879 ORDER BY `minOrder` ASC [ RunTime:0.008181s ]
select * from pdf where partno='15KPA43CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.032586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.023913s ]
SELECT `id` FROM `stock` WHERE `id` <> 42165879 AND `partno` = '15KPA43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.022498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664133 [ RunTime:0.035071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42158105 LIMIT 5 [ RunTime:0.030875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158105 ORDER BY `minOrder` ASC [ RunTime:0.025119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42158105 ORDER BY `unit` DESC [ RunTime:0.023751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42158105 LIMIT 2 [ RunTime:0.030152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158105 ORDER BY `minOrder` ASC [ RunTime:0.017720s ]
select * from pdf where partno='15KPA43A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.042048s ]
SELECT `id` FROM `stock` WHERE `id` <> 42158105 AND `partno` = '15KPA43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.044326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906405 [ RunTime:0.084153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42137764 LIMIT 5 [ RunTime:0.067767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137764 ORDER BY `minOrder` ASC [ RunTime:0.027997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42137764 ORDER BY `unit` DESC [ RunTime:0.053700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42137764 LIMIT 2 [ RunTime:0.024864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137764 ORDER BY `minOrder` ASC [ RunTime:0.024748s ]
select * from pdf where partno='15KPA43CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.025687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008911s ]
SELECT `id` FROM `stock` WHERE `id` <> 42137764 AND `partno` = '15KPA43CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.027772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799407 [ RunTime:0.020670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418198 LIMIT 5 [ RunTime:0.019936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418198 ORDER BY `minOrder` ASC [ RunTime:0.004272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418198 ORDER BY `unit` DESC [ RunTime:0.004887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418198 LIMIT 2 [ RunTime:0.008298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418198 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
select * from pdf where partno='15KPA43CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.026253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.018702s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418198 AND `partno` = '15KPA43CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.013192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925604 [ RunTime:0.029452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418197 LIMIT 5 [ RunTime:0.031460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418197 ORDER BY `minOrder` ASC [ RunTime:0.028495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418197 ORDER BY `unit` DESC [ RunTime:0.041417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418197 LIMIT 2 [ RunTime:0.014047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418197 ORDER BY `minOrder` ASC [ RunTime:0.012483s ]
select * from pdf where partno='15KPA43A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.009279s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418197 AND `partno` = '15KPA43A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925603 [ RunTime:0.001761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417645 LIMIT 5 [ RunTime:0.002597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417645 ORDER BY `minOrder` ASC [ RunTime:0.009866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417645 ORDER BY `unit` DESC [ RunTime:0.010015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417645 LIMIT 2 [ RunTime:0.014788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417645 ORDER BY `minOrder` ASC [ RunTime:0.004079s ]
select * from pdf where partno='15KPA43CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000566s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417645 AND `partno` = '15KPA43CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925429 [ RunTime:0.005241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417644 LIMIT 5 [ RunTime:0.008015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417644 ORDER BY `minOrder` ASC [ RunTime:0.016417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417644 ORDER BY `unit` DESC [ RunTime:0.012764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417644 LIMIT 2 [ RunTime:0.005812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417644 ORDER BY `minOrder` ASC [ RunTime:0.006922s ]
select * from pdf where partno='15KPA43A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005410s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417644 AND `partno` = '15KPA43A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684178 [ RunTime:0.045445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401071 LIMIT 5 [ RunTime:0.017941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401071 ORDER BY `minOrder` ASC [ RunTime:0.011630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401071 ORDER BY `unit` DESC [ RunTime:0.014948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401071 LIMIT 2 [ RunTime:0.027589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401071 ORDER BY `minOrder` ASC [ RunTime:0.006876s ]
select * from pdf where partno='15KPA43E3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.003622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43E3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.042304s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401071 AND `partno` = '15KPA43E3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.028278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823572 [ RunTime:0.005143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401070 LIMIT 5 [ RunTime:0.012858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401070 ORDER BY `minOrder` ASC [ RunTime:0.017547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401070 ORDER BY `unit` DESC [ RunTime:0.040086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401070 LIMIT 2 [ RunTime:0.012820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401070 ORDER BY `minOrder` ASC [ RunTime:0.005925s ]
select * from pdf where partno='15KPA43CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.028522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.025601s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401070 AND `partno` = '15KPA43CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.055574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924697 [ RunTime:0.039744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401069 LIMIT 5 [ RunTime:0.031327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401069 ORDER BY `minOrder` ASC [ RunTime:0.031121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401069 ORDER BY `unit` DESC [ RunTime:0.021970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401069 LIMIT 2 [ RunTime:0.028121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401069 ORDER BY `minOrder` ASC [ RunTime:0.007869s ]
select * from pdf where partno='15KPA43CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.010839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.038505s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401069 AND `partno` = '15KPA43CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.020420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683340 [ RunTime:0.027250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401068 LIMIT 5 [ RunTime:0.007855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401068 ORDER BY `minOrder` ASC [ RunTime:0.062574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401068 ORDER BY `unit` DESC [ RunTime:0.046673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401068 LIMIT 2 [ RunTime:0.033884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401068 ORDER BY `minOrder` ASC [ RunTime:0.014858s ]
select * from pdf where partno='15KPA43AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.040816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.040269s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401068 AND `partno` = '15KPA43AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.075892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683339 [ RunTime:0.072661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42333112 LIMIT 5 [ RunTime:0.078002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333112 ORDER BY `minOrder` ASC [ RunTime:0.058624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42333112 ORDER BY `unit` DESC [ RunTime:0.040687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42333112 LIMIT 2 [ RunTime:0.057403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333112 ORDER BY `minOrder` ASC [ RunTime:0.046449s ]
select * from pdf where partno='15KPA43A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.017649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.036212s ]
SELECT `id` FROM `stock` WHERE `id` <> 42333112 AND `partno` = '15KPA43A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14822278 [ RunTime:0.053380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42328179 LIMIT 5 [ RunTime:0.118942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42328179 ORDER BY `minOrder` ASC [ RunTime:0.035603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42328179 ORDER BY `unit` DESC [ RunTime:0.017311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42328179 LIMIT 2 [ RunTime:0.063581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42328179 ORDER BY `minOrder` ASC [ RunTime:0.029787s ]
select * from pdf where partno='15KPA43A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.023496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.026517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327544 LIMIT 5 [ RunTime:0.023637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327544 ORDER BY `minOrder` ASC [ RunTime:0.040260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327544 ORDER BY `unit` DESC [ RunTime:0.024560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327544 LIMIT 2 [ RunTime:0.030708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327544 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
select * from pdf where partno='15KPA43A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.039444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327521 LIMIT 5 [ RunTime:0.037820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327521 ORDER BY `minOrder` ASC [ RunTime:0.012456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327521 ORDER BY `unit` DESC [ RunTime:0.055959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327521 LIMIT 2 [ RunTime:0.026531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327521 ORDER BY `minOrder` ASC [ RunTime:0.012065s ]
select * from pdf where partno='15KPA43CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.065158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.053039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327482 LIMIT 5 [ RunTime:0.035049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327482 ORDER BY `minOrder` ASC [ RunTime:0.060095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327482 ORDER BY `unit` DESC [ RunTime:0.038323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327482 LIMIT 2 [ RunTime:0.042488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327482 ORDER BY `minOrder` ASC [ RunTime:0.042587s ]
select * from pdf where partno='15KPA43CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.015762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.039947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42318449 LIMIT 5 [ RunTime:0.051520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318449 ORDER BY `minOrder` ASC [ RunTime:0.025828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42318449 ORDER BY `unit` DESC [ RunTime:0.074765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42318449 LIMIT 2 [ RunTime:0.086273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318449 ORDER BY `minOrder` ASC [ RunTime:0.050342s ]
select * from pdf where partno='15KPA43CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.047918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.053639s ]
SELECT `id` FROM `stock` WHERE `id` <> 42318449 AND `partno` = '15KPA43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.072477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680340 [ RunTime:0.066252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42318448 LIMIT 5 [ RunTime:0.011673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318448 ORDER BY `minOrder` ASC [ RunTime:0.014432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42318448 ORDER BY `unit` DESC [ RunTime:0.062982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42318448 LIMIT 2 [ RunTime:0.059088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318448 ORDER BY `minOrder` ASC [ RunTime:0.001713s ]
select * from pdf where partno='15KPA43A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.082564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.091629s ]
SELECT `id` FROM `stock` WHERE `id` <> 42318448 AND `partno` = '15KPA43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.057989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680339 [ RunTime:0.029817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42176586 LIMIT 5 [ RunTime:0.028848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42176586 ORDER BY `minOrder` ASC [ RunTime:0.038351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42176586 ORDER BY `unit` DESC [ RunTime:0.029751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42176586 LIMIT 2 [ RunTime:0.023310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42176586 ORDER BY `minOrder` ASC [ RunTime:0.024577s ]
select * from pdf where partno='15KPA43CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA43CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.014544s ]
SELECT `id` FROM `stock` WHERE `id` <> 42176586 AND `partno` = '15KPA43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.025171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823704 [ RunTime:0.038002s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052665s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054950s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045780s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027363s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045533s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037860s ]
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 '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038028s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15KPA43%' OR `brand` LIKE '15KPA43%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.061701s ]