SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001702s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=A161&search=1' [ RunTime:0.011401s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001595s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.023395s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001786s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.003659s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001325s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007204s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001921s ]
SELECT * FROM `stock_search` WHERE `partno` = 'A161' LIMIT 1 [ RunTime:0.042084s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-13 14:19:00' WHERE `partno` = 'A161' [ RunTime:0.050036s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002806s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098528s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19302569 LIMIT 5 [ RunTime:0.036448s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302569 ORDER BY `minOrder` ASC [ RunTime:0.014662s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.022989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19302569 ORDER BY `unit` DESC [ RunTime:0.065244s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.027312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19302569 LIMIT 2 [ RunTime:0.050164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302569 ORDER BY `minOrder` ASC [ RunTime:0.002214s ]
select * from pdf where partno='A161CS12VDC.64' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.041325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11170860 LIMIT 5 [ RunTime:0.084376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11170860 ORDER BY `minOrder` ASC [ RunTime:0.081015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11170860 ORDER BY `unit` DESC [ RunTime:0.104686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11170860 LIMIT 2 [ RunTime:0.055190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11170860 ORDER BY `minOrder` ASC [ RunTime:0.068813s ]
select * from pdf where partno='A16104-01' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.036990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147706 LIMIT 5 [ RunTime:0.070879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12147706 ORDER BY `minOrder` ASC [ RunTime:0.055850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12147706 ORDER BY `unit` DESC [ RunTime:0.024495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12147706 LIMIT 2 [ RunTime:0.134190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12147706 ORDER BY `minOrder` ASC [ RunTime:0.002624s ]
select * from pdf where partno='A16104-04' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.077475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19033824 LIMIT 5 [ RunTime:0.114979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033824 ORDER BY `minOrder` ASC [ RunTime:0.022212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19033824 ORDER BY `unit` DESC [ RunTime:0.075846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19033824 LIMIT 2 [ RunTime:0.059920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19033824 ORDER BY `minOrder` ASC [ RunTime:0.018067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060304 LIMIT 5 [ RunTime:0.056012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060304 ORDER BY `minOrder` ASC [ RunTime:0.048707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17060304 ORDER BY `unit` DESC [ RunTime:0.079771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17060304 LIMIT 2 [ RunTime:0.057803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060304 ORDER BY `minOrder` ASC [ RunTime:0.030555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12149491 LIMIT 5 [ RunTime:0.107265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12149491 ORDER BY `minOrder` ASC [ RunTime:0.109218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12149491 ORDER BY `unit` DESC [ RunTime:0.052215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12149491 LIMIT 2 [ RunTime:0.070924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12149491 ORDER BY `minOrder` ASC [ RunTime:0.019469s ]
select * from pdf where partno='A16104-16' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.068167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037927 LIMIT 5 [ RunTime:0.053847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037927 ORDER BY `minOrder` ASC [ RunTime:0.114803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037927 ORDER BY `unit` DESC [ RunTime:0.054626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037927 LIMIT 2 [ RunTime:0.102023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037927 ORDER BY `minOrder` ASC [ RunTime:0.036009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277919 LIMIT 5 [ RunTime:0.046831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277919 ORDER BY `minOrder` ASC [ RunTime:0.045841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277919 ORDER BY `unit` DESC [ RunTime:0.052520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277919 LIMIT 2 [ RunTime:0.083235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277919 ORDER BY `minOrder` ASC [ RunTime:0.067403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15275279 LIMIT 5 [ RunTime:0.036598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15275279 ORDER BY `minOrder` ASC [ RunTime:0.023793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15275279 ORDER BY `unit` DESC [ RunTime:0.060622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15275279 LIMIT 2 [ RunTime:0.059406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15275279 ORDER BY `minOrder` ASC [ RunTime:0.034180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15273904 LIMIT 5 [ RunTime:0.014491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15273904 ORDER BY `minOrder` ASC [ RunTime:0.030398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15273904 ORDER BY `unit` DESC [ RunTime:0.164263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15273904 LIMIT 2 [ RunTime:0.065697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15273904 ORDER BY `minOrder` ASC [ RunTime:0.017219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17057416 LIMIT 5 [ RunTime:0.049368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17057416 ORDER BY `minOrder` ASC [ RunTime:0.023268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17057416 ORDER BY `unit` DESC [ RunTime:0.087027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17057416 LIMIT 2 [ RunTime:0.002346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17057416 ORDER BY `minOrder` ASC [ RunTime:0.014285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17059963 LIMIT 5 [ RunTime:0.027548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17059963 ORDER BY `minOrder` ASC [ RunTime:0.027064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17059963 ORDER BY `unit` DESC [ RunTime:0.020794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17059963 LIMIT 2 [ RunTime:0.024165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17059963 ORDER BY `minOrder` ASC [ RunTime:0.010072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034548 LIMIT 5 [ RunTime:0.025221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034548 ORDER BY `minOrder` ASC [ RunTime:0.024106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034548 ORDER BY `unit` DESC [ RunTime:0.062032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034548 LIMIT 2 [ RunTime:0.015143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034548 ORDER BY `minOrder` ASC [ RunTime:0.012372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028774 LIMIT 5 [ RunTime:0.008534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19028774 ORDER BY `minOrder` ASC [ RunTime:0.010426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19028774 ORDER BY `unit` DESC [ RunTime:0.005241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19028774 LIMIT 2 [ RunTime:0.018383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19028774 ORDER BY `minOrder` ASC [ RunTime:0.007734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19534032 LIMIT 5 [ RunTime:0.014889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534032 ORDER BY `minOrder` ASC [ RunTime:0.014976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19534032 ORDER BY `unit` DESC [ RunTime:0.015594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19534032 LIMIT 2 [ RunTime:0.013797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534032 ORDER BY `minOrder` ASC [ RunTime:0.006721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19029337 LIMIT 5 [ RunTime:0.021823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19029337 ORDER BY `minOrder` ASC [ RunTime:0.013243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19029337 ORDER BY `unit` DESC [ RunTime:0.010291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19029337 LIMIT 2 [ RunTime:0.021570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19029337 ORDER BY `minOrder` ASC [ RunTime:0.011386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17059960 LIMIT 5 [ RunTime:0.005168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17059960 ORDER BY `minOrder` ASC [ RunTime:0.006128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17059960 ORDER BY `unit` DESC [ RunTime:0.050251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17059960 LIMIT 2 [ RunTime:0.030727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17059960 ORDER BY `minOrder` ASC [ RunTime:0.008977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147754 LIMIT 5 [ RunTime:0.021335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12147754 ORDER BY `minOrder` ASC [ RunTime:0.032166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12147754 ORDER BY `unit` DESC [ RunTime:0.032412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12147754 LIMIT 2 [ RunTime:0.017583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12147754 ORDER BY `minOrder` ASC [ RunTime:0.004928s ]
select * from pdf where partno='A16104-20' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.016282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034478 LIMIT 5 [ RunTime:0.026605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034478 ORDER BY `minOrder` ASC [ RunTime:0.010033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034478 ORDER BY `unit` DESC [ RunTime:0.013833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034478 LIMIT 2 [ RunTime:0.041626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034478 ORDER BY `minOrder` ASC [ RunTime:0.021116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036463 LIMIT 5 [ RunTime:0.014948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036463 ORDER BY `minOrder` ASC [ RunTime:0.027970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036463 ORDER BY `unit` DESC [ RunTime:0.043808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036463 LIMIT 2 [ RunTime:0.011709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036463 ORDER BY `minOrder` ASC [ RunTime:0.005808s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287638 LIMIT 5 [ RunTime:0.012220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287638 ORDER BY `minOrder` ASC [ RunTime:0.031473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287638 ORDER BY `unit` DESC [ RunTime:0.028421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287638 LIMIT 2 [ RunTime:0.024666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287638 ORDER BY `minOrder` ASC [ RunTime:0.008675s ]
select * from pdf where partno='a16104-04' and brandshort='laird technologies' limit 1 [ RunTime:0.068702s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-04' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.008153s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287638 AND `partno` = 'a16104-04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.010897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147706 [ RunTime:0.027576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287798 LIMIT 5 [ RunTime:0.017898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287798 ORDER BY `minOrder` ASC [ RunTime:0.023898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287798 ORDER BY `unit` DESC [ RunTime:0.016028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287798 LIMIT 2 [ RunTime:0.015408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287798 ORDER BY `minOrder` ASC [ RunTime:0.009072s ]
select * from pdf where partno='a16104-01' and brandshort='laird technologies' limit 1 [ RunTime:0.026461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-01' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.005959s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287798 AND `partno` = 'a16104-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.036604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11170860 [ RunTime:0.008758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287639 LIMIT 5 [ RunTime:0.007804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287639 ORDER BY `minOrder` ASC [ RunTime:0.010787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287639 ORDER BY `unit` DESC [ RunTime:0.041574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287639 LIMIT 2 [ RunTime:0.015941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287639 ORDER BY `minOrder` ASC [ RunTime:0.004410s ]
select * from pdf where partno='a16104-10' and brandshort='laird technologies' limit 1 [ RunTime:0.010642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-10' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.004581s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287639 AND `partno` = 'a16104-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.001224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148584 [ RunTime:0.005392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32288121 LIMIT 5 [ RunTime:0.003423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288121 ORDER BY `minOrder` ASC [ RunTime:0.022364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32288121 ORDER BY `unit` DESC [ RunTime:0.001105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32288121 LIMIT 2 [ RunTime:0.019566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32288121 ORDER BY `minOrder` ASC [ RunTime:0.026684s ]
select * from pdf where partno='a16104-06' and brandshort='laird technologies' limit 1 [ RunTime:0.022755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-06' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.021302s ]
SELECT `id` FROM `stock` WHERE `id` <> 32288121 AND `partno` = 'a16104-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.021541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58494618 [ RunTime:0.008112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287799 LIMIT 5 [ RunTime:0.006353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287799 ORDER BY `minOrder` ASC [ RunTime:0.050951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287799 ORDER BY `unit` DESC [ RunTime:0.006879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287799 LIMIT 2 [ RunTime:0.001032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287799 ORDER BY `minOrder` ASC [ RunTime:0.003981s ]
select * from pdf where partno='a16104-03' and brandshort='laird technologies' limit 1 [ RunTime:0.039782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-03' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.031471s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287799 AND `partno` = 'a16104-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.037359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147704 [ RunTime:0.023619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111887 LIMIT 5 [ RunTime:0.024049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111887 ORDER BY `minOrder` ASC [ RunTime:0.043649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111887 ORDER BY `unit` DESC [ RunTime:0.050685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111887 LIMIT 2 [ RunTime:0.094261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111887 ORDER BY `minOrder` ASC [ RunTime:0.027937s ]
select * from pdf where partno='a161' and brandshort='m5stack' limit 1 [ RunTime:0.034081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a161' OR `brand` LIKE 'm5stack%' ) ) LIMIT 1 [ RunTime:0.022596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287800 LIMIT 5 [ RunTime:0.028606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287800 ORDER BY `minOrder` ASC [ RunTime:0.030520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287800 ORDER BY `unit` DESC [ RunTime:0.027730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287800 LIMIT 2 [ RunTime:0.004863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287800 ORDER BY `minOrder` ASC [ RunTime:0.032777s ]
select * from pdf where partno='a16104-08' and brandshort='laird technologies' limit 1 [ RunTime:0.002503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-08' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.013907s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287800 AND `partno` = 'a16104-08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.010552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12149487 [ RunTime:0.034781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287802 LIMIT 5 [ RunTime:0.009478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287802 ORDER BY `minOrder` ASC [ RunTime:0.016959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287802 ORDER BY `unit` DESC [ RunTime:0.010423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287802 LIMIT 2 [ RunTime:0.009664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287802 ORDER BY `minOrder` ASC [ RunTime:0.000882s ]
select * from pdf where partno='a16104-16' and brandshort='laird technologies' limit 1 [ RunTime:0.000873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-16' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.007528s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287802 AND `partno` = 'a16104-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.038063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12149491 [ RunTime:0.010942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287978 LIMIT 5 [ RunTime:0.015818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287978 ORDER BY `minOrder` ASC [ RunTime:0.003262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287978 ORDER BY `unit` DESC [ RunTime:0.006485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287978 LIMIT 2 [ RunTime:0.018849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287978 ORDER BY `minOrder` ASC [ RunTime:0.028529s ]
select * from pdf where partno='a16104-12' and brandshort='laird technologies' limit 1 [ RunTime:0.002220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-12' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.040230s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287978 AND `partno` = 'a16104-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.024485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58498622 [ RunTime:0.012801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32287801 LIMIT 5 [ RunTime:0.026256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287801 ORDER BY `minOrder` ASC [ RunTime:0.039940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32287801 ORDER BY `unit` DESC [ RunTime:0.027751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32287801 LIMIT 2 [ RunTime:0.042057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32287801 ORDER BY `minOrder` ASC [ RunTime:0.011494s ]
select * from pdf where partno='a16104-15' and brandshort='laird technologies' limit 1 [ RunTime:0.009847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a16104-15' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.013569s ]
SELECT `id` FROM `stock` WHERE `id` <> 32287801 AND `partno` = 'a16104-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.005799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11172522 [ RunTime:0.039043s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462880 LIMIT 5 [ RunTime:0.041827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462880 ORDER BY `minOrder` ASC [ RunTime:0.007258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462880 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462880 LIMIT 2 [ RunTime:0.004916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462880 ORDER BY `minOrder` ASC [ RunTime:0.006934s ]
select * from pdf where partno='A161CS12VDC.64' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.004613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A161CS12VDC.64' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.018055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58494183 LIMIT 5 [ RunTime:0.013164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494183 ORDER BY `minOrder` ASC [ RunTime:0.015817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58494183 ORDER BY `unit` DESC [ RunTime:0.007385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58494183 LIMIT 2 [ RunTime:0.029090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494183 ORDER BY `minOrder` ASC [ RunTime:0.003430s ]
select * from pdf where partno='A16104-01' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.001845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-01' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.001033s ]
SELECT `id` FROM `stock` WHERE `id` <> 58494183 AND `partno` = 'A16104-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.005000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11170860 [ RunTime:0.006498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58494598 LIMIT 5 [ RunTime:0.041377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494598 ORDER BY `minOrder` ASC [ RunTime:0.023091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58494598 ORDER BY `unit` DESC [ RunTime:0.003182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58494598 LIMIT 2 [ RunTime:0.009114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494598 ORDER BY `minOrder` ASC [ RunTime:0.006638s ]
select * from pdf where partno='A16104-04' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.007511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-04' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.001053s ]
SELECT `id` FROM `stock` WHERE `id` <> 58494598 AND `partno` = 'A16104-04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.010177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147706 [ RunTime:0.006279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58494289 LIMIT 5 [ RunTime:0.006122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494289 ORDER BY `minOrder` ASC [ RunTime:0.005550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58494289 ORDER BY `unit` DESC [ RunTime:0.001142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58494289 LIMIT 2 [ RunTime:0.002864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494289 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
select * from pdf where partno='A16104-10' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.005286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-10' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.008917s ]
SELECT `id` FROM `stock` WHERE `id` <> 58494289 AND `partno` = 'A16104-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.002443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12148584 [ RunTime:0.012637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64051014 LIMIT 5 [ RunTime:0.013758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64051014 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64051014 ORDER BY `unit` DESC [ RunTime:0.016368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64051014 LIMIT 2 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64051014 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='A161' and brandshort='M5Stack Technology Co., Ltd.' limit 1 [ RunTime:0.000828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A161' OR `brand` LIKE 'M5Stack Technology Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.007953s ]
SELECT `id` FROM `stock` WHERE `id` <> 64051014 AND `partno` = 'A161' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%m5stack technology co., ltd.%' ) [ RunTime:0.009613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58494644 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494644 ORDER BY `minOrder` ASC [ RunTime:0.001113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58494644 ORDER BY `unit` DESC [ RunTime:0.005425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58494644 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494644 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='A16104-13' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.000966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-13' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.013886s ]
SELECT `id` FROM `stock` WHERE `id` <> 58494644 AND `partno` = 'A16104-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.008414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58494618 LIMIT 5 [ RunTime:0.002395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494618 ORDER BY `minOrder` ASC [ RunTime:0.003740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58494618 ORDER BY `unit` DESC [ RunTime:0.002865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58494618 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58494618 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
select * from pdf where partno='A16104-06' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.006454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-06' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.001741s ]
SELECT `id` FROM `stock` WHERE `id` <> 58494618 AND `partno` = 'A16104-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58498174 LIMIT 5 [ RunTime:0.009119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498174 ORDER BY `minOrder` ASC [ RunTime:0.003700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58498174 ORDER BY `unit` DESC [ RunTime:0.007630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58498174 LIMIT 2 [ RunTime:0.004723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498174 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='A16104-03' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.001122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-03' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.000924s ]
SELECT `id` FROM `stock` WHERE `id` <> 58498174 AND `partno` = 'A16104-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.006128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147704 [ RunTime:0.003019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423062 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423062 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423062 ORDER BY `unit` DESC [ RunTime:0.005934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423062 LIMIT 2 [ RunTime:0.028788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423062 ORDER BY `minOrder` ASC [ RunTime:0.006021s ]
select * from pdf where partno='A16148CHQRFG' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16148CHQRFG' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.004991s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423062 AND `partno` = 'A16148CHQRFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.002116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037927 [ RunTime:0.002681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58498066 LIMIT 5 [ RunTime:0.000878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498066 ORDER BY `minOrder` ASC [ RunTime:0.001462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58498066 ORDER BY `unit` DESC [ RunTime:0.007054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58498066 LIMIT 2 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498066 ORDER BY `minOrder` ASC [ RunTime:0.002563s ]
select * from pdf where partno='A16104-20' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.000662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-20' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.004723s ]
SELECT `id` FROM `stock` WHERE `id` <> 58498066 AND `partno` = 'A16104-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.002134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12147754 [ RunTime:0.000949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423763 LIMIT 5 [ RunTime:0.003562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423763 ORDER BY `minOrder` ASC [ RunTime:0.011059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423763 ORDER BY `unit` DESC [ RunTime:0.009060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423763 LIMIT 2 [ RunTime:0.003576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423763 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='A1614CHNF' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1614CHNF' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.003476s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423763 AND `partno` = 'A1614CHNF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.007954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15273904 [ RunTime:0.004484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423748 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423748 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423748 ORDER BY `unit` DESC [ RunTime:0.001926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423748 LIMIT 2 [ RunTime:0.005849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423748 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='A161410CH' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A161410CH' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.002784s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423748 AND `partno` = 'A161410CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.002384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19029337 [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58498233 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498233 ORDER BY `minOrder` ASC [ RunTime:0.001747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58498233 ORDER BY `unit` DESC [ RunTime:0.008894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58498233 LIMIT 2 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498233 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
select * from pdf where partno='A16104-16' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.000641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-16' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.001138s ]
SELECT `id` FROM `stock` WHERE `id` <> 58498233 AND `partno` = 'A16104-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.003830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12149491 [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423860 LIMIT 5 [ RunTime:0.001025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423860 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423860 ORDER BY `unit` DESC [ RunTime:0.000743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423860 LIMIT 2 [ RunTime:0.003676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423860 ORDER BY `minOrder` ASC [ RunTime:0.009201s ]
select * from pdf where partno='A1614CHNFSS' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.017285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1614CHNFSS' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.004098s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423860 AND `partno` = 'A1614CHNFSS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.002198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034548 [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423795 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423795 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423795 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423795 LIMIT 2 [ RunTime:0.003349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423795 ORDER BY `minOrder` ASC [ RunTime:0.006159s ]
select * from pdf where partno='A16148CHQRFGW' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.001790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16148CHQRFGW' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000999s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423795 AND `partno` = 'A16148CHQRFGW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17057416 [ RunTime:0.000549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58498622 LIMIT 5 [ RunTime:0.009225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498622 ORDER BY `minOrder` ASC [ RunTime:0.004480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58498622 ORDER BY `unit` DESC [ RunTime:0.004354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58498622 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58498622 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='A16104-12' and brandshort='Laird Technologies - Thermal Materials' limit 1 [ RunTime:0.003486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16104-12' OR `brand` LIKE 'Laird Technologies - Thermal Materials%' ) ) LIMIT 1 [ RunTime:0.002996s ]
SELECT `id` FROM `stock` WHERE `id` <> 58498622 AND `partno` = 'A16104-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies - thermal materials%' ) [ RunTime:0.001603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423695 LIMIT 5 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423695 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423695 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423695 LIMIT 2 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423695 ORDER BY `minOrder` ASC [ RunTime:0.002675s ]
select * from pdf where partno='A16106CH' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.002194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16106CH' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.003479s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423695 AND `partno` = 'A16106CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.013975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060304 [ RunTime:0.031397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423726 LIMIT 5 [ RunTime:0.001702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423726 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423726 ORDER BY `unit` DESC [ RunTime:0.010073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423726 LIMIT 2 [ RunTime:0.014080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423726 ORDER BY `minOrder` ASC [ RunTime:0.007399s ]
select * from pdf where partno='A16148CH' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.004181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16148CH' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000997s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423726 AND `partno` = 'A16148CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19028774 [ RunTime:0.003406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423719 LIMIT 5 [ RunTime:0.009868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423719 ORDER BY `minOrder` ASC [ RunTime:0.003745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423719 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423719 LIMIT 2 [ RunTime:0.008243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423719 ORDER BY `minOrder` ASC [ RunTime:0.003759s ]
select * from pdf where partno='A16148CHSCFG' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.009461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A16148CHSCFG' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.001067s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423719 AND `partno` = 'A16148CHSCFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.010873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15275279 [ RunTime:0.003633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423713 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423713 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423713 ORDER BY `unit` DESC [ RunTime:0.008866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423713 LIMIT 2 [ RunTime:0.023129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423713 ORDER BY `minOrder` ASC [ RunTime:0.003609s ]
select * from pdf where partno='A1614CH' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.002899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A1614CH' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.003502s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423713 AND `partno` = 'A1614CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.007981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277919 [ RunTime:0.000970s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010076s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007154s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008668s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020763s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003536s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001582s ]
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 'A161%' OR `brand` LIKE 'A161%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004031s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A161%' OR `brand` LIKE 'A161%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002655s ]