SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002893s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.144' , `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=P6SMB150&search=1' [ RunTime:0.020215s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002109s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005633s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001619s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.144' ) [ RunTime:0.006338s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.008569s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009789s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002315s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6SMB150' LIMIT 1 [ RunTime:0.065661s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-12 11:57:11' WHERE `partno` = 'P6SMB150' [ RunTime:0.071148s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002654s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082663s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663376 LIMIT 5 [ RunTime:0.049228s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663376 ORDER BY `minOrder` ASC [ RunTime:0.027091s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663376 ORDER BY `unit` DESC [ RunTime:0.027373s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663376 LIMIT 2 [ RunTime:0.033491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663376 ORDER BY `minOrder` ASC [ RunTime:0.009194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906581 LIMIT 5 [ RunTime:0.044417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906581 ORDER BY `minOrder` ASC [ RunTime:0.062162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906581 ORDER BY `unit` DESC [ RunTime:0.038642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906581 LIMIT 2 [ RunTime:0.032554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906581 ORDER BY `minOrder` ASC [ RunTime:0.008916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915930 LIMIT 5 [ RunTime:0.024054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915930 ORDER BY `minOrder` ASC [ RunTime:0.030127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915930 ORDER BY `unit` DESC [ RunTime:0.039825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915930 LIMIT 2 [ RunTime:0.036429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915930 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678856 LIMIT 5 [ RunTime:0.016051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678856 ORDER BY `minOrder` ASC [ RunTime:0.015380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678856 ORDER BY `unit` DESC [ RunTime:0.019736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678856 LIMIT 2 [ RunTime:0.027136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678856 ORDER BY `minOrder` ASC [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909686 LIMIT 5 [ RunTime:0.006361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909686 ORDER BY `minOrder` ASC [ RunTime:0.010020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909686 ORDER BY `unit` DESC [ RunTime:0.001349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909686 LIMIT 2 [ RunTime:0.004883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909686 ORDER BY `minOrder` ASC [ RunTime:0.001386s ]
select * from pdf where partno='P6SMB150A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.020001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905841 LIMIT 5 [ RunTime:0.011422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905841 ORDER BY `minOrder` ASC [ RunTime:0.029706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905841 ORDER BY `unit` DESC [ RunTime:0.021388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905841 LIMIT 2 [ RunTime:0.019675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905841 ORDER BY `minOrder` ASC [ RunTime:0.003372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830893 LIMIT 5 [ RunTime:0.008635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830893 ORDER BY `minOrder` ASC [ RunTime:0.003234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830893 ORDER BY `unit` DESC [ RunTime:0.001213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830893 LIMIT 2 [ RunTime:0.009829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830893 ORDER BY `minOrder` ASC [ RunTime:0.002013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690390 LIMIT 5 [ RunTime:0.011298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690390 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690390 ORDER BY `unit` DESC [ RunTime:0.000774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690390 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690390 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666248 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666248 ORDER BY `minOrder` ASC [ RunTime:0.028560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666248 ORDER BY `unit` DESC [ RunTime:0.014585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666248 LIMIT 2 [ RunTime:0.013500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666248 ORDER BY `minOrder` ASC [ RunTime:0.006243s ]
select * from pdf where partno='P6SMB150CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16686193 LIMIT 5 [ RunTime:0.011662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686193 ORDER BY `minOrder` ASC [ RunTime:0.006623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16686193 ORDER BY `unit` DESC [ RunTime:0.002239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16686193 LIMIT 2 [ RunTime:0.007071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686193 ORDER BY `minOrder` ASC [ RunTime:0.013073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928202 LIMIT 5 [ RunTime:0.008667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928202 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928202 ORDER BY `unit` DESC [ RunTime:0.003115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928202 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928202 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='P6SMB150CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662354 LIMIT 5 [ RunTime:0.003758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662354 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662354 ORDER BY `unit` DESC [ RunTime:0.006911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662354 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662354 ORDER BY `minOrder` ASC [ RunTime:0.004449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675138 LIMIT 5 [ RunTime:0.002524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675138 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675138 ORDER BY `unit` DESC [ RunTime:0.098690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675138 LIMIT 2 [ RunTime:0.036532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675138 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='P6SMB150A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803616 LIMIT 5 [ RunTime:0.009903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803616 ORDER BY `minOrder` ASC [ RunTime:0.003164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803616 ORDER BY `unit` DESC [ RunTime:0.019080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803616 LIMIT 2 [ RunTime:0.030828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803616 ORDER BY `minOrder` ASC [ RunTime:0.014789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908195 LIMIT 5 [ RunTime:0.001385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908195 ORDER BY `minOrder` ASC [ RunTime:0.002674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908195 ORDER BY `unit` DESC [ RunTime:0.015390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908195 LIMIT 2 [ RunTime:0.033405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908195 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908124 LIMIT 5 [ RunTime:0.019088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908124 ORDER BY `minOrder` ASC [ RunTime:0.012901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908124 ORDER BY `unit` DESC [ RunTime:0.021618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908124 LIMIT 2 [ RunTime:0.026758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908124 ORDER BY `minOrder` ASC [ RunTime:0.009405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907471 LIMIT 5 [ RunTime:0.005976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907471 ORDER BY `minOrder` ASC [ RunTime:0.006083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907471 ORDER BY `unit` DESC [ RunTime:0.006276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907471 LIMIT 2 [ RunTime:0.008028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907471 ORDER BY `minOrder` ASC [ RunTime:0.002853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691371 LIMIT 5 [ RunTime:0.014148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691371 ORDER BY `minOrder` ASC [ RunTime:0.005235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691371 ORDER BY `unit` DESC [ RunTime:0.003343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691371 LIMIT 2 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691371 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688756 LIMIT 5 [ RunTime:0.001082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688756 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688756 ORDER BY `unit` DESC [ RunTime:0.002348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688756 LIMIT 2 [ RunTime:0.003771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688756 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='P6SMB150AHE3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687824 LIMIT 5 [ RunTime:0.003814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687824 ORDER BY `minOrder` ASC [ RunTime:0.011618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687824 ORDER BY `unit` DESC [ RunTime:0.002181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687824 LIMIT 2 [ RunTime:0.007312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687824 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141057 LIMIT 5 [ RunTime:0.003872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141057 ORDER BY `minOrder` ASC [ RunTime:0.006717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141057 ORDER BY `unit` DESC [ RunTime:0.001987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141057 LIMIT 2 [ RunTime:0.010055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141057 ORDER BY `minOrder` ASC [ RunTime:0.017069s ]
select * from pdf where partno='p6smb150a-q' and brandshort='bourns' limit 1 [ RunTime:0.004994s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6smb150a-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.004469s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160738 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160738 ORDER BY `minOrder` ASC [ RunTime:0.002674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160738 ORDER BY `unit` DESC [ RunTime:0.011559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160738 LIMIT 2 [ RunTime:0.011833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160738 ORDER BY `minOrder` ASC [ RunTime:0.008984s ]
select * from pdf where partno='P6SMB150CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.006473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.009520s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160738 AND `partno` = 'P6SMB150CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.006116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906581 [ RunTime:0.016997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159964 LIMIT 5 [ RunTime:0.014658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159964 ORDER BY `minOrder` ASC [ RunTime:0.021609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159964 ORDER BY `unit` DESC [ RunTime:0.014411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159964 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159964 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='P6SMB150A' and brandshort='NextGen Components' limit 1 [ RunTime:0.001290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.008079s ]
SELECT `id` FROM `stock` WHERE `id` <> 42159964 AND `partno` = 'P6SMB150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.001147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663376 [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162159 LIMIT 5 [ RunTime:0.005764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162159 ORDER BY `minOrder` ASC [ RunTime:0.001175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162159 ORDER BY `unit` DESC [ RunTime:0.019859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162159 LIMIT 2 [ RunTime:0.015755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162159 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='P6SMB150AL150A' and brandshort='LGE Diodes' limit 1 [ RunTime:0.001686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150AL150A' OR `brand` LIKE 'LGE Diodes%' ) ) LIMIT 1 [ RunTime:0.005081s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162159 AND `partno` = 'P6SMB150AL150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lge diodes%' ) [ RunTime:0.001849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162137 LIMIT 5 [ RunTime:0.005119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162137 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162137 ORDER BY `unit` DESC [ RunTime:0.022604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162137 LIMIT 2 [ RunTime:0.012366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162137 ORDER BY `minOrder` ASC [ RunTime:0.009837s ]
select * from pdf where partno='P6SMB150CL150C' and brandshort='LGE Diodes' limit 1 [ RunTime:0.017527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CL150C' OR `brand` LIKE 'LGE Diodes%' ) ) LIMIT 1 [ RunTime:0.037971s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162137 AND `partno` = 'P6SMB150CL150C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lge diodes%' ) [ RunTime:0.000925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101457 LIMIT 5 [ RunTime:0.002978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101457 ORDER BY `minOrder` ASC [ RunTime:0.006353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101457 ORDER BY `unit` DESC [ RunTime:0.017325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101457 LIMIT 2 [ RunTime:0.006655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101457 ORDER BY `minOrder` ASC [ RunTime:0.011980s ]
select * from pdf where partno='P6SMB150A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008770s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101457 AND `partno` = 'P6SMB150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909686 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42100619 LIMIT 5 [ RunTime:0.014341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100619 ORDER BY `minOrder` ASC [ RunTime:0.003992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42100619 ORDER BY `unit` DESC [ RunTime:0.002343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42100619 LIMIT 2 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42100619 ORDER BY `minOrder` ASC [ RunTime:0.006604s ]
select * from pdf where partno='P6SMB150A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.008225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003299s ]
SELECT `id` FROM `stock` WHERE `id` <> 42100619 AND `partno` = 'P6SMB150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.018510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915930 [ RunTime:0.014645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42116956 LIMIT 5 [ RunTime:0.002061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116956 ORDER BY `minOrder` ASC [ RunTime:0.002666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42116956 ORDER BY `unit` DESC [ RunTime:0.010624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42116956 LIMIT 2 [ RunTime:0.006669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42116956 ORDER BY `minOrder` ASC [ RunTime:0.009729s ]
select * from pdf where partno='P6SMB150CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.005660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000747s ]
SELECT `id` FROM `stock` WHERE `id` <> 42116956 AND `partno` = 'P6SMB150CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.018012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678856 [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150175 LIMIT 5 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150175 ORDER BY `minOrder` ASC [ RunTime:0.019811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150175 ORDER BY `unit` DESC [ RunTime:0.000898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150175 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150175 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='P6SMB150A' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.004848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001367s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150175 AND `partno` = 'P6SMB150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.007913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905841 [ RunTime:0.011647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152990 LIMIT 5 [ RunTime:0.021580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152990 ORDER BY `minOrder` ASC [ RunTime:0.009580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152990 ORDER BY `unit` DESC [ RunTime:0.001783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152990 LIMIT 2 [ RunTime:0.005411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152990 ORDER BY `minOrder` ASC [ RunTime:0.007517s ]
select * from pdf where partno='P6SMB150CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.003517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.004226s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152990 AND `partno` = 'P6SMB150CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.011756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830893 [ RunTime:0.006156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152595 LIMIT 5 [ RunTime:0.001520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152595 ORDER BY `minOrder` ASC [ RunTime:0.001281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152595 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152595 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152595 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='P6SMB150A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.002837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.012083s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152595 AND `partno` = 'P6SMB150A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690390 [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123980 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123980 ORDER BY `minOrder` ASC [ RunTime:0.011147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123980 ORDER BY `unit` DESC [ RunTime:0.002708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123980 LIMIT 2 [ RunTime:0.004736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123980 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='P6SMB150A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.002555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42103010 LIMIT 5 [ RunTime:0.009222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103010 ORDER BY `minOrder` ASC [ RunTime:0.002705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42103010 ORDER BY `unit` DESC [ RunTime:0.006213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42103010 LIMIT 2 [ RunTime:0.008158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103010 ORDER BY `minOrder` ASC [ RunTime:0.005314s ]
select * from pdf where partno='P6SMB150CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000978s ]
SELECT `id` FROM `stock` WHERE `id` <> 42103010 AND `partno` = 'P6SMB150CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666248 [ RunTime:0.003358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128161 LIMIT 5 [ RunTime:0.001439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128161 ORDER BY `minOrder` ASC [ RunTime:0.001265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128161 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128161 LIMIT 2 [ RunTime:0.002546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128161 ORDER BY `minOrder` ASC [ RunTime:0.005466s ]
select * from pdf where partno='P6SMB150CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004516s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128161 AND `partno` = 'P6SMB150CA-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928202 [ RunTime:0.020809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147721 LIMIT 5 [ RunTime:0.005039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147721 ORDER BY `minOrder` ASC [ RunTime:0.007567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147721 ORDER BY `unit` DESC [ RunTime:0.002576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147721 LIMIT 2 [ RunTime:0.004843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147721 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='P6SMB150CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128980 LIMIT 5 [ RunTime:0.017907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128980 ORDER BY `minOrder` ASC [ RunTime:0.016065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128980 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128980 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128980 ORDER BY `minOrder` ASC [ RunTime:0.001001s ]
select * from pdf where partno='P6SMB150A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007224s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128980 AND `partno` = 'P6SMB150A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675138 [ RunTime:0.000739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174314 LIMIT 5 [ RunTime:0.015068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174314 ORDER BY `minOrder` ASC [ RunTime:0.018223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174314 ORDER BY `unit` DESC [ RunTime:0.001195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174314 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174314 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='P6SMB150CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.034747s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174314 AND `partno` = 'P6SMB150CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.034849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908195 [ RunTime:0.035019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173451 LIMIT 5 [ RunTime:0.010591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173451 ORDER BY `minOrder` ASC [ RunTime:0.002213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173451 ORDER BY `unit` DESC [ RunTime:0.003190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173451 LIMIT 2 [ RunTime:0.008338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173451 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='P6SMB150A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.006097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000980s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173451 AND `partno` = 'P6SMB150A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.034756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908124 [ RunTime:0.020115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173445 LIMIT 5 [ RunTime:0.005116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173445 ORDER BY `minOrder` ASC [ RunTime:0.030718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173445 ORDER BY `unit` DESC [ RunTime:0.026998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173445 LIMIT 2 [ RunTime:0.014842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173445 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='P6SMB150AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.001651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.039547s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173445 AND `partno` = 'P6SMB150AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.050929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803616 [ RunTime:0.003304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169999 LIMIT 5 [ RunTime:0.003135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169999 ORDER BY `minOrder` ASC [ RunTime:0.005160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169999 ORDER BY `unit` DESC [ RunTime:0.007096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169999 LIMIT 2 [ RunTime:0.002865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169999 ORDER BY `minOrder` ASC [ RunTime:0.003363s ]
select * from pdf where partno='P6SMB150A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.002247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42260269 LIMIT 5 [ RunTime:0.002539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42260269 ORDER BY `minOrder` ASC [ RunTime:0.022588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42260269 ORDER BY `unit` DESC [ RunTime:0.000832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42260269 LIMIT 2 [ RunTime:0.002012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42260269 ORDER BY `minOrder` ASC [ RunTime:0.006164s ]
select * from pdf where partno='P6SMB150AT3' and brandshort='onsemi' limit 1 [ RunTime:0.001820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB150AT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.016084s ]
SELECT `id` FROM `stock` WHERE `id` <> 42260269 AND `partno` = 'P6SMB150AT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679123 [ RunTime:0.001193s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004166s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001365s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004276s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002032s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002566s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001736s ]
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 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000739s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6SMB150%' OR `brand` LIKE 'P6SMB150%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001109s ]