SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.000981s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `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=P4SMAJ43&search=1' [ RunTime:0.002855s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002005s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000521s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001731s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.015809s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001198s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007233s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001391s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMAJ43' LIMIT 1 [ RunTime:0.009616s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-14 12:39:32' WHERE `partno` = 'P4SMAJ43' [ RunTime:0.028394s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002561s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028359s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799576 LIMIT 5 [ RunTime:0.017584s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799576 ORDER BY `minOrder` ASC [ RunTime:0.003128s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799576 ORDER BY `unit` DESC [ RunTime:0.015966s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799576 LIMIT 2 [ RunTime:0.015623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799576 ORDER BY `minOrder` ASC [ RunTime:0.011787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661058 LIMIT 5 [ RunTime:0.019600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661058 ORDER BY `minOrder` ASC [ RunTime:0.033885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661058 ORDER BY `unit` DESC [ RunTime:0.007386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661058 LIMIT 2 [ RunTime:0.026206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661058 ORDER BY `minOrder` ASC [ RunTime:0.002276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662655 LIMIT 5 [ RunTime:0.015363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662655 ORDER BY `minOrder` ASC [ RunTime:0.005519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662655 ORDER BY `unit` DESC [ RunTime:0.011806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662655 LIMIT 2 [ RunTime:0.001506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662655 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905889 LIMIT 5 [ RunTime:0.010551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905889 ORDER BY `minOrder` ASC [ RunTime:0.014022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905889 ORDER BY `unit` DESC [ RunTime:0.005347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905889 LIMIT 2 [ RunTime:0.012054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905889 ORDER BY `minOrder` ASC [ RunTime:0.008618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906008 LIMIT 5 [ RunTime:0.004209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906008 ORDER BY `minOrder` ASC [ RunTime:0.017482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906008 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906008 LIMIT 2 [ RunTime:0.004281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906008 ORDER BY `minOrder` ASC [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905779 LIMIT 5 [ RunTime:0.025977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905779 ORDER BY `minOrder` ASC [ RunTime:0.023186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905779 ORDER BY `unit` DESC [ RunTime:0.009729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905779 LIMIT 2 [ RunTime:0.005125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905779 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800863 LIMIT 5 [ RunTime:0.001020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800863 ORDER BY `minOrder` ASC [ RunTime:0.021080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800863 ORDER BY `unit` DESC [ RunTime:0.020452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800863 LIMIT 2 [ RunTime:0.028112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800863 ORDER BY `minOrder` ASC [ RunTime:0.004695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676058 LIMIT 5 [ RunTime:0.013890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676058 ORDER BY `minOrder` ASC [ RunTime:0.007385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676058 ORDER BY `unit` DESC [ RunTime:0.012490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676058 LIMIT 2 [ RunTime:0.013579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676058 ORDER BY `minOrder` ASC [ RunTime:0.020556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666851 LIMIT 5 [ RunTime:0.018504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666851 ORDER BY `minOrder` ASC [ RunTime:0.012055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666851 ORDER BY `unit` DESC [ RunTime:0.000734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666851 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666851 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666833 LIMIT 5 [ RunTime:0.010679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666833 ORDER BY `minOrder` ASC [ RunTime:0.009868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666833 ORDER BY `unit` DESC [ RunTime:0.052003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666833 LIMIT 2 [ RunTime:0.029936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666833 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805375 LIMIT 5 [ RunTime:0.013474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805375 ORDER BY `minOrder` ASC [ RunTime:0.013664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805375 ORDER BY `unit` DESC [ RunTime:0.007515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805375 LIMIT 2 [ RunTime:0.006920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805375 ORDER BY `minOrder` ASC [ RunTime:0.002052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805259 LIMIT 5 [ RunTime:0.005480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805259 ORDER BY `minOrder` ASC [ RunTime:0.014930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805259 ORDER BY `unit` DESC [ RunTime:0.002452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805259 LIMIT 2 [ RunTime:0.002258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805259 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918897 LIMIT 5 [ RunTime:0.008976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918897 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918897 ORDER BY `unit` DESC [ RunTime:0.007241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918897 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918897 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911820 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911820 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911820 ORDER BY `unit` DESC [ RunTime:0.009804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911820 LIMIT 2 [ RunTime:0.005129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911820 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004596s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145261 LIMIT 5 [ RunTime:0.002154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145261 ORDER BY `minOrder` ASC [ RunTime:0.019159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145261 ORDER BY `unit` DESC [ RunTime:0.009729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145261 LIMIT 2 [ RunTime:0.009163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145261 ORDER BY `minOrder` ASC [ RunTime:0.005914s ]
select * from pdf where partno='P4SMAJ43A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.012896s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008072s ]
SELECT `id` FROM `stock` WHERE `id` <> 42145261 AND `partno` = 'P4SMAJ43A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.006667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799576 [ RunTime:0.000858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123960 LIMIT 5 [ RunTime:0.009419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123960 ORDER BY `minOrder` ASC [ RunTime:0.013913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123960 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123960 LIMIT 2 [ RunTime:0.003593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123960 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='P4SMAJ43CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.004905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000616s ]
SELECT `id` FROM `stock` WHERE `id` <> 42123960 AND `partno` = 'P4SMAJ43CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661058 [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150877 LIMIT 5 [ RunTime:0.001868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150877 ORDER BY `minOrder` ASC [ RunTime:0.015272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150877 ORDER BY `unit` DESC [ RunTime:0.007466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150877 LIMIT 2 [ RunTime:0.003386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150877 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
select * from pdf where partno='P4SMAJ43AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000472s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150877 AND `partno` = 'P4SMAJ43AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.001749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662655 [ RunTime:0.000824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149177 LIMIT 5 [ RunTime:0.002748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149177 ORDER BY `minOrder` ASC [ RunTime:0.003257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149177 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149177 LIMIT 2 [ RunTime:0.002366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149177 ORDER BY `minOrder` ASC [ RunTime:0.002220s ]
select * from pdf where partno='P4SMAJ43CA-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43CA-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000542s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149177 AND `partno` = 'P4SMAJ43CA-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.004582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905889 [ RunTime:0.005863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152106 LIMIT 5 [ RunTime:0.001076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152106 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152106 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152106 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152106 ORDER BY `minOrder` ASC [ RunTime:0.002283s ]
select * from pdf where partno='P4SMAJ43CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.006900s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152106 AND `partno` = 'P4SMAJ43CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906008 [ RunTime:0.003985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149023 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149023 ORDER BY `minOrder` ASC [ RunTime:0.004583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149023 ORDER BY `unit` DESC [ RunTime:0.007085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149023 LIMIT 2 [ RunTime:0.001959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149023 ORDER BY `minOrder` ASC [ RunTime:0.002743s ]
select * from pdf where partno='P4SMAJ43A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.006313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001202s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149023 AND `partno` = 'P4SMAJ43A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905779 [ RunTime:0.001329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149201 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149201 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149201 ORDER BY `unit` DESC [ RunTime:0.003395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149201 LIMIT 2 [ RunTime:0.007441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149201 ORDER BY `minOrder` ASC [ RunTime:0.002477s ]
select * from pdf where partno='P4SMAJ43CAS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43CAS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.012355s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149201 AND `partno` = 'P4SMAJ43CAS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800863 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202137 LIMIT 5 [ RunTime:0.004720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202137 ORDER BY `minOrder` ASC [ RunTime:0.012270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202137 ORDER BY `unit` DESC [ RunTime:0.009188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202137 LIMIT 2 [ RunTime:0.010425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202137 ORDER BY `minOrder` ASC [ RunTime:0.007737s ]
select * from pdf where partno='P4SMAJ43ADF-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.024640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43ADF-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000978s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202137 AND `partno` = 'P4SMAJ43ADF-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.009951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911820 [ RunTime:0.001395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196805 LIMIT 5 [ RunTime:0.004528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196805 ORDER BY `minOrder` ASC [ RunTime:0.004128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196805 ORDER BY `unit` DESC [ RunTime:0.002016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196805 LIMIT 2 [ RunTime:0.001435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196805 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='P4SMAJ43CA-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43CA-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009885s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196805 AND `partno` = 'P4SMAJ43CA-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.009777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666851 [ RunTime:0.001185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196558 LIMIT 5 [ RunTime:0.006698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196558 ORDER BY `minOrder` ASC [ RunTime:0.005798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196558 ORDER BY `unit` DESC [ RunTime:0.007016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196558 LIMIT 2 [ RunTime:0.001557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196558 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
select * from pdf where partno='P4SMAJ43A-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43A-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000805s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196558 AND `partno` = 'P4SMAJ43A-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.022466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666833 [ RunTime:0.003221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42187643 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187643 ORDER BY `minOrder` ASC [ RunTime:0.005893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42187643 ORDER BY `unit` DESC [ RunTime:0.008005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42187643 LIMIT 2 [ RunTime:0.001745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187643 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='P4SMAJ43C' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43C' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001755s ]
SELECT `id` FROM `stock` WHERE `id` <> 42187643 AND `partno` = 'P4SMAJ43C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.006666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805375 [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42187424 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187424 ORDER BY `minOrder` ASC [ RunTime:0.014137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42187424 ORDER BY `unit` DESC [ RunTime:0.009646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42187424 LIMIT 2 [ RunTime:0.013433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187424 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='P4SMAJ43' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.002068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ43' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003193s ]
SELECT `id` FROM `stock` WHERE `id` <> 42187424 AND `partno` = 'P4SMAJ43' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.009885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805259 [ RunTime:0.002434s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001886s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008944s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001204s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013192s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001538s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002817s ]
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 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001278s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMAJ43%' OR `brand` LIKE 'P4SMAJ43%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006996s ]