SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002488s ]
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=SMBJ33A&search=1' [ RunTime:0.002040s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003227s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000638s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002796s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.017088s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002709s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001084s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002598s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ33A' LIMIT 1 [ RunTime:0.006105s ]
UPDATE `stock_search` SET `count` = 25590 , `updatetime` = '2026-08-16 15:42:38' WHERE `partno` = 'SMBJ33A' [ RunTime:0.019562s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002970s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009047s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801726 LIMIT 5 [ RunTime:0.004879s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801726 ORDER BY `minOrder` ASC [ RunTime:0.008752s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801726 ORDER BY `unit` DESC [ RunTime:0.009876s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801726 LIMIT 2 [ RunTime:0.004561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801726 ORDER BY `minOrder` ASC [ RunTime:0.019980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905347 LIMIT 5 [ RunTime:0.007640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905347 ORDER BY `minOrder` ASC [ RunTime:0.005711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905347 ORDER BY `unit` DESC [ RunTime:0.004014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905347 LIMIT 2 [ RunTime:0.011963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905347 ORDER BY `minOrder` ASC [ RunTime:0.013454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915617 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915617 ORDER BY `minOrder` ASC [ RunTime:0.010906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915617 ORDER BY `unit` DESC [ RunTime:0.009123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915617 LIMIT 2 [ RunTime:0.013563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915617 ORDER BY `minOrder` ASC [ RunTime:0.037351s ]
select * from pdf where partno='SMBJ33AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.014674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803005 LIMIT 5 [ RunTime:0.008783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803005 ORDER BY `minOrder` ASC [ RunTime:0.008595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803005 ORDER BY `unit` DESC [ RunTime:0.014060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803005 LIMIT 2 [ RunTime:0.016296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803005 ORDER BY `minOrder` ASC [ RunTime:0.004849s ]
select * from pdf where partno='SMBJ33A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804490 LIMIT 5 [ RunTime:0.005089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804490 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804490 ORDER BY `unit` DESC [ RunTime:0.004593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804490 LIMIT 2 [ RunTime:0.003479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804490 ORDER BY `minOrder` ASC [ RunTime:0.017978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690029 LIMIT 5 [ RunTime:0.009748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690029 ORDER BY `minOrder` ASC [ RunTime:0.009238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690029 ORDER BY `unit` DESC [ RunTime:0.020776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690029 LIMIT 2 [ RunTime:0.005715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690029 ORDER BY `minOrder` ASC [ RunTime:0.014980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675505 LIMIT 5 [ RunTime:0.001114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675505 ORDER BY `minOrder` ASC [ RunTime:0.003087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675505 ORDER BY `unit` DESC [ RunTime:0.011525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675505 LIMIT 2 [ RunTime:0.002860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675505 ORDER BY `minOrder` ASC [ RunTime:0.008539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803032 LIMIT 5 [ RunTime:0.006165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803032 ORDER BY `minOrder` ASC [ RunTime:0.024359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803032 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803032 LIMIT 2 [ RunTime:0.011485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803032 ORDER BY `minOrder` ASC [ RunTime:0.015403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909393 LIMIT 5 [ RunTime:0.003336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909393 ORDER BY `minOrder` ASC [ RunTime:0.006318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909393 ORDER BY `unit` DESC [ RunTime:0.020127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909393 LIMIT 2 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909393 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910336 LIMIT 5 [ RunTime:0.001288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910336 ORDER BY `minOrder` ASC [ RunTime:0.006669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910336 ORDER BY `unit` DESC [ RunTime:0.003235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910336 LIMIT 2 [ RunTime:0.017636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910336 ORDER BY `minOrder` ASC [ RunTime:0.006993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905561 LIMIT 5 [ RunTime:0.037471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905561 ORDER BY `minOrder` ASC [ RunTime:0.002543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905561 ORDER BY `unit` DESC [ RunTime:0.014627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905561 LIMIT 2 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905561 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905787 LIMIT 5 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905787 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905787 ORDER BY `unit` DESC [ RunTime:0.002513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905787 LIMIT 2 [ RunTime:0.015744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905787 ORDER BY `minOrder` ASC [ RunTime:0.015738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829431 LIMIT 5 [ RunTime:0.012736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829431 ORDER BY `minOrder` ASC [ RunTime:0.010150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829431 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829431 LIMIT 2 [ RunTime:0.004145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829431 ORDER BY `minOrder` ASC [ RunTime:0.002464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915933 LIMIT 5 [ RunTime:0.036222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915933 ORDER BY `minOrder` ASC [ RunTime:0.006626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915933 ORDER BY `unit` DESC [ RunTime:0.005578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915933 LIMIT 2 [ RunTime:0.023570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915933 ORDER BY `minOrder` ASC [ RunTime:0.008775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672909 LIMIT 5 [ RunTime:0.007056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672909 ORDER BY `minOrder` ASC [ RunTime:0.001929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672909 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672909 LIMIT 2 [ RunTime:0.003399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672909 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906070 LIMIT 5 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906070 ORDER BY `minOrder` ASC [ RunTime:0.004196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906070 ORDER BY `unit` DESC [ RunTime:0.001140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906070 LIMIT 2 [ RunTime:0.000883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906070 ORDER BY `minOrder` ASC [ RunTime:0.006336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662535 LIMIT 5 [ RunTime:0.005693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662535 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662535 ORDER BY `unit` DESC [ RunTime:0.011551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662535 LIMIT 2 [ RunTime:0.001638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662535 ORDER BY `minOrder` ASC [ RunTime:0.007644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905743 LIMIT 5 [ RunTime:0.019034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905743 ORDER BY `minOrder` ASC [ RunTime:0.003994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905743 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905743 LIMIT 2 [ RunTime:0.004457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905743 ORDER BY `minOrder` ASC [ RunTime:0.002365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799868 LIMIT 5 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799868 ORDER BY `minOrder` ASC [ RunTime:0.008090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799868 ORDER BY `unit` DESC [ RunTime:0.012014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799868 LIMIT 2 [ RunTime:0.009781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799868 ORDER BY `minOrder` ASC [ RunTime:0.007637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800792 LIMIT 5 [ RunTime:0.010316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800792 ORDER BY `minOrder` ASC [ RunTime:0.002340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800792 ORDER BY `unit` DESC [ RunTime:0.008893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800792 LIMIT 2 [ RunTime:0.007003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800792 ORDER BY `minOrder` ASC [ RunTime:0.007950s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141087 LIMIT 5 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141087 ORDER BY `minOrder` ASC [ RunTime:0.004734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141087 ORDER BY `unit` DESC [ RunTime:0.017721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141087 LIMIT 2 [ RunTime:0.005272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141087 ORDER BY `minOrder` ASC [ RunTime:0.004718s ]
select * from pdf where partno='smbj33ahe3_a/h' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.001756s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj33ahe3_a/h' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.003685s ]
SELECT `id` FROM `stock` WHERE `id` <> 51141087 AND `partno` = 'smbj33ahe3_a/h' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.003010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140874 LIMIT 5 [ RunTime:0.007630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140874 ORDER BY `minOrder` ASC [ RunTime:0.002664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140874 ORDER BY `unit` DESC [ RunTime:0.005725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140874 LIMIT 2 [ RunTime:0.011115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140874 ORDER BY `minOrder` ASC [ RunTime:0.002769s ]
select * from pdf where partno='smbj33ahe3_b/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.006194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbj33ahe3_b/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.016793s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140874 AND `partno` = 'smbj33ahe3_b/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.003034s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160198 LIMIT 5 [ RunTime:0.004657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160198 ORDER BY `minOrder` ASC [ RunTime:0.004511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160198 ORDER BY `unit` DESC [ RunTime:0.004161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160198 LIMIT 2 [ RunTime:0.008629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160198 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
select * from pdf where partno='SMBJ33AL00S0MM' and brandshort='NextGen Components' limit 1 [ RunTime:0.021601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33AL00S0MM' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.002419s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160198 AND `partno` = 'SMBJ33AL00S0MM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.003004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801726 [ RunTime:0.004201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101095 LIMIT 5 [ RunTime:0.011060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101095 ORDER BY `minOrder` ASC [ RunTime:0.005485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101095 ORDER BY `unit` DESC [ RunTime:0.002926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101095 LIMIT 2 [ RunTime:0.002345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101095 ORDER BY `minOrder` ASC [ RunTime:0.003103s ]
select * from pdf where partno='SMBJ33A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000315s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101095 AND `partno` = 'SMBJ33A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905347 [ RunTime:0.002673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42103363 LIMIT 5 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103363 ORDER BY `minOrder` ASC [ RunTime:0.005057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42103363 ORDER BY `unit` DESC [ RunTime:0.005302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42103363 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103363 ORDER BY `minOrder` ASC [ RunTime:0.010616s ]
select * from pdf where partno='SMBJ33AQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.010478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33AQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.007887s ]
SELECT `id` FROM `stock` WHERE `id` <> 42103363 AND `partno` = 'SMBJ33AQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.004609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915617 [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42100223 LIMIT 5 [ RunTime:0.006320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100223 ORDER BY `minOrder` ASC [ RunTime:0.002389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42100223 ORDER BY `unit` DESC [ RunTime:0.012250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42100223 LIMIT 2 [ RunTime:0.011442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100223 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
select * from pdf where partno='SMBJ33A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42095188 LIMIT 5 [ RunTime:0.012914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095188 ORDER BY `minOrder` ASC [ RunTime:0.011162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42095188 ORDER BY `unit` DESC [ RunTime:0.003385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42095188 LIMIT 2 [ RunTime:0.002640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095188 ORDER BY `minOrder` ASC [ RunTime:0.004852s ]
select * from pdf where partno='SMBJ33A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102499 LIMIT 5 [ RunTime:0.008328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102499 ORDER BY `minOrder` ASC [ RunTime:0.014443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102499 ORDER BY `unit` DESC [ RunTime:0.022821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102499 LIMIT 2 [ RunTime:0.009602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102499 ORDER BY `minOrder` ASC [ RunTime:0.009953s ]
select * from pdf where partno='SMBJ33A-TR' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.006743s ]
select foldpath,foldpath2,filename from pdf_file where id=422312 limit 1 [ RunTime:0.001375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-TR' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.002480s ]
SELECT `id` FROM `stock` WHERE `id` <> 42102499 AND `partno` = 'SMBJ33A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.005096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909393 [ RunTime:0.003018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142329 LIMIT 5 [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142329 ORDER BY `minOrder` ASC [ RunTime:0.005262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142329 ORDER BY `unit` DESC [ RunTime:0.009857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142329 LIMIT 2 [ RunTime:0.001498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142329 ORDER BY `minOrder` ASC [ RunTime:0.002085s ]
select * from pdf where partno='SMBJ33AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004858s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142329 AND `partno` = 'SMBJ33AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810830 [ RunTime:0.010703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146891 LIMIT 5 [ RunTime:0.011569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146891 ORDER BY `minOrder` ASC [ RunTime:0.006818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146891 ORDER BY `unit` DESC [ RunTime:0.016131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146891 LIMIT 2 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146891 ORDER BY `minOrder` ASC [ RunTime:0.002457s ]
select * from pdf where partno='SMBJ33A' and brandshort='MDD' limit 1 [ RunTime:0.006133s ]
select foldpath,foldpath2,filename from pdf_file where id=1114005 limit 1 [ RunTime:0.022924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.006370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124503 LIMIT 5 [ RunTime:0.001055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124503 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124503 ORDER BY `unit` DESC [ RunTime:0.006690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124503 LIMIT 2 [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124503 ORDER BY `minOrder` ASC [ RunTime:0.006047s ]
select * from pdf where partno='SMBJ33A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.003801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102946 LIMIT 5 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102946 ORDER BY `minOrder` ASC [ RunTime:0.007062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102946 ORDER BY `unit` DESC [ RunTime:0.004171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102946 LIMIT 2 [ RunTime:0.002732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102946 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='SMBJ33A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149486 LIMIT 5 [ RunTime:0.010098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149486 ORDER BY `minOrder` ASC [ RunTime:0.040400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149486 ORDER BY `unit` DESC [ RunTime:0.017943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149486 LIMIT 2 [ RunTime:0.012813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149486 ORDER BY `minOrder` ASC [ RunTime:0.020937s ]
select * from pdf where partno='SMBJ33A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.009992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42129994 LIMIT 5 [ RunTime:0.003665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129994 ORDER BY `minOrder` ASC [ RunTime:0.009145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42129994 ORDER BY `unit` DESC [ RunTime:0.010860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42129994 LIMIT 2 [ RunTime:0.009240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42129994 ORDER BY `minOrder` ASC [ RunTime:0.013007s ]
select * from pdf where partno='SMBJ33A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011288s ]
SELECT `id` FROM `stock` WHERE `id` <> 42129994 AND `partno` = 'SMBJ33A-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829431 [ RunTime:0.007046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149436 LIMIT 5 [ RunTime:0.003250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149436 ORDER BY `minOrder` ASC [ RunTime:0.051487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149436 ORDER BY `unit` DESC [ RunTime:0.005349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149436 LIMIT 2 [ RunTime:0.009424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149436 ORDER BY `minOrder` ASC [ RunTime:0.001823s ]
select * from pdf where partno='SMBJ33A' and brandshort='EVVO' limit 1 [ RunTime:0.003969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'EVVO%' ) ) LIMIT 1 [ RunTime:0.001542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153013 LIMIT 5 [ RunTime:0.012960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153013 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153013 ORDER BY `unit` DESC [ RunTime:0.014734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153013 LIMIT 2 [ RunTime:0.015474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153013 ORDER BY `minOrder` ASC [ RunTime:0.001793s ]
select * from pdf where partno='SMBJ33AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013964s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153013 AND `partno` = 'SMBJ33AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906070 [ RunTime:0.025750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101071 LIMIT 5 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101071 ORDER BY `minOrder` ASC [ RunTime:0.007596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101071 ORDER BY `unit` DESC [ RunTime:0.003920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101071 LIMIT 2 [ RunTime:0.020237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101071 ORDER BY `minOrder` ASC [ RunTime:0.016108s ]
select * from pdf where partno='SMBJ33A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.017621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.039759s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101071 AND `partno` = 'SMBJ33A-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915933 [ RunTime:0.007591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140069 LIMIT 5 [ RunTime:0.011961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140069 ORDER BY `minOrder` ASC [ RunTime:0.029016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140069 ORDER BY `unit` DESC [ RunTime:0.027783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140069 LIMIT 2 [ RunTime:0.007303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140069 ORDER BY `minOrder` ASC [ RunTime:0.013034s ]
select * from pdf where partno='SMBJ33A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.006859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.016094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101037 LIMIT 5 [ RunTime:0.006346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101037 ORDER BY `minOrder` ASC [ RunTime:0.001695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101037 ORDER BY `unit` DESC [ RunTime:0.020529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101037 LIMIT 2 [ RunTime:0.006928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101037 ORDER BY `minOrder` ASC [ RunTime:0.008705s ]
select * from pdf where partno='SMBJ33A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014837s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101037 AND `partno` = 'SMBJ33A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803032 [ RunTime:0.004464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42141524 LIMIT 5 [ RunTime:0.007002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141524 ORDER BY `minOrder` ASC [ RunTime:0.004344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42141524 ORDER BY `unit` DESC [ RunTime:0.012954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42141524 LIMIT 2 [ RunTime:0.015750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42141524 ORDER BY `minOrder` ASC [ RunTime:0.006907s ]
select * from pdf where partno='SMBJ33A' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.011555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.002112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109612 LIMIT 5 [ RunTime:0.018653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109612 ORDER BY `minOrder` ASC [ RunTime:0.016352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109612 ORDER BY `unit` DESC [ RunTime:0.013375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109612 LIMIT 2 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109612 ORDER BY `minOrder` ASC [ RunTime:0.004281s ]
select * from pdf where partno='SMBJ33A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.011075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42103859 LIMIT 5 [ RunTime:0.003437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103859 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42103859 ORDER BY `unit` DESC [ RunTime:0.000587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42103859 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103859 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='SMBJ33A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ33A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000589s ]
SELECT `id` FROM `stock` WHERE `id` <> 42103859 AND `partno` = 'SMBJ33A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672909 [ RunTime:0.000459s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001172s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001189s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000456s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010003s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006654s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011879s ]
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 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005055s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ33A%' OR `brand` LIKE 'SMBJ33A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003967s ]