SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002524s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=SMAJ13A&page=2&srecordnum=83' [ RunTime:0.010994s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002260s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011176s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003783s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002229s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002251s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ13A' LIMIT 1 [ RunTime:0.000796s ]
UPDATE `stock_search` SET `count` = 21421 , `updatetime` = '2026-06-12 22:28:54' WHERE `partno` = 'SMAJ13A' [ RunTime:0.002761s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002646s ]
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 'SMAJ13A%' OR `brand` LIKE 'SMAJ13A%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.008616s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159923 LIMIT 4 [ RunTime:0.001160s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159923 ORDER BY `minOrder` ASC [ RunTime:0.004152s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159923 ORDER BY `unit` DESC [ RunTime:0.025733s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159923 LIMIT 2 [ RunTime:0.014779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159923 ORDER BY `minOrder` ASC [ RunTime:0.003002s ]
select * from pdf where partno='SMAJ13A' and brandshort='HY Electronic Cayman Limited' limit 1 [ RunTime:0.035794s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A' OR `brand` LIKE 'HY Electronic (Cayman) Limited%' ) ) LIMIT 1 [ RunTime:0.033836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801161 LIMIT 4 [ RunTime:0.026099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801161 ORDER BY `minOrder` ASC [ RunTime:0.065998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801161 ORDER BY `unit` DESC [ RunTime:0.078993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801161 LIMIT 2 [ RunTime:0.114577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801161 ORDER BY `minOrder` ASC [ RunTime:0.082321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109568 LIMIT 4 [ RunTime:0.093481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109568 ORDER BY `minOrder` ASC [ RunTime:0.051766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109568 ORDER BY `unit` DESC [ RunTime:0.063896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109568 LIMIT 2 [ RunTime:0.136162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109568 ORDER BY `minOrder` ASC [ RunTime:0.137741s ]
select * from pdf where partno='SMAJ13A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.051741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.070207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664827 LIMIT 4 [ RunTime:0.090774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664827 ORDER BY `minOrder` ASC [ RunTime:0.149010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664827 ORDER BY `unit` DESC [ RunTime:0.052213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664827 LIMIT 2 [ RunTime:0.038200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664827 ORDER BY `minOrder` ASC [ RunTime:0.034679s ]
select * from pdf where partno='SMAJ13A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.020330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153325 LIMIT 4 [ RunTime:0.016871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153325 ORDER BY `minOrder` ASC [ RunTime:0.079032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153325 ORDER BY `unit` DESC [ RunTime:0.094768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153325 LIMIT 2 [ RunTime:0.086697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153325 ORDER BY `minOrder` ASC [ RunTime:0.029030s ]
select * from pdf where partno='SMAJ13AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.075512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.047516s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153325 AND `partno` = 'SMAJ13AHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.024801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801161 [ RunTime:0.057739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153024 LIMIT 4 [ RunTime:0.005054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153024 ORDER BY `minOrder` ASC [ RunTime:0.060830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153024 ORDER BY `unit` DESC [ RunTime:0.039958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153024 LIMIT 2 [ RunTime:0.029088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153024 ORDER BY `minOrder` ASC [ RunTime:0.032166s ]
select * from pdf where partno='SMAJ13AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005825s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153024 AND `partno` = 'SMAJ13AHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.040730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801161 [ RunTime:0.048628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906882 LIMIT 4 [ RunTime:0.047768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906882 ORDER BY `minOrder` ASC [ RunTime:0.027055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906882 ORDER BY `unit` DESC [ RunTime:0.050838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906882 LIMIT 2 [ RunTime:0.088704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906882 ORDER BY `minOrder` ASC [ RunTime:0.019436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168312 LIMIT 4 [ RunTime:0.046706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168312 ORDER BY `minOrder` ASC [ RunTime:0.071723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168312 ORDER BY `unit` DESC [ RunTime:0.017028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168312 LIMIT 2 [ RunTime:0.053089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168312 ORDER BY `minOrder` ASC [ RunTime:0.014768s ]
select * from pdf where partno='SMAJ13A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.036484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42171510 LIMIT 4 [ RunTime:0.026166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171510 ORDER BY `minOrder` ASC [ RunTime:0.038365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42171510 ORDER BY `unit` DESC [ RunTime:0.049716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42171510 LIMIT 2 [ RunTime:0.013224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171510 ORDER BY `minOrder` ASC [ RunTime:0.013773s ]
select * from pdf where partno='SMAJ13A-HP6AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.026413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A-HP6AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168357 LIMIT 4 [ RunTime:0.023240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168357 ORDER BY `minOrder` ASC [ RunTime:0.065318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168357 ORDER BY `unit` DESC [ RunTime:0.027623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168357 LIMIT 2 [ RunTime:0.033857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168357 ORDER BY `minOrder` ASC [ RunTime:0.034838s ]
select * from pdf where partno='SMAJ13A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.046909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.027243s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168357 AND `partno` = 'SMAJ13A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.038467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917251 [ RunTime:0.050753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907791 LIMIT 4 [ RunTime:0.055291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907791 ORDER BY `minOrder` ASC [ RunTime:0.099789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907791 ORDER BY `unit` DESC [ RunTime:0.078648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907791 LIMIT 2 [ RunTime:0.077015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907791 ORDER BY `minOrder` ASC [ RunTime:0.029348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42171502 LIMIT 4 [ RunTime:0.055271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171502 ORDER BY `minOrder` ASC [ RunTime:0.052401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42171502 ORDER BY `unit` DESC [ RunTime:0.068951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42171502 LIMIT 2 [ RunTime:0.075515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171502 ORDER BY `minOrder` ASC [ RunTime:0.001721s ]
select * from pdf where partno='SMAJ13A-HP6/7' and brandshort='YAGEO' limit 1 [ RunTime:0.078652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A-HP6/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.118177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907932 LIMIT 4 [ RunTime:0.034350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907932 ORDER BY `minOrder` ASC [ RunTime:0.133225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907932 ORDER BY `unit` DESC [ RunTime:0.068713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907932 LIMIT 2 [ RunTime:0.024215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907932 ORDER BY `minOrder` ASC [ RunTime:0.045750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9593 LIMIT 4 [ RunTime:0.082055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9593 ORDER BY `minOrder` ASC [ RunTime:0.088514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9593 ORDER BY `unit` DESC [ RunTime:0.088362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9593 LIMIT 2 [ RunTime:0.136958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9593 ORDER BY `minOrder` ASC [ RunTime:0.060084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.128281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42175151 LIMIT 4 [ RunTime:0.076437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42175151 ORDER BY `minOrder` ASC [ RunTime:0.199029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42175151 ORDER BY `unit` DESC [ RunTime:0.033550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42175151 LIMIT 2 [ RunTime:0.044920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42175151 ORDER BY `minOrder` ASC [ RunTime:0.051236s ]
select * from pdf where partno='SMAJ13A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.014234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.041347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238645 LIMIT 4 [ RunTime:0.039978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238645 ORDER BY `minOrder` ASC [ RunTime:0.171717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238645 ORDER BY `unit` DESC [ RunTime:0.041188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238645 LIMIT 2 [ RunTime:0.039297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238645 ORDER BY `minOrder` ASC [ RunTime:0.014977s ]
select * from pdf where partno='SMAJ13AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.042013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.037319s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238645 AND `partno` = 'SMAJ13AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.095802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914528 [ RunTime:0.038713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42220430 LIMIT 4 [ RunTime:0.009396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220430 ORDER BY `minOrder` ASC [ RunTime:0.071836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42220430 ORDER BY `unit` DESC [ RunTime:0.080394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42220430 LIMIT 2 [ RunTime:0.062213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220430 ORDER BY `minOrder` ASC [ RunTime:0.063473s ]
select * from pdf where partno='SMAJ13AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.036833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012561s ]
SELECT `id` FROM `stock` WHERE `id` <> 42220430 AND `partno` = 'SMAJ13AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.033920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912690 [ RunTime:0.016957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42220242 LIMIT 4 [ RunTime:0.041613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220242 ORDER BY `minOrder` ASC [ RunTime:0.022737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42220242 ORDER BY `unit` DESC [ RunTime:0.021987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42220242 LIMIT 2 [ RunTime:0.108829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220242 ORDER BY `minOrder` ASC [ RunTime:0.024167s ]
select * from pdf where partno='SMAJ13AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.085861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021693s ]
SELECT `id` FROM `stock` WHERE `id` <> 42220242 AND `partno` = 'SMAJ13AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912705 [ RunTime:0.084420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42216614 LIMIT 4 [ RunTime:0.059715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216614 ORDER BY `minOrder` ASC [ RunTime:0.083519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42216614 ORDER BY `unit` DESC [ RunTime:0.096249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42216614 LIMIT 2 [ RunTime:0.044468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216614 ORDER BY `minOrder` ASC [ RunTime:0.013325s ]
select * from pdf where partno='SMAJ13AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031933s ]
SELECT `id` FROM `stock` WHERE `id` <> 42216614 AND `partno` = 'SMAJ13AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911799 [ RunTime:0.066925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42209220 LIMIT 4 [ RunTime:0.049483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209220 ORDER BY `minOrder` ASC [ RunTime:0.080814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42209220 ORDER BY `unit` DESC [ RunTime:0.049343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42209220 LIMIT 2 [ RunTime:0.023311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209220 ORDER BY `minOrder` ASC [ RunTime:0.037347s ]
select * from pdf where partno='SMAJ13AQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.036171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ13AQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.066723s ]
SELECT `id` FROM `stock` WHERE `id` <> 42209220 AND `partno` = 'SMAJ13AQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.044415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668224 [ RunTime:0.054476s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ13A%' OR `brand` LIKE 'SMAJ13A%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.066170s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ13A%' OR `brand` LIKE 'SMAJ13A%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.012107s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ13A%' OR `brand` LIKE 'SMAJ13A%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.001722s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 21 [ RunTime:0.001784s ]