SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001819s ]
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=P4KE200CA&search=1' [ RunTime:0.008816s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001311s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008762s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001438s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002419s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001109s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005262s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001358s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4KE200CA' LIMIT 1 [ RunTime:0.004611s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-17 23:43:22' WHERE `partno` = 'P4KE200CA' [ RunTime:0.024046s ]
SHOW FULL COLUMNS FROM `stock` [ 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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025303s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908794 LIMIT 5 [ RunTime:0.019562s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908794 ORDER BY `minOrder` ASC [ RunTime:0.002344s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908794 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908794 LIMIT 2 [ RunTime:0.014404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908794 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676908 LIMIT 5 [ RunTime:0.022284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676908 ORDER BY `minOrder` ASC [ RunTime:0.024874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676908 ORDER BY `unit` DESC [ RunTime:0.048701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676908 LIMIT 2 [ RunTime:0.011620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676908 ORDER BY `minOrder` ASC [ RunTime:0.027322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674232 LIMIT 5 [ RunTime:0.038636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674232 ORDER BY `minOrder` ASC [ RunTime:0.048589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674232 ORDER BY `unit` DESC [ RunTime:0.015398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674232 LIMIT 2 [ RunTime:0.049861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674232 ORDER BY `minOrder` ASC [ RunTime:0.037002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668047 LIMIT 5 [ RunTime:0.039493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668047 ORDER BY `minOrder` ASC [ RunTime:0.070225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668047 ORDER BY `unit` DESC [ RunTime:0.015532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668047 LIMIT 2 [ RunTime:0.025104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668047 ORDER BY `minOrder` ASC [ RunTime:0.005559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667028 LIMIT 5 [ RunTime:0.036529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667028 ORDER BY `minOrder` ASC [ RunTime:0.007413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667028 ORDER BY `unit` DESC [ RunTime:0.020254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667028 LIMIT 2 [ RunTime:0.022936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667028 ORDER BY `minOrder` ASC [ RunTime:0.003768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667027 LIMIT 5 [ RunTime:0.012465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667027 ORDER BY `minOrder` ASC [ RunTime:0.009458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667027 ORDER BY `unit` DESC [ RunTime:0.002186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667027 LIMIT 2 [ RunTime:0.003110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667027 ORDER BY `minOrder` ASC [ RunTime:0.010409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666417 LIMIT 5 [ RunTime:0.034419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666417 ORDER BY `minOrder` ASC [ RunTime:0.018434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666417 ORDER BY `unit` DESC [ RunTime:0.015027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666417 LIMIT 2 [ RunTime:0.018898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666417 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665815 LIMIT 5 [ RunTime:0.025188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665815 ORDER BY `minOrder` ASC [ RunTime:0.023045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665815 ORDER BY `unit` DESC [ RunTime:0.009025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665815 LIMIT 2 [ RunTime:0.009084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665815 ORDER BY `minOrder` ASC [ RunTime:0.008045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665699 LIMIT 5 [ RunTime:0.005998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665699 ORDER BY `minOrder` ASC [ RunTime:0.005702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665699 ORDER BY `unit` DESC [ RunTime:0.013137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665699 LIMIT 2 [ RunTime:0.010310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665699 ORDER BY `minOrder` ASC [ RunTime:0.009169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816588 LIMIT 5 [ RunTime:0.004920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816588 ORDER BY `minOrder` ASC [ RunTime:0.002971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816588 ORDER BY `unit` DESC [ RunTime:0.019501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816588 LIMIT 2 [ RunTime:0.047274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816588 ORDER BY `minOrder` ASC [ RunTime:0.009032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813088 LIMIT 5 [ RunTime:0.002328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813088 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813088 ORDER BY `unit` DESC [ RunTime:0.002830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813088 LIMIT 2 [ RunTime:0.004871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813088 ORDER BY `minOrder` ASC [ RunTime:0.003187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809708 LIMIT 5 [ RunTime:0.010963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809708 ORDER BY `minOrder` ASC [ RunTime:0.010160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809708 ORDER BY `unit` DESC [ RunTime:0.010626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809708 LIMIT 2 [ RunTime:0.006893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809708 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806896 LIMIT 5 [ RunTime:0.004658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806896 ORDER BY `minOrder` ASC [ RunTime:0.006755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806896 ORDER BY `unit` DESC [ RunTime:0.010232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806896 LIMIT 2 [ RunTime:0.015337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806896 ORDER BY `minOrder` ASC [ RunTime:0.009816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805879 LIMIT 5 [ RunTime:0.008801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805879 ORDER BY `minOrder` ASC [ RunTime:0.008729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805879 ORDER BY `unit` DESC [ RunTime:0.000719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805879 LIMIT 2 [ RunTime:0.017061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805879 ORDER BY `minOrder` ASC [ RunTime:0.004352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805780 LIMIT 5 [ RunTime:0.030072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805780 ORDER BY `minOrder` ASC [ RunTime:0.020720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805780 ORDER BY `unit` DESC [ RunTime:0.040243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805780 LIMIT 2 [ RunTime:0.002117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805780 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805607 LIMIT 5 [ RunTime:0.005606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805607 ORDER BY `minOrder` ASC [ RunTime:0.017598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805607 ORDER BY `unit` DESC [ RunTime:0.020021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805607 LIMIT 2 [ RunTime:0.009210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805607 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915185 LIMIT 5 [ RunTime:0.016982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915185 ORDER BY `minOrder` ASC [ RunTime:0.052084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915185 ORDER BY `unit` DESC [ RunTime:0.025839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915185 LIMIT 2 [ RunTime:0.028095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915185 ORDER BY `minOrder` ASC [ RunTime:0.010721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913055 LIMIT 5 [ RunTime:0.012346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913055 ORDER BY `minOrder` ASC [ RunTime:0.029049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913055 ORDER BY `unit` DESC [ RunTime:0.010642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913055 LIMIT 2 [ RunTime:0.017021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913055 ORDER BY `minOrder` ASC [ RunTime:0.023639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909844 LIMIT 5 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909844 ORDER BY `minOrder` ASC [ RunTime:0.046009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909844 ORDER BY `unit` DESC [ RunTime:0.040132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909844 LIMIT 2 [ RunTime:0.047760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909844 ORDER BY `minOrder` ASC [ RunTime:0.011575s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017365s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42148997 LIMIT 5 [ RunTime:0.011836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148997 ORDER BY `minOrder` ASC [ RunTime:0.009297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42148997 ORDER BY `unit` DESC [ RunTime:0.004208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42148997 LIMIT 2 [ RunTime:0.007943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42148997 ORDER BY `minOrder` ASC [ RunTime:0.009371s ]
select * from pdf where partno='P4KE200CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.012958s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.012601s ]
SELECT `id` FROM `stock` WHERE `id` <> 42148997 AND `partno` = 'P4KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.007308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42275652 LIMIT 5 [ RunTime:0.012614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275652 ORDER BY `minOrder` ASC [ RunTime:0.021739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42275652 ORDER BY `unit` DESC [ RunTime:0.014004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42275652 LIMIT 2 [ RunTime:0.005905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275652 ORDER BY `minOrder` ASC [ RunTime:0.004781s ]
select * from pdf where partno='P4KE200CAHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CAHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003278s ]
SELECT `id` FROM `stock` WHERE `id` <> 42275652 AND `partno` = 'P4KE200CAHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271425 LIMIT 5 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271425 ORDER BY `minOrder` ASC [ RunTime:0.001264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271425 ORDER BY `unit` DESC [ RunTime:0.007666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271425 LIMIT 2 [ RunTime:0.007340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271425 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='P4KE200CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001110s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271425 AND `partno` = 'P4KE200CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42268276 LIMIT 5 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268276 ORDER BY `minOrder` ASC [ RunTime:0.004039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42268276 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42268276 LIMIT 2 [ RunTime:0.003594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42268276 ORDER BY `minOrder` ASC [ RunTime:0.002571s ]
select * from pdf where partno='P4KE200CAHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CAHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002048s ]
SELECT `id` FROM `stock` WHERE `id` <> 42268276 AND `partno` = 'P4KE200CAHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813088 [ RunTime:0.002751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263596 LIMIT 5 [ RunTime:0.002844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263596 ORDER BY `minOrder` ASC [ RunTime:0.002419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263596 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263596 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263596 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
select * from pdf where partno='P4KE200CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001886s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263596 AND `partno` = 'P4KE200CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674232 [ RunTime:0.002810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262942 LIMIT 5 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262942 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262942 ORDER BY `unit` DESC [ RunTime:0.008628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262942 LIMIT 2 [ RunTime:0.014290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262942 ORDER BY `minOrder` ASC [ RunTime:0.018260s ]
select * from pdf where partno='P4KE200CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007582s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262942 AND `partno` = 'P4KE200CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915185 [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215232 LIMIT 5 [ RunTime:0.005859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215232 ORDER BY `minOrder` ASC [ RunTime:0.011296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215232 ORDER BY `unit` DESC [ RunTime:0.023607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215232 LIMIT 2 [ RunTime:0.009370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215232 ORDER BY `minOrder` ASC [ RunTime:0.004595s ]
select * from pdf where partno='P4KE200CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.025376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.042580s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215232 AND `partno` = 'P4KE200CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.023582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809708 [ RunTime:0.020635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215069 LIMIT 5 [ RunTime:0.008637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215069 ORDER BY `minOrder` ASC [ RunTime:0.051348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215069 ORDER BY `unit` DESC [ RunTime:0.021145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215069 LIMIT 2 [ RunTime:0.007282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215069 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
select * from pdf where partno='P4KE200CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.004202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.008109s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215069 AND `partno` = 'P4KE200CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.011921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913055 [ RunTime:0.007878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42204466 LIMIT 5 [ RunTime:0.001077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204466 ORDER BY `minOrder` ASC [ RunTime:0.003792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42204466 ORDER BY `unit` DESC [ RunTime:0.009263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42204466 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42204466 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='P4KE200CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.002463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001631s ]
SELECT `id` FROM `stock` WHERE `id` <> 42204466 AND `partno` = 'P4KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.009896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668047 [ RunTime:0.006448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202618 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202618 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202618 ORDER BY `unit` DESC [ RunTime:0.010869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202618 LIMIT 2 [ RunTime:0.005153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202618 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='P4KE200CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002646s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202618 AND `partno` = 'P4KE200CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.001891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806896 [ RunTime:0.003915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42198733 LIMIT 5 [ RunTime:0.004356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198733 ORDER BY `minOrder` ASC [ RunTime:0.004452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42198733 ORDER BY `unit` DESC [ RunTime:0.005931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42198733 LIMIT 2 [ RunTime:0.002143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198733 ORDER BY `minOrder` ASC [ RunTime:0.005159s ]
select * from pdf where partno='P4KE200CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007998s ]
SELECT `id` FROM `stock` WHERE `id` <> 42198733 AND `partno` = 'P4KE200CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667028 [ RunTime:0.001747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42198732 LIMIT 5 [ RunTime:0.006012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198732 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42198732 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42198732 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42198732 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
select * from pdf where partno='P4KE200CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.014834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005425s ]
SELECT `id` FROM `stock` WHERE `id` <> 42198732 AND `partno` = 'P4KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.009286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667027 [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196337 LIMIT 5 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196337 ORDER BY `minOrder` ASC [ RunTime:0.001893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196337 ORDER BY `unit` DESC [ RunTime:0.000744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196337 LIMIT 2 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196337 ORDER BY `minOrder` ASC [ RunTime:0.003301s ]
select * from pdf where partno='P4KE200CA-AP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-AP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.004862s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196337 AND `partno` = 'P4KE200CA-AP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.004927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666417 [ RunTime:0.002411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196299 LIMIT 5 [ RunTime:0.001320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196299 ORDER BY `minOrder` ASC [ RunTime:0.028406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196299 ORDER BY `unit` DESC [ RunTime:0.018959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196299 LIMIT 2 [ RunTime:0.005813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196299 ORDER BY `minOrder` ASC [ RunTime:0.014342s ]
select * from pdf where partno='P4KE200CA-BP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.029061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-BP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.040278s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196299 AND `partno` = 'P4KE200CA-BP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.050150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805879 [ RunTime:0.112532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42195589 LIMIT 5 [ RunTime:0.069336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195589 ORDER BY `minOrder` ASC [ RunTime:0.163799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42195589 ORDER BY `unit` DESC [ RunTime:0.026365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42195589 LIMIT 2 [ RunTime:0.028605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195589 ORDER BY `minOrder` ASC [ RunTime:0.026637s ]
select * from pdf where partno='P4KE200CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.055842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.038624s ]
SELECT `id` FROM `stock` WHERE `id` <> 42195589 AND `partno` = 'P4KE200CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.031515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676908 [ RunTime:0.016726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191470 LIMIT 5 [ RunTime:0.011601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191470 ORDER BY `minOrder` ASC [ RunTime:0.007178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191470 ORDER BY `unit` DESC [ RunTime:0.004512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191470 LIMIT 2 [ RunTime:0.006334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191470 ORDER BY `minOrder` ASC [ RunTime:0.008140s ]
select * from pdf where partno='P4KE200CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.020643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.004439s ]
SELECT `id` FROM `stock` WHERE `id` <> 42191470 AND `partno` = 'P4KE200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805780 [ RunTime:0.001786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42188669 LIMIT 5 [ RunTime:0.019365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42188669 ORDER BY `minOrder` ASC [ RunTime:0.013030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42188669 ORDER BY `unit` DESC [ RunTime:0.004541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42188669 LIMIT 2 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42188669 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='P4KE200CAS_AY_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CAS_AY_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.004517s ]
SELECT `id` FROM `stock` WHERE `id` <> 42188669 AND `partno` = 'P4KE200CAS_AY_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816588 [ RunTime:0.004776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42186899 LIMIT 5 [ RunTime:0.009582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186899 ORDER BY `minOrder` ASC [ RunTime:0.010315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42186899 ORDER BY `unit` DESC [ RunTime:0.001646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42186899 LIMIT 2 [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186899 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='P4KE200CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42186601 LIMIT 5 [ RunTime:0.009963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186601 ORDER BY `minOrder` ASC [ RunTime:0.006230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42186601 ORDER BY `unit` DESC [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42186601 LIMIT 2 [ RunTime:0.001947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42186601 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='P4KE200CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42184052 LIMIT 5 [ RunTime:0.005428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42184052 ORDER BY `minOrder` ASC [ RunTime:0.007543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42184052 ORDER BY `unit` DESC [ RunTime:0.008631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42184052 LIMIT 2 [ RunTime:0.007738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42184052 ORDER BY `minOrder` ASC [ RunTime:0.006199s ]
select * from pdf where partno='P4KE200CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.002087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4KE200CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005843s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002649s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010098s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008598s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003940s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001982s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001691s ]
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 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008601s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4KE200CA%' OR `brand` LIKE 'P4KE200CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001571s ]