SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002494s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=SMAJ8.0&search=1' [ RunTime:0.002305s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002813s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006609s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.005726s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.002429s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002243s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008935s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002524s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ8.0' LIMIT 1 [ RunTime:0.027102s ]
UPDATE `stock_search` SET `count` = 13 , `updatetime` = '2026-08-29 12:26:24' WHERE `partno` = 'SMAJ8.0' [ RunTime:0.033533s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002070s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060889s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906657 LIMIT 5 [ RunTime:0.062989s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906657 ORDER BY `minOrder` ASC [ RunTime:0.023106s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906657 ORDER BY `unit` DESC [ RunTime:0.057358s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906657 LIMIT 2 [ RunTime:0.042817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906657 ORDER BY `minOrder` ASC [ RunTime:0.004915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805702 LIMIT 5 [ RunTime:0.032717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805702 ORDER BY `minOrder` ASC [ RunTime:0.048502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805702 ORDER BY `unit` DESC [ RunTime:0.081152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805702 LIMIT 2 [ RunTime:0.025329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805702 ORDER BY `minOrder` ASC [ RunTime:0.015055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813518 LIMIT 5 [ RunTime:0.005913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813518 ORDER BY `minOrder` ASC [ RunTime:0.045182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813518 ORDER BY `unit` DESC [ RunTime:0.065058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813518 LIMIT 2 [ RunTime:0.097651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813518 ORDER BY `minOrder` ASC [ RunTime:0.008820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906891 LIMIT 5 [ RunTime:0.057289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906891 ORDER BY `minOrder` ASC [ RunTime:0.041020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906891 ORDER BY `unit` DESC [ RunTime:0.045224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906891 LIMIT 2 [ RunTime:0.077640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906891 ORDER BY `minOrder` ASC [ RunTime:0.056293s ]
select * from pdf where partno='SMAJ8.0A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.063601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907227 LIMIT 5 [ RunTime:0.030691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907227 ORDER BY `minOrder` ASC [ RunTime:0.040198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907227 ORDER BY `unit` DESC [ RunTime:0.029207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907227 LIMIT 2 [ RunTime:0.036395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907227 ORDER BY `minOrder` ASC [ RunTime:0.079817s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.034994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662594 LIMIT 5 [ RunTime:0.016602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662594 ORDER BY `minOrder` ASC [ RunTime:0.020631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662594 ORDER BY `unit` DESC [ RunTime:0.024170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662594 LIMIT 2 [ RunTime:0.023520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662594 ORDER BY `minOrder` ASC [ RunTime:0.009847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916606 LIMIT 5 [ RunTime:0.014607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916606 ORDER BY `minOrder` ASC [ RunTime:0.018708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916606 ORDER BY `unit` DESC [ RunTime:0.005339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916606 LIMIT 2 [ RunTime:0.023568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916606 ORDER BY `minOrder` ASC [ RunTime:0.021507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825942 LIMIT 5 [ RunTime:0.008446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825942 ORDER BY `minOrder` ASC [ RunTime:0.012986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825942 ORDER BY `unit` DESC [ RunTime:0.013377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825942 LIMIT 2 [ RunTime:0.010455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825942 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661261 LIMIT 5 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661261 ORDER BY `minOrder` ASC [ RunTime:0.009261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661261 ORDER BY `unit` DESC [ RunTime:0.006439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661261 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661261 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661256 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661256 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661256 ORDER BY `unit` DESC [ RunTime:0.027477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661256 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661256 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812725 LIMIT 5 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812725 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812725 ORDER BY `unit` DESC [ RunTime:0.021128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812725 LIMIT 2 [ RunTime:0.002939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812725 ORDER BY `minOrder` ASC [ RunTime:0.005947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674758 LIMIT 5 [ RunTime:0.010462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674758 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674758 ORDER BY `unit` DESC [ RunTime:0.014134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674758 LIMIT 2 [ RunTime:0.005455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674758 ORDER BY `minOrder` ASC [ RunTime:0.005697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905686 LIMIT 5 [ RunTime:0.006596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905686 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905686 ORDER BY `unit` DESC [ RunTime:0.015605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905686 LIMIT 2 [ RunTime:0.007739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905686 ORDER BY `minOrder` ASC [ RunTime:0.003514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800720 LIMIT 5 [ RunTime:0.001629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800720 ORDER BY `minOrder` ASC [ RunTime:0.002650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800720 ORDER BY `unit` DESC [ RunTime:0.001199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800720 LIMIT 2 [ RunTime:0.007018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800720 ORDER BY `minOrder` ASC [ RunTime:0.001764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917257 LIMIT 5 [ RunTime:0.002031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917257 ORDER BY `minOrder` ASC [ RunTime:0.001064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917257 ORDER BY `unit` DESC [ RunTime:0.003466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917257 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917257 ORDER BY `minOrder` ASC [ RunTime:0.006418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673629 LIMIT 5 [ RunTime:0.004383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673629 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673629 ORDER BY `unit` DESC [ RunTime:0.008908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673629 LIMIT 2 [ RunTime:0.003838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673629 ORDER BY `minOrder` ASC [ RunTime:0.007055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907349 LIMIT 5 [ RunTime:0.007876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907349 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907349 ORDER BY `unit` DESC [ RunTime:0.008144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907349 LIMIT 2 [ RunTime:0.004264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907349 ORDER BY `minOrder` ASC [ RunTime:0.001206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907427 LIMIT 5 [ RunTime:0.003168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907427 ORDER BY `minOrder` ASC [ RunTime:0.008882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907427 ORDER BY `unit` DESC [ RunTime:0.016749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907427 LIMIT 2 [ RunTime:0.009842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907427 ORDER BY `minOrder` ASC [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907431 LIMIT 5 [ RunTime:0.011150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907431 ORDER BY `minOrder` ASC [ RunTime:0.004466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907431 ORDER BY `unit` DESC [ RunTime:0.012223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907431 LIMIT 2 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907431 ORDER BY `minOrder` ASC [ RunTime:0.008025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803903 LIMIT 5 [ RunTime:0.005661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803903 ORDER BY `minOrder` ASC [ RunTime:0.014924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803903 ORDER BY `unit` DESC [ RunTime:0.027422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803903 LIMIT 2 [ RunTime:0.009294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803903 ORDER BY `minOrder` ASC [ RunTime:0.016926s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013428s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160985 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160985 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160985 ORDER BY `unit` DESC [ RunTime:0.013016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160985 LIMIT 2 [ RunTime:0.012370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160985 ORDER BY `minOrder` ASC [ RunTime:0.004699s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='MDD' limit 1 [ RunTime:0.002321s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.013821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112359 LIMIT 5 [ RunTime:0.007053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112359 ORDER BY `minOrder` ASC [ RunTime:0.036330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112359 ORDER BY `unit` DESC [ RunTime:0.005487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112359 LIMIT 2 [ RunTime:0.008250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112359 ORDER BY `minOrder` ASC [ RunTime:0.002131s ]
select * from pdf where partno='SMAJ8.0A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.015895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.032297s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112359 AND `partno` = 'SMAJ8.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.024017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813518 [ RunTime:0.003651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099740 LIMIT 5 [ RunTime:0.019594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099740 ORDER BY `minOrder` ASC [ RunTime:0.019771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099740 ORDER BY `unit` DESC [ RunTime:0.015941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099740 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099740 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
select * from pdf where partno='SMAJ8.0A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.010970s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099740 AND `partno` = 'SMAJ8.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.009312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906891 [ RunTime:0.031081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150462 LIMIT 5 [ RunTime:0.010941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150462 ORDER BY `minOrder` ASC [ RunTime:0.039856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150462 ORDER BY `unit` DESC [ RunTime:0.014851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150462 LIMIT 2 [ RunTime:0.025860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150462 ORDER BY `minOrder` ASC [ RunTime:0.018247s ]
select * from pdf where partno='SMAJ8.0A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.016148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.035338s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150462 AND `partno` = 'SMAJ8.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.029073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662594 [ RunTime:0.006091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111597 LIMIT 5 [ RunTime:0.001393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111597 ORDER BY `minOrder` ASC [ RunTime:0.026957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111597 ORDER BY `unit` DESC [ RunTime:0.009229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111597 LIMIT 2 [ RunTime:0.008034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111597 ORDER BY `minOrder` ASC [ RunTime:0.004843s ]
select * from pdf where partno='SMAJ8.0A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.032456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002150s ]
SELECT `id` FROM `stock` WHERE `id` <> 42111597 AND `partno` = 'SMAJ8.0A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.023611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916606 [ RunTime:0.003803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127048 LIMIT 5 [ RunTime:0.007898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127048 ORDER BY `minOrder` ASC [ RunTime:0.006121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127048 ORDER BY `unit` DESC [ RunTime:0.010423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127048 LIMIT 2 [ RunTime:0.029865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127048 ORDER BY `minOrder` ASC [ RunTime:0.016543s ]
select * from pdf where partno='SMAJ8.0CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021749s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127048 AND `partno` = 'SMAJ8.0CA-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.018929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825942 [ RunTime:0.025567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42139225 LIMIT 5 [ RunTime:0.002502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42139225 ORDER BY `minOrder` ASC [ RunTime:0.013472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42139225 ORDER BY `unit` DESC [ RunTime:0.020437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42139225 LIMIT 2 [ RunTime:0.012715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42139225 ORDER BY `minOrder` ASC [ RunTime:0.014767s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.048644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.029613s ]
SELECT `id` FROM `stock` WHERE `id` <> 42139225 AND `partno` = 'SMAJ8.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.034054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805070 [ RunTime:0.036997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109558 LIMIT 5 [ RunTime:0.022182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109558 ORDER BY `minOrder` ASC [ RunTime:0.009679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109558 ORDER BY `unit` DESC [ RunTime:0.025069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109558 LIMIT 2 [ RunTime:0.011836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109558 ORDER BY `minOrder` ASC [ RunTime:0.010346s ]
select * from pdf where partno='SMAJ8.0A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.013680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109559 LIMIT 5 [ RunTime:0.018671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109559 ORDER BY `minOrder` ASC [ RunTime:0.017008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109559 ORDER BY `unit` DESC [ RunTime:0.005703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109559 LIMIT 2 [ RunTime:0.016452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109559 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
select * from pdf where partno='SMAJ8.0CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.016037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123985 LIMIT 5 [ RunTime:0.030775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123985 ORDER BY `minOrder` ASC [ RunTime:0.029239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123985 ORDER BY `unit` DESC [ RunTime:0.020643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123985 LIMIT 2 [ RunTime:0.029859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123985 ORDER BY `minOrder` ASC [ RunTime:0.015741s ]
select * from pdf where partno='SMAJ8.0A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.015814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.010279s ]
SELECT `id` FROM `stock` WHERE `id` <> 42123985 AND `partno` = 'SMAJ8.0A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.027644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812725 [ RunTime:0.006878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112979 LIMIT 5 [ RunTime:0.019260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112979 ORDER BY `minOrder` ASC [ RunTime:0.011773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112979 ORDER BY `unit` DESC [ RunTime:0.005105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112979 LIMIT 2 [ RunTime:0.014157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112979 ORDER BY `minOrder` ASC [ RunTime:0.008970s ]
select * from pdf where partno='SMAJ8.0CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015304s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112979 AND `partno` = 'SMAJ8.0CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674758 [ RunTime:0.009750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099422 LIMIT 5 [ RunTime:0.019080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099422 ORDER BY `minOrder` ASC [ RunTime:0.050914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099422 ORDER BY `unit` DESC [ RunTime:0.017560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099422 LIMIT 2 [ RunTime:0.049409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099422 ORDER BY `minOrder` ASC [ RunTime:0.006315s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.016574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.016924s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099422 AND `partno` = 'SMAJ8.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.053079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907227 [ RunTime:0.019662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146461 LIMIT 5 [ RunTime:0.019148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146461 ORDER BY `minOrder` ASC [ RunTime:0.060704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146461 ORDER BY `unit` DESC [ RunTime:0.021599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146461 LIMIT 2 [ RunTime:0.018893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146461 ORDER BY `minOrder` ASC [ RunTime:0.017960s ]
select * from pdf where partno='SMAJ8.0A' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.050471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.015288s ]
SELECT `id` FROM `stock` WHERE `id` <> 42146461 AND `partno` = 'SMAJ8.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%shenzhen slkormicro semicon co., ltd.%' ) [ RunTime:0.054510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905686 [ RunTime:0.031387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112419 LIMIT 5 [ RunTime:0.036051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112419 ORDER BY `minOrder` ASC [ RunTime:0.028537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112419 ORDER BY `unit` DESC [ RunTime:0.018914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112419 LIMIT 2 [ RunTime:0.034076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112419 ORDER BY `minOrder` ASC [ RunTime:0.030982s ]
select * from pdf where partno='SMAJ8.0A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.036386s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112419 AND `partno` = 'SMAJ8.0A-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.076950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907431 [ RunTime:0.043916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146464 LIMIT 5 [ RunTime:0.019742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146464 ORDER BY `minOrder` ASC [ RunTime:0.012431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146464 ORDER BY `unit` DESC [ RunTime:0.067385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146464 LIMIT 2 [ RunTime:0.030782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146464 ORDER BY `minOrder` ASC [ RunTime:0.029296s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.012809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.045885s ]
SELECT `id` FROM `stock` WHERE `id` <> 42146464 AND `partno` = 'SMAJ8.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%shenzhen slkormicro semicon co., ltd.%' ) [ RunTime:0.043306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800720 [ RunTime:0.051770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124436 LIMIT 5 [ RunTime:0.071935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124436 ORDER BY `minOrder` ASC [ RunTime:0.027808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124436 ORDER BY `unit` DESC [ RunTime:0.024292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124436 LIMIT 2 [ RunTime:0.031029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124436 ORDER BY `minOrder` ASC [ RunTime:0.020548s ]
select * from pdf where partno='SMAJ8.0CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.048161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.037071s ]
SELECT `id` FROM `stock` WHERE `id` <> 42124436 AND `partno` = 'SMAJ8.0CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.041557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917257 [ RunTime:0.011546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169452 LIMIT 5 [ RunTime:0.029526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169452 ORDER BY `minOrder` ASC [ RunTime:0.027594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169452 ORDER BY `unit` DESC [ RunTime:0.031520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169452 LIMIT 2 [ RunTime:0.028616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169452 ORDER BY `minOrder` ASC [ RunTime:0.018217s ]
select * from pdf where partno='SMAJ8.0A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.081473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.031512s ]
SELECT `id` FROM `stock` WHERE `id` <> 42169452 AND `partno` = 'SMAJ8.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.058567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907427 [ RunTime:0.023773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42167867 LIMIT 5 [ RunTime:0.017594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167867 ORDER BY `minOrder` ASC [ RunTime:0.050144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42167867 ORDER BY `unit` DESC [ RunTime:0.108973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42167867 LIMIT 2 [ RunTime:0.094527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42167867 ORDER BY `minOrder` ASC [ RunTime:0.016196s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.063916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.022389s ]
SELECT `id` FROM `stock` WHERE `id` <> 42167867 AND `partno` = 'SMAJ8.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.094354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805702 [ RunTime:0.043193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169464 LIMIT 5 [ RunTime:0.018318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169464 ORDER BY `minOrder` ASC [ RunTime:0.024955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169464 ORDER BY `unit` DESC [ RunTime:0.018829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169464 LIMIT 2 [ RunTime:0.046967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169464 ORDER BY `minOrder` ASC [ RunTime:0.016953s ]
select * from pdf where partno='SMAJ8.0CA' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.018342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014377s ]
SELECT `id` FROM `stock` WHERE `id` <> 42169464 AND `partno` = 'SMAJ8.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.064024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907349 [ RunTime:0.039258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168595 LIMIT 5 [ RunTime:0.042091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168595 ORDER BY `minOrder` ASC [ RunTime:0.034497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168595 ORDER BY `unit` DESC [ RunTime:0.016460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168595 LIMIT 2 [ RunTime:0.107037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168595 ORDER BY `minOrder` ASC [ RunTime:0.012668s ]
select * from pdf where partno='SMAJ8.0CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.040055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ8.0CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.083285s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168595 AND `partno` = 'SMAJ8.0CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.051270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673629 [ RunTime:0.026228s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101379s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081143s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030517s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028913s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067124s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070146s ]
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 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031562s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ8.0%' OR `brand` LIKE 'SMAJ8.0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023130s ]