SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002233s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=P4KE160CA&search=1' [ RunTime:0.001904s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003400s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002132s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002083s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002236s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002176s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4KE160CA' LIMIT 1 [ RunTime:0.026875s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-15 21:32:52' WHERE `partno` = 'P4KE160CA' [ RunTime:0.009247s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003010s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022007s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676915 LIMIT 5 [ RunTime:0.011134s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676915 ORDER BY `minOrder` ASC [ RunTime:0.035499s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.027606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676915 ORDER BY `unit` DESC [ RunTime:0.033950s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676915 LIMIT 2 [ RunTime:0.011899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676915 ORDER BY `minOrder` ASC [ RunTime:0.028922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672881 LIMIT 5 [ RunTime:0.067186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672881 ORDER BY `minOrder` ASC [ RunTime:0.083500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672881 ORDER BY `unit` DESC [ RunTime:0.036036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672881 LIMIT 2 [ RunTime:0.038226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672881 ORDER BY `minOrder` ASC [ RunTime:0.018829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669711 LIMIT 5 [ RunTime:0.060329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669711 ORDER BY `minOrder` ASC [ RunTime:0.053555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669711 ORDER BY `unit` DESC [ RunTime:0.008079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669711 LIMIT 2 [ RunTime:0.069803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669711 ORDER BY `minOrder` ASC [ RunTime:0.048249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669694 LIMIT 5 [ RunTime:0.092435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669694 ORDER BY `minOrder` ASC [ RunTime:0.052203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669694 ORDER BY `unit` DESC [ RunTime:0.106704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669694 LIMIT 2 [ RunTime:0.057312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669694 ORDER BY `minOrder` ASC [ RunTime:0.030270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666303 LIMIT 5 [ RunTime:0.046997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666303 ORDER BY `minOrder` ASC [ RunTime:0.056883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666303 ORDER BY `unit` DESC [ RunTime:0.036419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666303 LIMIT 2 [ RunTime:0.040315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666303 ORDER BY `minOrder` ASC [ RunTime:0.013902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666035 LIMIT 5 [ RunTime:0.010303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666035 ORDER BY `minOrder` ASC [ RunTime:0.043838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666035 ORDER BY `unit` DESC [ RunTime:0.014885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666035 LIMIT 2 [ RunTime:0.042514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666035 ORDER BY `minOrder` ASC [ RunTime:0.017233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665826 LIMIT 5 [ RunTime:0.008140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665826 ORDER BY `minOrder` ASC [ RunTime:0.043500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665826 ORDER BY `unit` DESC [ RunTime:0.032908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665826 LIMIT 2 [ RunTime:0.003029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665826 ORDER BY `minOrder` ASC [ RunTime:0.008652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665713 LIMIT 5 [ RunTime:0.042903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665713 ORDER BY `minOrder` ASC [ RunTime:0.010656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665713 ORDER BY `unit` DESC [ RunTime:0.032904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665713 LIMIT 2 [ RunTime:0.025795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665713 ORDER BY `minOrder` ASC [ RunTime:0.017946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816608 LIMIT 5 [ RunTime:0.066877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816608 ORDER BY `minOrder` ASC [ RunTime:0.032412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816608 ORDER BY `unit` DESC [ RunTime:0.089592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816608 LIMIT 2 [ RunTime:0.027314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816608 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814584 LIMIT 5 [ RunTime:0.033907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814584 ORDER BY `minOrder` ASC [ RunTime:0.042017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814584 ORDER BY `unit` DESC [ RunTime:0.039123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814584 LIMIT 2 [ RunTime:0.012636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814584 ORDER BY `minOrder` ASC [ RunTime:0.028906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812210 LIMIT 5 [ RunTime:0.023298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812210 ORDER BY `minOrder` ASC [ RunTime:0.071814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812210 ORDER BY `unit` DESC [ RunTime:0.031050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812210 LIMIT 2 [ RunTime:0.041818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812210 ORDER BY `minOrder` ASC [ RunTime:0.010185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808160 LIMIT 5 [ RunTime:0.070930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808160 ORDER BY `minOrder` ASC [ RunTime:0.058466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808160 ORDER BY `unit` DESC [ RunTime:0.030649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808160 LIMIT 2 [ RunTime:0.024423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808160 ORDER BY `minOrder` ASC [ RunTime:0.051639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806916 LIMIT 5 [ RunTime:0.066949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806916 ORDER BY `minOrder` ASC [ RunTime:0.043324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806916 ORDER BY `unit` DESC [ RunTime:0.004026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806916 LIMIT 2 [ RunTime:0.051626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806916 ORDER BY `minOrder` ASC [ RunTime:0.037707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805883 LIMIT 5 [ RunTime:0.039796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805883 ORDER BY `minOrder` ASC [ RunTime:0.008217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805883 ORDER BY `unit` DESC [ RunTime:0.011176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805883 LIMIT 2 [ RunTime:0.044431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805883 ORDER BY `minOrder` ASC [ RunTime:0.013028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805876 LIMIT 5 [ RunTime:0.039110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805876 ORDER BY `minOrder` ASC [ RunTime:0.027166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805876 ORDER BY `unit` DESC [ RunTime:0.023496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805876 LIMIT 2 [ RunTime:0.055498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805876 ORDER BY `minOrder` ASC [ RunTime:0.010609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915837 LIMIT 5 [ RunTime:0.085942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915837 ORDER BY `minOrder` ASC [ RunTime:0.028874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915837 ORDER BY `unit` DESC [ RunTime:0.028470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915837 LIMIT 2 [ RunTime:0.044484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915837 ORDER BY `minOrder` ASC [ RunTime:0.021915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910690 LIMIT 5 [ RunTime:0.038208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910690 ORDER BY `minOrder` ASC [ RunTime:0.006864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910690 ORDER BY `unit` DESC [ RunTime:0.027507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910690 LIMIT 2 [ RunTime:0.053610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910690 ORDER BY `minOrder` ASC [ RunTime:0.033240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910689 LIMIT 5 [ RunTime:0.008872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910689 ORDER BY `minOrder` ASC [ RunTime:0.005820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910689 ORDER BY `unit` DESC [ RunTime:0.018434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910689 LIMIT 2 [ RunTime:0.035810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910689 ORDER BY `minOrder` ASC [ RunTime:0.015178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909926 LIMIT 5 [ RunTime:0.025655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909926 ORDER BY `minOrder` ASC [ RunTime:0.014810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909926 ORDER BY `unit` DESC [ RunTime:0.006619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909926 LIMIT 2 [ RunTime:0.008514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909926 ORDER BY `minOrder` ASC [ RunTime:0.010900s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010867s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42275985 LIMIT 5 [ RunTime:0.016091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275985 ORDER BY `minOrder` ASC [ RunTime:0.012116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42275985 ORDER BY `unit` DESC [ RunTime:0.012186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42275985 LIMIT 2 [ RunTime:0.035763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275985 ORDER BY `minOrder` ASC [ RunTime:0.017601s ]
select * from pdf where partno='P4KE160CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018402s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.022823s ]
SELECT `id` FROM `stock` WHERE `id` <> 42275985 AND `partno` = 'P4KE160CAHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.022039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672881 [ RunTime:0.025104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42275649 LIMIT 5 [ RunTime:0.009798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275649 ORDER BY `minOrder` ASC [ RunTime:0.018723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42275649 ORDER BY `unit` DESC [ RunTime:0.016394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42275649 LIMIT 2 [ RunTime:0.021585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275649 ORDER BY `minOrder` ASC [ RunTime:0.028328s ]
select * from pdf where partno='P4KE160CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016024s ]
SELECT `id` FROM `stock` WHERE `id` <> 42275649 AND `partno` = 'P4KE160CAHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.021444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271422 LIMIT 5 [ RunTime:0.033951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271422 ORDER BY `minOrder` ASC [ RunTime:0.026188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271422 ORDER BY `unit` DESC [ RunTime:0.003208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271422 LIMIT 2 [ RunTime:0.018031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271422 ORDER BY `minOrder` ASC [ RunTime:0.036555s ]
select * from pdf where partno='P4KE160CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.033561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.020681s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271422 AND `partno` = 'P4KE160CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.034457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263589 LIMIT 5 [ RunTime:0.020052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263589 ORDER BY `minOrder` ASC [ RunTime:0.020330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263589 ORDER BY `unit` DESC [ RunTime:0.001859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263589 LIMIT 2 [ RunTime:0.009406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263589 ORDER BY `minOrder` ASC [ RunTime:0.024919s ]
select * from pdf where partno='P4KE160CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.015481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.014352s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263589 AND `partno` = 'P4KE160CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814584 [ RunTime:0.006890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259577 LIMIT 5 [ RunTime:0.011817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259577 ORDER BY `minOrder` ASC [ RunTime:0.012748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259577 ORDER BY `unit` DESC [ RunTime:0.008435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259577 LIMIT 2 [ RunTime:0.018158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259577 ORDER BY `minOrder` ASC [ RunTime:0.007413s ]
select * from pdf where partno='P4KE160CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.034511s ]
SELECT `id` FROM `stock` WHERE `id` <> 42259577 AND `partno` = 'P4KE160CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.040715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812210 [ RunTime:0.017186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245557 LIMIT 5 [ RunTime:0.041458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245557 ORDER BY `minOrder` ASC [ RunTime:0.037727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245557 ORDER BY `unit` DESC [ RunTime:0.024246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245557 LIMIT 2 [ RunTime:0.005711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245557 ORDER BY `minOrder` ASC [ RunTime:0.017699s ]
select * from pdf where partno='P4KE160CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.045827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.038765s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245557 AND `partno` = 'P4KE160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.102973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915837 [ RunTime:0.053485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215223 LIMIT 5 [ RunTime:0.043070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215223 ORDER BY `minOrder` ASC [ RunTime:0.039908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215223 ORDER BY `unit` DESC [ RunTime:0.077019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215223 LIMIT 2 [ RunTime:0.099015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215223 ORDER BY `minOrder` ASC [ RunTime:0.032860s ]
select * from pdf where partno='P4KE160CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.023153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.026271s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215223 AND `partno` = 'P4KE160CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.128469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669694 [ RunTime:0.086305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215035 LIMIT 5 [ RunTime:0.041402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215035 ORDER BY `minOrder` ASC [ RunTime:0.050588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215035 ORDER BY `unit` DESC [ RunTime:0.051388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215035 LIMIT 2 [ RunTime:0.021804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215035 ORDER BY `minOrder` ASC [ RunTime:0.020965s ]
select * from pdf where partno='P4KE160CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.050835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.027109s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215035 AND `partno` = 'P4KE160CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.023630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669711 [ RunTime:0.032507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42207071 LIMIT 5 [ RunTime:0.060329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207071 ORDER BY `minOrder` ASC [ RunTime:0.026032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42207071 ORDER BY `unit` DESC [ RunTime:0.035769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42207071 LIMIT 2 [ RunTime:0.025828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207071 ORDER BY `minOrder` ASC [ RunTime:0.022129s ]
select * from pdf where partno='P4KE160CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.028281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.064688s ]
SELECT `id` FROM `stock` WHERE `id` <> 42207071 AND `partno` = 'P4KE160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.015676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808160 [ RunTime:0.071942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202592 LIMIT 5 [ RunTime:0.046644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202592 ORDER BY `minOrder` ASC [ RunTime:0.044292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202592 ORDER BY `unit` DESC [ RunTime:0.025201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202592 LIMIT 2 [ RunTime:0.048373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202592 ORDER BY `minOrder` ASC [ RunTime:0.046114s ]
select * from pdf where partno='P4KE160CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.036801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.062076s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202592 AND `partno` = 'P4KE160CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.080820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806916 [ RunTime:0.065318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42198723 LIMIT 5 [ RunTime:0.140933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198723 ORDER BY `minOrder` ASC [ RunTime:0.071668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42198723 ORDER BY `unit` DESC [ RunTime:0.069659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42198723 LIMIT 2 [ RunTime:0.063283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198723 ORDER BY `minOrder` ASC [ RunTime:0.032190s ]
select * from pdf where partno='P4KE160CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.091664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.067987s ]
SELECT `id` FROM `stock` WHERE `id` <> 42198723 AND `partno` = 'P4KE160CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.074848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910690 [ RunTime:0.033142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42198722 LIMIT 5 [ RunTime:0.034070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198722 ORDER BY `minOrder` ASC [ RunTime:0.033307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42198722 ORDER BY `unit` DESC [ RunTime:0.011612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42198722 LIMIT 2 [ RunTime:0.031140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198722 ORDER BY `minOrder` ASC [ RunTime:0.013281s ]
select * from pdf where partno='P4KE160CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.014872s ]
SELECT `id` FROM `stock` WHERE `id` <> 42198722 AND `partno` = 'P4KE160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.009558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910689 [ RunTime:0.011993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196310 LIMIT 5 [ RunTime:0.034476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196310 ORDER BY `minOrder` ASC [ RunTime:0.009177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196310 ORDER BY `unit` DESC [ RunTime:0.009684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196310 LIMIT 2 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196310 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
select * from pdf where partno='P4KE160CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.008364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008093s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196310 AND `partno` = 'P4KE160CA-AP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.008364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805883 [ RunTime:0.021473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196290 LIMIT 5 [ RunTime:0.036367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196290 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196290 ORDER BY `unit` DESC [ RunTime:0.011082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196290 LIMIT 2 [ RunTime:0.018627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196290 ORDER BY `minOrder` ASC [ RunTime:0.008690s ]
select * from pdf where partno='P4KE160CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.029724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.031614s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196290 AND `partno` = 'P4KE160CA-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.036866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805876 [ RunTime:0.026671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42195599 LIMIT 5 [ RunTime:0.022500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195599 ORDER BY `minOrder` ASC [ RunTime:0.024289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42195599 ORDER BY `unit` DESC [ RunTime:0.025231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42195599 LIMIT 2 [ RunTime:0.011401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195599 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
select * from pdf where partno='P4KE160CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.022149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.015382s ]
SELECT `id` FROM `stock` WHERE `id` <> 42195599 AND `partno` = 'P4KE160CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.023893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676915 [ RunTime:0.013230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191462 LIMIT 5 [ RunTime:0.012277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191462 ORDER BY `minOrder` ASC [ RunTime:0.022662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191462 ORDER BY `unit` DESC [ RunTime:0.009868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191462 LIMIT 2 [ RunTime:0.014165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191462 ORDER BY `minOrder` ASC [ RunTime:0.024387s ]
select * from pdf where partno='P4KE160CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.013431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.002999s ]
SELECT `id` FROM `stock` WHERE `id` <> 42191462 AND `partno` = 'P4KE160CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666303 [ RunTime:0.010174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42188994 LIMIT 5 [ RunTime:0.020752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42188994 ORDER BY `minOrder` ASC [ RunTime:0.045317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42188994 ORDER BY `unit` DESC [ RunTime:0.018820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42188994 LIMIT 2 [ RunTime:0.048386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42188994 ORDER BY `minOrder` ASC [ RunTime:0.009198s ]
select * from pdf where partno='P4KE160CAS_AY_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.013865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CAS_AY_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.027261s ]
SELECT `id` FROM `stock` WHERE `id` <> 42188994 AND `partno` = 'P4KE160CAS_AY_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.026162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816608 [ RunTime:0.005096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42186900 LIMIT 5 [ RunTime:0.028143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186900 ORDER BY `minOrder` ASC [ RunTime:0.045210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42186900 ORDER BY `unit` DESC [ RunTime:0.017241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42186900 LIMIT 2 [ RunTime:0.009220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186900 ORDER BY `minOrder` ASC [ RunTime:0.001276s ]
select * from pdf where partno='P4KE160CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.018707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.023764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42186578 LIMIT 5 [ RunTime:0.001732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186578 ORDER BY `minOrder` ASC [ RunTime:0.023664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42186578 ORDER BY `unit` DESC [ RunTime:0.005948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42186578 LIMIT 2 [ RunTime:0.014327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186578 ORDER BY `minOrder` ASC [ RunTime:0.006095s ]
select * from pdf where partno='P4KE160CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.000670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42184400 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42184400 ORDER BY `minOrder` ASC [ RunTime:0.002063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42184400 ORDER BY `unit` DESC [ RunTime:0.012624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42184400 LIMIT 2 [ RunTime:0.009496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42184400 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
select * from pdf where partno='P4KE160CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.002932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE160CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002872s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008844s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001190s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009916s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012274s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009686s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007598s ]
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 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017614s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4KE160CA%' OR `brand` LIKE 'P4KE160CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011398s ]