SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001417s ]
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=P4SMAJ51&search=1' [ RunTime:0.002537s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001182s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000580s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002464s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.002600s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002769s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002158s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMAJ51' LIMIT 1 [ RunTime:0.011979s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-15 04:28:35' WHERE `partno` = 'P4SMAJ51' [ RunTime:0.010471s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002461s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011078s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662665 LIMIT 5 [ RunTime:0.032010s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662665 ORDER BY `minOrder` ASC [ RunTime:0.006472s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662665 ORDER BY `unit` DESC [ RunTime:0.007493s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662665 LIMIT 2 [ RunTime:0.034069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662665 ORDER BY `minOrder` ASC [ RunTime:0.028843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905921 LIMIT 5 [ RunTime:0.022119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905921 ORDER BY `minOrder` ASC [ RunTime:0.036175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905921 ORDER BY `unit` DESC [ RunTime:0.048658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905921 LIMIT 2 [ RunTime:0.006577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905921 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662515 LIMIT 5 [ RunTime:0.017599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662515 ORDER BY `minOrder` ASC [ RunTime:0.011751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662515 ORDER BY `unit` DESC [ RunTime:0.028189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662515 LIMIT 2 [ RunTime:0.010997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662515 ORDER BY `minOrder` ASC [ RunTime:0.009185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662479 LIMIT 5 [ RunTime:0.019305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662479 ORDER BY `minOrder` ASC [ RunTime:0.050786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662479 ORDER BY `unit` DESC [ RunTime:0.015025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662479 LIMIT 2 [ RunTime:0.028386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662479 ORDER BY `minOrder` ASC [ RunTime:0.029348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676198 LIMIT 5 [ RunTime:0.016331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676198 ORDER BY `minOrder` ASC [ RunTime:0.009558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676198 ORDER BY `unit` DESC [ RunTime:0.015670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676198 LIMIT 2 [ RunTime:0.017752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676198 ORDER BY `minOrder` ASC [ RunTime:0.016793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666838 LIMIT 5 [ RunTime:0.020211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666838 ORDER BY `minOrder` ASC [ RunTime:0.043812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666838 ORDER BY `unit` DESC [ RunTime:0.007831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666838 LIMIT 2 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666838 ORDER BY `minOrder` ASC [ RunTime:0.002665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665944 LIMIT 5 [ RunTime:0.031666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665944 ORDER BY `minOrder` ASC [ RunTime:0.003505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665944 ORDER BY `unit` DESC [ RunTime:0.009533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665944 LIMIT 2 [ RunTime:0.010232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665944 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665902 LIMIT 5 [ RunTime:0.004178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665902 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665902 ORDER BY `unit` DESC [ RunTime:0.004480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665902 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665902 ORDER BY `minOrder` ASC [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818207 LIMIT 5 [ RunTime:0.001141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818207 ORDER BY `minOrder` ASC [ RunTime:0.007156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818207 ORDER BY `unit` DESC [ RunTime:0.003026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818207 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818207 ORDER BY `minOrder` ASC [ RunTime:0.001863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816611 LIMIT 5 [ RunTime:0.008095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816611 ORDER BY `minOrder` ASC [ RunTime:0.003055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816611 ORDER BY `unit` DESC [ RunTime:0.003407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816611 LIMIT 2 [ RunTime:0.013705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816611 ORDER BY `minOrder` ASC [ RunTime:0.003059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808147 LIMIT 5 [ RunTime:0.001158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808147 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808147 ORDER BY `unit` DESC [ RunTime:0.001488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808147 LIMIT 2 [ RunTime:0.001153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808147 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910550 LIMIT 5 [ RunTime:0.001357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910550 ORDER BY `minOrder` ASC [ RunTime:0.008754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910550 ORDER BY `unit` DESC [ RunTime:0.003676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910550 LIMIT 2 [ RunTime:0.013738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910550 ORDER BY `minOrder` ASC [ RunTime:0.007292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909739 LIMIT 5 [ RunTime:0.019752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909739 ORDER BY `minOrder` ASC [ RunTime:0.009896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909739 ORDER BY `unit` DESC [ RunTime:0.004994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909739 LIMIT 2 [ RunTime:0.000956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909739 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909677 LIMIT 5 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909677 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909677 ORDER BY `unit` DESC [ RunTime:0.002297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909677 LIMIT 2 [ RunTime:0.003317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909677 ORDER BY `minOrder` ASC [ RunTime:0.005749s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002373s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42151141 LIMIT 5 [ RunTime:0.012281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151141 ORDER BY `minOrder` ASC [ RunTime:0.003739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42151141 ORDER BY `unit` DESC [ RunTime:0.002705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42151141 LIMIT 2 [ RunTime:0.004771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151141 ORDER BY `minOrder` ASC [ RunTime:0.007947s ]
select * from pdf where partno='P4SMAJ51CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.004846s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.015956s ]
SELECT `id` FROM `stock` WHERE `id` <> 42151141 AND `partno` = 'P4SMAJ51CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.012863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905921 [ RunTime:0.002087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150898 LIMIT 5 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150898 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150898 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150898 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150898 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='P4SMAJ51AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.003694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000701s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150898 AND `partno` = 'P4SMAJ51AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.001035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662665 [ RunTime:0.003006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149171 LIMIT 5 [ RunTime:0.001786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149171 ORDER BY `minOrder` ASC [ RunTime:0.029331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149171 ORDER BY `unit` DESC [ RunTime:0.005844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149171 LIMIT 2 [ RunTime:0.005228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149171 ORDER BY `minOrder` ASC [ RunTime:0.005539s ]
select * from pdf where partno='P4SMAJ51CAS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.002611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51CAS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002757s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149171 AND `partno` = 'P4SMAJ51CAS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.004985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662515 [ RunTime:0.007851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149126 LIMIT 5 [ RunTime:0.008462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149126 ORDER BY `minOrder` ASC [ RunTime:0.002262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149126 ORDER BY `unit` DESC [ RunTime:0.003119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149126 LIMIT 2 [ RunTime:0.006633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149126 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='P4SMAJ51A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001645s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149126 AND `partno` = 'P4SMAJ51A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.003638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662479 [ RunTime:0.007260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202136 LIMIT 5 [ RunTime:0.004077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202136 ORDER BY `minOrder` ASC [ RunTime:0.006484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202136 ORDER BY `unit` DESC [ RunTime:0.000986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202136 LIMIT 2 [ RunTime:0.005766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202136 ORDER BY `minOrder` ASC [ RunTime:0.003429s ]
select * from pdf where partno='P4SMAJ51ADF-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51ADF-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.012609s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202136 AND `partno` = 'P4SMAJ51ADF-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.011584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808147 [ RunTime:0.001689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42199264 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199264 ORDER BY `minOrder` ASC [ RunTime:0.001379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42199264 ORDER BY `unit` DESC [ RunTime:0.018969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42199264 LIMIT 2 [ RunTime:0.002851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199264 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='P4SMAJ51A-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.002770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51A-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.008545s ]
SELECT `id` FROM `stock` WHERE `id` <> 42199264 AND `partno` = 'P4SMAJ51A-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.023616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818207 [ RunTime:0.007539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196791 LIMIT 5 [ RunTime:0.013897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196791 ORDER BY `minOrder` ASC [ RunTime:0.003301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196791 ORDER BY `unit` DESC [ RunTime:0.001337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196791 LIMIT 2 [ RunTime:0.003286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196791 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='P4SMAJ51A-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51A-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000989s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196791 AND `partno` = 'P4SMAJ51A-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.005485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910550 [ RunTime:0.003224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196565 LIMIT 5 [ RunTime:0.008193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196565 ORDER BY `minOrder` ASC [ RunTime:0.013579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196565 ORDER BY `unit` DESC [ RunTime:0.005512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196565 LIMIT 2 [ RunTime:0.015537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196565 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
select * from pdf where partno='P4SMAJ51CA-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.012082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51CA-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002508s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196565 AND `partno` = 'P4SMAJ51CA-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.002539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666838 [ RunTime:0.003134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42189009 LIMIT 5 [ RunTime:0.015219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42189009 ORDER BY `minOrder` ASC [ RunTime:0.008610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42189009 ORDER BY `unit` DESC [ RunTime:0.010770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42189009 LIMIT 2 [ RunTime:0.005551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42189009 ORDER BY `minOrder` ASC [ RunTime:0.011995s ]
select * from pdf where partno='P4SMAJ51CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.011846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009582s ]
SELECT `id` FROM `stock` WHERE `id` <> 42189009 AND `partno` = 'P4SMAJ51CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.001871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909739 [ RunTime:0.007266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42188331 LIMIT 5 [ RunTime:0.001334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42188331 ORDER BY `minOrder` ASC [ RunTime:0.001181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42188331 ORDER BY `unit` DESC [ RunTime:0.002482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42188331 LIMIT 2 [ RunTime:0.009200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42188331 ORDER BY `minOrder` ASC [ RunTime:0.018388s ]
select * from pdf where partno='P4SMAJ51A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.009433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.031948s ]
SELECT `id` FROM `stock` WHERE `id` <> 42188331 AND `partno` = 'P4SMAJ51A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.035679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909677 [ RunTime:0.012573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42187615 LIMIT 5 [ RunTime:0.013081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187615 ORDER BY `minOrder` ASC [ RunTime:0.005550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42187615 ORDER BY `unit` DESC [ RunTime:0.007973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42187615 LIMIT 2 [ RunTime:0.012910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187615 ORDER BY `minOrder` ASC [ RunTime:0.009414s ]
select * from pdf where partno='P4SMAJ51C' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.002707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51C' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.021611s ]
SELECT `id` FROM `stock` WHERE `id` <> 42187615 AND `partno` = 'P4SMAJ51C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.030064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665944 [ RunTime:0.006093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42187452 LIMIT 5 [ RunTime:0.013104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187452 ORDER BY `minOrder` ASC [ RunTime:0.034988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42187452 ORDER BY `unit` DESC [ RunTime:0.044171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42187452 LIMIT 2 [ RunTime:0.033428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187452 ORDER BY `minOrder` ASC [ RunTime:0.012278s ]
select * from pdf where partno='P4SMAJ51' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.025730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMAJ51' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012405s ]
SELECT `id` FROM `stock` WHERE `id` <> 42187452 AND `partno` = 'P4SMAJ51' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.021110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665902 [ RunTime:0.023165s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036006s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022691s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014000s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038097s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040874s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026110s ]
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 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017347s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMAJ51%' OR `brand` LIKE 'P4SMAJ51%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.042386s ]