SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002425s ]
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=SMCJ6.5A&search=1' [ RunTime:0.003582s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001973s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008915s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001469s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004118s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001249s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004316s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001304s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ6.5A' LIMIT 1 [ RunTime:0.005753s ]
UPDATE `stock_search` SET `count` = 16 , `updatetime` = '2026-08-21 14:26:20' WHERE `partno` = 'SMCJ6.5A' [ RunTime:0.004682s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003655s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013768s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814716 LIMIT 5 [ RunTime:0.014433s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814716 ORDER BY `minOrder` ASC [ RunTime:0.006005s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814716 ORDER BY `unit` DESC [ RunTime:0.001058s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814716 LIMIT 2 [ RunTime:0.017587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814716 ORDER BY `minOrder` ASC [ RunTime:0.009960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832213 LIMIT 5 [ RunTime:0.011776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832213 ORDER BY `minOrder` ASC [ RunTime:0.011662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832213 ORDER BY `unit` DESC [ RunTime:0.020570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832213 LIMIT 2 [ RunTime:0.017446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832213 ORDER BY `minOrder` ASC [ RunTime:0.002230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831829 LIMIT 5 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831829 ORDER BY `minOrder` ASC [ RunTime:0.018125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831829 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831829 LIMIT 2 [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831829 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929538 LIMIT 5 [ RunTime:0.005711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929538 ORDER BY `minOrder` ASC [ RunTime:0.001905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13929538 ORDER BY `unit` DESC [ RunTime:0.003820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13929538 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929538 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926154 LIMIT 5 [ RunTime:0.003725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926154 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926154 ORDER BY `unit` DESC [ RunTime:0.006102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926154 LIMIT 2 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926154 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908402 LIMIT 5 [ RunTime:0.006420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908402 ORDER BY `minOrder` ASC [ RunTime:0.004403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908402 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908402 LIMIT 2 [ RunTime:0.008301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908402 ORDER BY `minOrder` ASC [ RunTime:0.004368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664578 LIMIT 5 [ RunTime:0.001154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664578 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664578 ORDER BY `unit` DESC [ RunTime:0.001201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664578 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664578 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='SMCJ6.5A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692652 LIMIT 5 [ RunTime:0.001170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692652 ORDER BY `minOrder` ASC [ RunTime:0.002057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692652 ORDER BY `unit` DESC [ RunTime:0.002861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692652 LIMIT 2 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692652 ORDER BY `minOrder` ASC [ RunTime:0.004936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692495 LIMIT 5 [ RunTime:0.003662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692495 ORDER BY `minOrder` ASC [ RunTime:0.001451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692495 ORDER BY `unit` DESC [ RunTime:0.009609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692495 LIMIT 2 [ RunTime:0.009924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692495 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691249 LIMIT 5 [ RunTime:0.004271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691249 ORDER BY `minOrder` ASC [ RunTime:0.006980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691249 ORDER BY `unit` DESC [ RunTime:0.001802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691249 LIMIT 2 [ RunTime:0.001043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691249 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689694 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689694 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689694 ORDER BY `unit` DESC [ RunTime:0.003001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689694 LIMIT 2 [ RunTime:0.010747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689694 ORDER BY `minOrder` ASC [ RunTime:0.003181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679954 LIMIT 5 [ RunTime:0.001491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679954 ORDER BY `minOrder` ASC [ RunTime:0.016532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679954 ORDER BY `unit` DESC [ RunTime:0.010042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679954 LIMIT 2 [ RunTime:0.001327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679954 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675224 LIMIT 5 [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675224 ORDER BY `minOrder` ASC [ RunTime:0.006460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675224 ORDER BY `unit` DESC [ RunTime:0.006053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675224 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675224 ORDER BY `minOrder` ASC [ RunTime:0.004578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674783 LIMIT 5 [ RunTime:0.003997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674783 ORDER BY `minOrder` ASC [ RunTime:0.001313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674783 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674783 LIMIT 2 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674783 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674658 LIMIT 5 [ RunTime:0.000934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674658 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674658 ORDER BY `unit` DESC [ RunTime:0.002327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674658 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674658 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673735 LIMIT 5 [ RunTime:0.012005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673735 ORDER BY `minOrder` ASC [ RunTime:0.002672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673735 ORDER BY `unit` DESC [ RunTime:0.003897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673735 LIMIT 2 [ RunTime:0.023541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673735 ORDER BY `minOrder` ASC [ RunTime:0.010233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673008 LIMIT 5 [ RunTime:0.008342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673008 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673008 ORDER BY `unit` DESC [ RunTime:0.005366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673008 LIMIT 2 [ RunTime:0.003714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673008 ORDER BY `minOrder` ASC [ RunTime:0.008912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671989 LIMIT 5 [ RunTime:0.008246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671989 ORDER BY `minOrder` ASC [ RunTime:0.003601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671989 ORDER BY `unit` DESC [ RunTime:0.003106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671989 LIMIT 2 [ RunTime:0.019798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671989 ORDER BY `minOrder` ASC [ RunTime:0.009237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831925 LIMIT 5 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831925 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831925 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831925 LIMIT 2 [ RunTime:0.008570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831925 ORDER BY `minOrder` ASC [ RunTime:0.008253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829416 LIMIT 5 [ RunTime:0.010452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829416 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829416 ORDER BY `unit` DESC [ RunTime:0.006852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829416 LIMIT 2 [ RunTime:0.008711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829416 ORDER BY `minOrder` ASC [ RunTime:0.004500s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141563 LIMIT 5 [ RunTime:0.013649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141563 ORDER BY `minOrder` ASC [ RunTime:0.013382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141563 ORDER BY `unit` DESC [ RunTime:0.006322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141563 LIMIT 2 [ RunTime:0.009735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141563 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
select * from pdf where partno='smcj6.5a' and brandshort='bourns' limit 1 [ RunTime:0.002145s ]
select foldpath,foldpath2,filename from pdf_file where id=951213 limit 1 [ RunTime:0.002660s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj6.5a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.013521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141525 LIMIT 5 [ RunTime:0.017715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141525 ORDER BY `minOrder` ASC [ RunTime:0.013561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141525 ORDER BY `unit` DESC [ RunTime:0.000899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141525 LIMIT 2 [ RunTime:0.001616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141525 ORDER BY `minOrder` ASC [ RunTime:0.001788s ]
select * from pdf where partno='smcj6.5a-13-f' and brandshort='diodes incorporated' limit 1 [ RunTime:0.002123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj6.5a-13-f' OR `brand` LIKE 'diodes incorporated%' ) ) LIMIT 1 [ RunTime:0.003705s ]
SELECT `id` FROM `stock` WHERE `id` <> 51141525 AND `partno` = 'smcj6.5a-13-f' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.008615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832213 [ RunTime:0.008667s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117020 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117020 ORDER BY `minOrder` ASC [ RunTime:0.008778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117020 ORDER BY `unit` DESC [ RunTime:0.003316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117020 LIMIT 2 [ RunTime:0.003999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117020 ORDER BY `minOrder` ASC [ RunTime:0.001424s ]
select * from pdf where partno='SMCJ6.5A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.007391s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117020 AND `partno` = 'SMCJ6.5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.007101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814716 [ RunTime:0.000480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132693 LIMIT 5 [ RunTime:0.001640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132693 ORDER BY `minOrder` ASC [ RunTime:0.001206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132693 ORDER BY `unit` DESC [ RunTime:0.005047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132693 LIMIT 2 [ RunTime:0.008720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132693 ORDER BY `minOrder` ASC [ RunTime:0.005347s ]
select * from pdf where partno='SMCJ6.5A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002198s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132693 AND `partno` = 'SMCJ6.5A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832213 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142534 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142534 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142534 ORDER BY `unit` DESC [ RunTime:0.002530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142534 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142534 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='SMCJ6.5A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003434s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142534 AND `partno` = 'SMCJ6.5A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804611 [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128609 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128609 ORDER BY `minOrder` ASC [ RunTime:0.004488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128609 ORDER BY `unit` DESC [ RunTime:0.003979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128609 LIMIT 2 [ RunTime:0.005107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128609 ORDER BY `minOrder` ASC [ RunTime:0.012552s ]
select * from pdf where partno='SMCJ6.5A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.003902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42130850 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42130850 ORDER BY `minOrder` ASC [ RunTime:0.001238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42130850 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42130850 LIMIT 2 [ RunTime:0.007621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42130850 ORDER BY `minOrder` ASC [ RunTime:0.004681s ]
select * from pdf where partno='SMCJ6.5A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.009149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002833s ]
SELECT `id` FROM `stock` WHERE `id` <> 42130850 AND `partno` = 'SMCJ6.5A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.003017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929538 [ RunTime:0.003307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117906 LIMIT 5 [ RunTime:0.014083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117906 ORDER BY `minOrder` ASC [ RunTime:0.002476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117906 ORDER BY `unit` DESC [ RunTime:0.001456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117906 LIMIT 2 [ RunTime:0.009575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117906 ORDER BY `minOrder` ASC [ RunTime:0.008112s ]
select * from pdf where partno='SMCJ6.5A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002082s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117906 AND `partno` = 'SMCJ6.5A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926154 [ RunTime:0.004752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117363 LIMIT 5 [ RunTime:0.008116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117363 ORDER BY `minOrder` ASC [ RunTime:0.001406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117363 ORDER BY `unit` DESC [ RunTime:0.008311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117363 LIMIT 2 [ RunTime:0.009707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117363 ORDER BY `minOrder` ASC [ RunTime:0.005342s ]
select * from pdf where partno='SMCJ6.5A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.017117s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117363 AND `partno` = 'SMCJ6.5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664578 [ RunTime:0.005465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42415240 LIMIT 5 [ RunTime:0.001331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415240 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42415240 ORDER BY `unit` DESC [ RunTime:0.009579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42415240 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415240 ORDER BY `minOrder` ASC [ RunTime:0.001657s ]
select * from pdf where partno='SMCJ6.5A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003405s ]
SELECT `id` FROM `stock` WHERE `id` <> 42415240 AND `partno` = 'SMCJ6.5A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925076 [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42413674 LIMIT 5 [ RunTime:0.005405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413674 ORDER BY `minOrder` ASC [ RunTime:0.002489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42413674 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42413674 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413674 ORDER BY `minOrder` ASC [ RunTime:0.001006s ]
select * from pdf where partno='SMCJ6.5A-HRAT7' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-HRAT7' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.002516s ]
SELECT `id` FROM `stock` WHERE `id` <> 42413674 AND `partno` = 'SMCJ6.5A-HRAT7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924906 [ RunTime:0.001669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42413673 LIMIT 5 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413673 ORDER BY `minOrder` ASC [ RunTime:0.003265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42413673 ORDER BY `unit` DESC [ RunTime:0.001248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42413673 LIMIT 2 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42413673 ORDER BY `minOrder` ASC [ RunTime:0.006336s ]
select * from pdf where partno='SMCJ6.5A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.006917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 42413673 AND `partno` = 'SMCJ6.5A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924905 [ RunTime:0.012886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42289356 LIMIT 5 [ RunTime:0.004025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289356 ORDER BY `minOrder` ASC [ RunTime:0.023030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42289356 ORDER BY `unit` DESC [ RunTime:0.011467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42289356 LIMIT 2 [ RunTime:0.008502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289356 ORDER BY `minOrder` ASC [ RunTime:0.002621s ]
select * from pdf where partno='SMCJ6.5AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.009812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.014200s ]
SELECT `id` FROM `stock` WHERE `id` <> 42289356 AND `partno` = 'SMCJ6.5AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.004545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817977 [ RunTime:0.005119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284088 LIMIT 5 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284088 ORDER BY `minOrder` ASC [ RunTime:0.020816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284088 ORDER BY `unit` DESC [ RunTime:0.014353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284088 LIMIT 2 [ RunTime:0.007223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284088 ORDER BY `minOrder` ASC [ RunTime:0.004892s ]
select * from pdf where partno='SMCJ6.5A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000942s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284088 AND `partno` = 'SMCJ6.5A-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679954 [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42281780 LIMIT 5 [ RunTime:0.015722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281780 ORDER BY `minOrder` ASC [ RunTime:0.006211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42281780 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42281780 LIMIT 2 [ RunTime:0.005034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281780 ORDER BY `minOrder` ASC [ RunTime:0.004222s ]
select * from pdf where partno='SMCJ6.5AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008966s ]
SELECT `id` FROM `stock` WHERE `id` <> 42281780 AND `partno` = 'SMCJ6.5AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674658 [ RunTime:0.013064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42281779 LIMIT 5 [ RunTime:0.002226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281779 ORDER BY `minOrder` ASC [ RunTime:0.003730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42281779 ORDER BY `unit` DESC [ RunTime:0.004477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42281779 LIMIT 2 [ RunTime:0.006532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42281779 ORDER BY `minOrder` ASC [ RunTime:0.003014s ]
select * from pdf where partno='SMCJ6.5AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001354s ]
SELECT `id` FROM `stock` WHERE `id` <> 42281779 AND `partno` = 'SMCJ6.5AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815041 [ RunTime:0.001674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279975 LIMIT 5 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279975 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279975 ORDER BY `unit` DESC [ RunTime:0.009738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279975 LIMIT 2 [ RunTime:0.002257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279975 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='SMCJ6.5AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.020667s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279975 AND `partno` = 'SMCJ6.5AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815643 [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279974 LIMIT 5 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279974 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279974 ORDER BY `unit` DESC [ RunTime:0.007127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279974 LIMIT 2 [ RunTime:0.000956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279974 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='SMCJ6.5AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007433s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279974 AND `partno` = 'SMCJ6.5AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675224 [ RunTime:0.001360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42277356 LIMIT 5 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277356 ORDER BY `minOrder` ASC [ RunTime:0.005103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42277356 ORDER BY `unit` DESC [ RunTime:0.008591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42277356 LIMIT 2 [ RunTime:0.001726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277356 ORDER BY `minOrder` ASC [ RunTime:0.002717s ]
select * from pdf where partno='SMCJ6.5A-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002448s ]
SELECT `id` FROM `stock` WHERE `id` <> 42277356 AND `partno` = 'SMCJ6.5A-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917836 [ RunTime:0.001532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42277349 LIMIT 5 [ RunTime:0.014915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277349 ORDER BY `minOrder` ASC [ RunTime:0.005897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42277349 ORDER BY `unit` DESC [ RunTime:0.001120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42277349 LIMIT 2 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277349 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='SMCJ6.5A-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004709s ]
SELECT `id` FROM `stock` WHERE `id` <> 42277349 AND `partno` = 'SMCJ6.5A-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674783 [ RunTime:0.003601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42277280 LIMIT 5 [ RunTime:0.003443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277280 ORDER BY `minOrder` ASC [ RunTime:0.009260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42277280 ORDER BY `unit` DESC [ RunTime:0.000857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42277280 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42277280 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='SMCJ6.5AQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.007771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5AQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.001240s ]
SELECT `id` FROM `stock` WHERE `id` <> 42277280 AND `partno` = 'SMCJ6.5AQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918219 [ RunTime:0.001220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42266101 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266101 ORDER BY `minOrder` ASC [ RunTime:0.002661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42266101 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42266101 LIMIT 2 [ RunTime:0.002771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42266101 ORDER BY `minOrder` ASC [ RunTime:0.003813s ]
select * from pdf where partno='SMCJ6.5A-QH' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ6.5A-QH' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006290s ]
SELECT `id` FROM `stock` WHERE `id` <> 42266101 AND `partno` = 'SMCJ6.5A-QH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.005389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815085 [ RunTime:0.001911s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001300s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016935s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002458s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008455s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001020s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004338s ]
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 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003728s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ6.5A%' OR `brand` LIKE 'SMCJ6.5A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001063s ]