SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002269s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=SMCJ18A&search=1' [ RunTime:0.003857s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001817s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002072s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003387s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001967s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002120s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ18A' LIMIT 1 [ RunTime:0.008095s ]
UPDATE `stock_search` SET `count` = 13 , `updatetime` = '2026-08-20 21:02:15' WHERE `partno` = 'SMCJ18A' [ RunTime:0.025367s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001246s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039690s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663863 LIMIT 5 [ RunTime:0.044992s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663863 ORDER BY `minOrder` ASC [ RunTime:0.018594s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663863 ORDER BY `unit` DESC [ RunTime:0.027314s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663863 LIMIT 2 [ RunTime:0.026374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663863 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808331 LIMIT 5 [ RunTime:0.033531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808331 ORDER BY `minOrder` ASC [ RunTime:0.036564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808331 ORDER BY `unit` DESC [ RunTime:0.032536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808331 LIMIT 2 [ RunTime:0.032778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808331 ORDER BY `minOrder` ASC [ RunTime:0.011819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807445 LIMIT 5 [ RunTime:0.023303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807445 ORDER BY `minOrder` ASC [ RunTime:0.031210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807445 ORDER BY `unit` DESC [ RunTime:0.031721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807445 LIMIT 2 [ RunTime:0.015276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807445 ORDER BY `minOrder` ASC [ RunTime:0.033470s ]
select * from pdf where partno='SMCJ18A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.036380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669540 LIMIT 5 [ RunTime:0.037163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669540 ORDER BY `minOrder` ASC [ RunTime:0.044736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669540 ORDER BY `unit` DESC [ RunTime:0.033344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669540 LIMIT 2 [ RunTime:0.073304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669540 ORDER BY `minOrder` ASC [ RunTime:0.011966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927488 LIMIT 5 [ RunTime:0.036643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927488 ORDER BY `minOrder` ASC [ RunTime:0.012090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13927488 ORDER BY `unit` DESC [ RunTime:0.017378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13927488 LIMIT 2 [ RunTime:0.015173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927488 ORDER BY `minOrder` ASC [ RunTime:0.009803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905208 LIMIT 5 [ RunTime:0.035312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905208 ORDER BY `minOrder` ASC [ RunTime:0.026076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905208 ORDER BY `unit` DESC [ RunTime:0.008443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905208 LIMIT 2 [ RunTime:0.022646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905208 ORDER BY `minOrder` ASC [ RunTime:0.012623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828645 LIMIT 5 [ RunTime:0.044831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828645 ORDER BY `minOrder` ASC [ RunTime:0.017609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828645 ORDER BY `unit` DESC [ RunTime:0.010984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828645 LIMIT 2 [ RunTime:0.015624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828645 ORDER BY `minOrder` ASC [ RunTime:0.006615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668805 LIMIT 5 [ RunTime:0.011291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668805 ORDER BY `minOrder` ASC [ RunTime:0.024063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668805 ORDER BY `unit` DESC [ RunTime:0.030280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668805 LIMIT 2 [ RunTime:0.021558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668805 ORDER BY `minOrder` ASC [ RunTime:0.013113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800083 LIMIT 5 [ RunTime:0.037928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800083 ORDER BY `minOrder` ASC [ RunTime:0.023199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800083 ORDER BY `unit` DESC [ RunTime:0.017622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800083 LIMIT 2 [ RunTime:0.015572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800083 ORDER BY `minOrder` ASC [ RunTime:0.012822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833651 LIMIT 5 [ RunTime:0.007180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833651 ORDER BY `minOrder` ASC [ RunTime:0.021524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833651 ORDER BY `unit` DESC [ RunTime:0.001992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833651 LIMIT 2 [ RunTime:0.011597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833651 ORDER BY `minOrder` ASC [ RunTime:0.019071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918620 LIMIT 5 [ RunTime:0.002168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918620 ORDER BY `minOrder` ASC [ RunTime:0.006504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918620 ORDER BY `unit` DESC [ RunTime:0.004962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918620 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918620 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662540 LIMIT 5 [ RunTime:0.006735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662540 ORDER BY `minOrder` ASC [ RunTime:0.011771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662540 ORDER BY `unit` DESC [ RunTime:0.009734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662540 LIMIT 2 [ RunTime:0.009802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662540 ORDER BY `minOrder` ASC [ RunTime:0.003743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803375 LIMIT 5 [ RunTime:0.007508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803375 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803375 ORDER BY `unit` DESC [ RunTime:0.007696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803375 LIMIT 2 [ RunTime:0.022800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803375 ORDER BY `minOrder` ASC [ RunTime:0.007765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906858 LIMIT 5 [ RunTime:0.016655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906858 ORDER BY `minOrder` ASC [ RunTime:0.002582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906858 ORDER BY `unit` DESC [ RunTime:0.018203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906858 LIMIT 2 [ RunTime:0.002303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906858 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818784 LIMIT 5 [ RunTime:0.003368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818784 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818784 ORDER BY `unit` DESC [ RunTime:0.003517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818784 LIMIT 2 [ RunTime:0.008292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818784 ORDER BY `minOrder` ASC [ RunTime:0.001699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691232 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691232 ORDER BY `minOrder` ASC [ RunTime:0.011999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691232 ORDER BY `unit` DESC [ RunTime:0.018921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691232 LIMIT 2 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691232 ORDER BY `minOrder` ASC [ RunTime:0.002916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689667 LIMIT 5 [ RunTime:0.011458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689667 ORDER BY `minOrder` ASC [ RunTime:0.006504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689667 ORDER BY `unit` DESC [ RunTime:0.005614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689667 LIMIT 2 [ RunTime:0.003101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689667 ORDER BY `minOrder` ASC [ RunTime:0.001472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675219 LIMIT 5 [ RunTime:0.004883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675219 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675219 ORDER BY `unit` DESC [ RunTime:0.005555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675219 LIMIT 2 [ RunTime:0.003108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675219 ORDER BY `minOrder` ASC [ RunTime:0.010015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675014 LIMIT 5 [ RunTime:0.008811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675014 ORDER BY `minOrder` ASC [ RunTime:0.005902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675014 ORDER BY `unit` DESC [ RunTime:0.007757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675014 LIMIT 2 [ RunTime:0.007539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675014 ORDER BY `minOrder` ASC [ RunTime:0.003912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673773 LIMIT 5 [ RunTime:0.008324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673773 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673773 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673773 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673773 ORDER BY `minOrder` ASC [ RunTime:0.003705s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140576 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140576 ORDER BY `minOrder` ASC [ RunTime:0.009652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140576 ORDER BY `unit` DESC [ RunTime:0.001093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140576 LIMIT 2 [ RunTime:0.006041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140576 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
select * from pdf where partno='smcj18ahm3_a/h' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.001654s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj18ahm3_a/h' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.004617s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140576 AND `partno` = 'smcj18ahm3_a/h' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.015521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025370 [ RunTime:0.015743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025370 LIMIT 5 [ RunTime:0.003382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025370 ORDER BY `minOrder` ASC [ RunTime:0.007453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51025370 ORDER BY `unit` DESC [ RunTime:0.006784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51025370 LIMIT 2 [ RunTime:0.003547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025370 ORDER BY `minOrder` ASC [ RunTime:0.004917s ]
select * from pdf where partno='smcj18ahm3_a/h' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.000717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj18ahm3_a/h' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.000787s ]
SELECT `id` FROM `stock` WHERE `id` <> 51025370 AND `partno` = 'smcj18ahm3_a/h' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.003815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140576 [ RunTime:0.003770s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42163917 LIMIT 5 [ RunTime:0.008383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42163917 ORDER BY `minOrder` ASC [ RunTime:0.005607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42163917 ORDER BY `unit` DESC [ RunTime:0.001254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42163917 LIMIT 2 [ RunTime:0.002293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42163917 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='SMCJ18A' and brandshort='MDD' limit 1 [ RunTime:0.001450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.012706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106160 LIMIT 5 [ RunTime:0.002535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106160 ORDER BY `minOrder` ASC [ RunTime:0.006974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106160 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106160 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106160 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='SMCJ18A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.013943s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106160 AND `partno` = 'SMCJ18A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.010477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669540 [ RunTime:0.008476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42096048 LIMIT 5 [ RunTime:0.006683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096048 ORDER BY `minOrder` ASC [ RunTime:0.011420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42096048 ORDER BY `unit` DESC [ RunTime:0.007770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42096048 LIMIT 2 [ RunTime:0.007364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096048 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
select * from pdf where partno='SMCJ18A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.009676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42096028 LIMIT 5 [ RunTime:0.003155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096028 ORDER BY `minOrder` ASC [ RunTime:0.004968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42096028 ORDER BY `unit` DESC [ RunTime:0.000973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42096028 LIMIT 2 [ RunTime:0.005345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096028 ORDER BY `minOrder` ASC [ RunTime:0.006644s ]
select * from pdf where partno='SMCJ18A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.011232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118784 LIMIT 5 [ RunTime:0.012223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118784 ORDER BY `minOrder` ASC [ RunTime:0.014867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118784 ORDER BY `unit` DESC [ RunTime:0.003119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118784 LIMIT 2 [ RunTime:0.005690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118784 ORDER BY `minOrder` ASC [ RunTime:0.006059s ]
select * from pdf where partno='SMCJ18A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.017336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.011995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42133518 LIMIT 5 [ RunTime:0.029265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133518 ORDER BY `minOrder` ASC [ RunTime:0.013778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42133518 ORDER BY `unit` DESC [ RunTime:0.031443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42133518 LIMIT 2 [ RunTime:0.031628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133518 ORDER BY `minOrder` ASC [ RunTime:0.012915s ]
select * from pdf where partno='SMCJ18AQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.007339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18AQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003855s ]
SELECT `id` FROM `stock` WHERE `id` <> 42133518 AND `partno` = 'SMCJ18AQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.008632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905208 [ RunTime:0.039778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117874 LIMIT 5 [ RunTime:0.023795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117874 ORDER BY `minOrder` ASC [ RunTime:0.020455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117874 ORDER BY `unit` DESC [ RunTime:0.004159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117874 LIMIT 2 [ RunTime:0.028236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117874 ORDER BY `minOrder` ASC [ RunTime:0.012376s ]
select * from pdf where partno='SMCJ18A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.022749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.028463s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117874 AND `partno` = 'SMCJ18A-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927488 [ RunTime:0.010528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117879 LIMIT 5 [ RunTime:0.022272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117879 ORDER BY `minOrder` ASC [ RunTime:0.043000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117879 ORDER BY `unit` DESC [ RunTime:0.007947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117879 LIMIT 2 [ RunTime:0.012323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117879 ORDER BY `minOrder` ASC [ RunTime:0.019297s ]
select * from pdf where partno='SMCJ18A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.029762s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117879 AND `partno` = 'SMCJ18A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.034386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668805 [ RunTime:0.026494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142540 LIMIT 5 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142540 ORDER BY `minOrder` ASC [ RunTime:0.015849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142540 ORDER BY `unit` DESC [ RunTime:0.003723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142540 LIMIT 2 [ RunTime:0.006563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142540 ORDER BY `minOrder` ASC [ RunTime:0.022280s ]
select * from pdf where partno='SMCJ18A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.021024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.017740s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142540 AND `partno` = 'SMCJ18A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.023786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804614 [ RunTime:0.005087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42154849 LIMIT 5 [ RunTime:0.015056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154849 ORDER BY `minOrder` ASC [ RunTime:0.015912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42154849 ORDER BY `unit` DESC [ RunTime:0.005409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42154849 LIMIT 2 [ RunTime:0.009954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154849 ORDER BY `minOrder` ASC [ RunTime:0.005123s ]
select * from pdf where partno='SMCJ18A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.003790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.005012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117909 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117909 ORDER BY `minOrder` ASC [ RunTime:0.019417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117909 ORDER BY `unit` DESC [ RunTime:0.009802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117909 LIMIT 2 [ RunTime:0.005681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117909 ORDER BY `minOrder` ASC [ RunTime:0.003774s ]
select * from pdf where partno='SMCJ18A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42164004 LIMIT 5 [ RunTime:0.017544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164004 ORDER BY `minOrder` ASC [ RunTime:0.007795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42164004 ORDER BY `unit` DESC [ RunTime:0.010263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42164004 LIMIT 2 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164004 ORDER BY `minOrder` ASC [ RunTime:0.010861s ]
select * from pdf where partno='SMCJ18A' and brandshort='VIITOR SEMICONDUCTOR CO., LTD' limit 1 [ RunTime:0.015455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A' OR `brand` LIKE 'VIITOR SEMICONDUCTOR CO., LTD%' ) ) LIMIT 1 [ RunTime:0.008925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169468 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169468 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169468 ORDER BY `unit` DESC [ RunTime:0.011080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169468 LIMIT 2 [ RunTime:0.006104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169468 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='SMCJ18A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.007679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42415204 LIMIT 5 [ RunTime:0.014036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415204 ORDER BY `minOrder` ASC [ RunTime:0.015806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42415204 ORDER BY `unit` DESC [ RunTime:0.005669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42415204 LIMIT 2 [ RunTime:0.006005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42415204 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='SMCJ18A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001101s ]
SELECT `id` FROM `stock` WHERE `id` <> 42415204 AND `partno` = 'SMCJ18A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823972 [ RunTime:0.004004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412448 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412448 ORDER BY `minOrder` ASC [ RunTime:0.005649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412448 ORDER BY `unit` DESC [ RunTime:0.016973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412448 LIMIT 2 [ RunTime:0.022717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412448 ORDER BY `minOrder` ASC [ RunTime:0.002830s ]
select * from pdf where partno='SMCJ18A-HRAT7' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-HRAT7' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005957s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412448 AND `partno` = 'SMCJ18A-HRAT7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.007955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924863 [ RunTime:0.004363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42412447 LIMIT 5 [ RunTime:0.005728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412447 ORDER BY `minOrder` ASC [ RunTime:0.004957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42412447 ORDER BY `unit` DESC [ RunTime:0.012501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42412447 LIMIT 2 [ RunTime:0.005059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42412447 ORDER BY `minOrder` ASC [ RunTime:0.008991s ]
select * from pdf where partno='SMCJ18A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008295s ]
SELECT `id` FROM `stock` WHERE `id` <> 42412447 AND `partno` = 'SMCJ18A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.010234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924862 [ RunTime:0.004260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42294135 LIMIT 5 [ RunTime:0.006157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294135 ORDER BY `minOrder` ASC [ RunTime:0.004424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42294135 ORDER BY `unit` DESC [ RunTime:0.006704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42294135 LIMIT 2 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294135 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='SMCJ18A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.024338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.004426s ]
SELECT `id` FROM `stock` WHERE `id` <> 42294135 AND `partno` = 'SMCJ18A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.010923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818784 [ RunTime:0.012326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42289225 LIMIT 5 [ RunTime:0.024871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289225 ORDER BY `minOrder` ASC [ RunTime:0.005827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42289225 ORDER BY `unit` DESC [ RunTime:0.001098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42289225 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289225 ORDER BY `minOrder` ASC [ RunTime:0.002705s ]
select * from pdf where partno='SMCJ18AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.002883s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.009624s ]
SELECT `id` FROM `stock` WHERE `id` <> 42289225 AND `partno` = 'SMCJ18AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.006564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817965 [ RunTime:0.011131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284085 LIMIT 5 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284085 ORDER BY `minOrder` ASC [ RunTime:0.001110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284085 ORDER BY `unit` DESC [ RunTime:0.011635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284085 LIMIT 2 [ RunTime:0.001888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284085 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='SMCJ18A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002253s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284085 AND `partno` = 'SMCJ18A-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922121 [ RunTime:0.001064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270091 LIMIT 5 [ RunTime:0.005869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270091 ORDER BY `minOrder` ASC [ RunTime:0.008846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270091 ORDER BY `unit` DESC [ RunTime:0.001768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270091 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270091 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='SMCJ18AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ18AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.018807s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270091 AND `partno` = 'SMCJ18AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.003982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917633 [ RunTime:0.011650s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026180s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020388s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026989s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031584s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000953s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008120s ]
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 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003138s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ18A%' OR `brand` LIKE 'SMCJ18A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011381s ]