SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001913s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=sbe&search=1' [ RunTime:0.001958s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002320s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004014s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001981s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001837s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000989s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001952s ]
SELECT * FROM `stock_search` WHERE `partno` = 'sbe' LIMIT 1 [ RunTime:0.008277s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-13 15:28:55' WHERE `partno` = 'sbe' [ RunTime:0.009659s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002833s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007262s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14852152 LIMIT 5 [ RunTime:0.009048s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14852152 ORDER BY `minOrder` ASC [ RunTime:0.014732s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14852152 ORDER BY `unit` DESC [ RunTime:0.014801s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14852152 LIMIT 2 [ RunTime:0.014906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14852152 ORDER BY `minOrder` ASC [ RunTime:0.003199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510405 LIMIT 5 [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510405 ORDER BY `minOrder` ASC [ RunTime:0.002910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510405 ORDER BY `unit` DESC [ RunTime:0.008748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510405 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510405 ORDER BY `minOrder` ASC [ RunTime:0.007325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510506 LIMIT 5 [ RunTime:0.018402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510506 ORDER BY `minOrder` ASC [ RunTime:0.009289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510506 ORDER BY `unit` DESC [ RunTime:0.005757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510506 LIMIT 2 [ RunTime:0.014297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510506 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510448 LIMIT 5 [ RunTime:0.003567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510448 ORDER BY `minOrder` ASC [ RunTime:0.012821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510448 ORDER BY `unit` DESC [ RunTime:0.001427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510448 LIMIT 2 [ RunTime:0.002414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510448 ORDER BY `minOrder` ASC [ RunTime:0.004305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510509 LIMIT 5 [ RunTime:0.033924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510509 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510509 ORDER BY `unit` DESC [ RunTime:0.006924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510509 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510509 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510048 LIMIT 5 [ RunTime:0.017045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510048 ORDER BY `minOrder` ASC [ RunTime:0.019260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510048 ORDER BY `unit` DESC [ RunTime:0.002482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510048 LIMIT 2 [ RunTime:0.020311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510048 ORDER BY `minOrder` ASC [ RunTime:0.013749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510102 LIMIT 5 [ RunTime:0.009952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510102 ORDER BY `minOrder` ASC [ RunTime:0.005323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510102 ORDER BY `unit` DESC [ RunTime:0.011450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510102 LIMIT 2 [ RunTime:0.003401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510102 ORDER BY `minOrder` ASC [ RunTime:0.002092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510100 LIMIT 5 [ RunTime:0.002649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510100 ORDER BY `minOrder` ASC [ RunTime:0.010154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510100 ORDER BY `unit` DESC [ RunTime:0.015102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510100 LIMIT 2 [ RunTime:0.023651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510100 ORDER BY `minOrder` ASC [ RunTime:0.009882s ]
select * from pdf where partno='SBE80CLPRED-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.010084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510110 LIMIT 5 [ RunTime:0.014970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510110 ORDER BY `minOrder` ASC [ RunTime:0.010303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510110 ORDER BY `unit` DESC [ RunTime:0.036482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510110 LIMIT 2 [ RunTime:0.012882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510110 ORDER BY `minOrder` ASC [ RunTime:0.011817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510627 LIMIT 5 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510627 ORDER BY `minOrder` ASC [ RunTime:0.010659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510627 ORDER BY `unit` DESC [ RunTime:0.004426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510627 LIMIT 2 [ RunTime:0.027607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510627 ORDER BY `minOrder` ASC [ RunTime:0.014235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11413447 LIMIT 5 [ RunTime:0.001608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413447 ORDER BY `minOrder` ASC [ RunTime:0.013163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11413447 ORDER BY `unit` DESC [ RunTime:0.009394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11413447 LIMIT 2 [ RunTime:0.009829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413447 ORDER BY `minOrder` ASC [ RunTime:0.005957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510628 LIMIT 5 [ RunTime:0.003939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510628 ORDER BY `minOrder` ASC [ RunTime:0.013252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510628 ORDER BY `unit` DESC [ RunTime:0.046235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510628 LIMIT 2 [ RunTime:0.040256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510628 ORDER BY `minOrder` ASC [ RunTime:0.009749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13230435 LIMIT 5 [ RunTime:0.021034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230435 ORDER BY `minOrder` ASC [ RunTime:0.038392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13230435 ORDER BY `unit` DESC [ RunTime:0.009520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13230435 LIMIT 2 [ RunTime:0.005786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230435 ORDER BY `minOrder` ASC [ RunTime:0.014618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510832 LIMIT 5 [ RunTime:0.018140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510832 ORDER BY `minOrder` ASC [ RunTime:0.032459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510832 ORDER BY `unit` DESC [ RunTime:0.029556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510832 LIMIT 2 [ RunTime:0.018804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510832 ORDER BY `minOrder` ASC [ RunTime:0.005144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510826 LIMIT 5 [ RunTime:0.016288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510826 ORDER BY `minOrder` ASC [ RunTime:0.031522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510826 ORDER BY `unit` DESC [ RunTime:0.018539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510826 LIMIT 2 [ RunTime:0.041140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510826 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510276 LIMIT 5 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510276 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510276 ORDER BY `unit` DESC [ RunTime:0.039323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510276 LIMIT 2 [ RunTime:0.058943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510276 ORDER BY `minOrder` ASC [ RunTime:0.007252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510258 LIMIT 5 [ RunTime:0.025982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510258 ORDER BY `minOrder` ASC [ RunTime:0.056490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12510258 ORDER BY `unit` DESC [ RunTime:0.015952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12510258 LIMIT 2 [ RunTime:0.006485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12510258 ORDER BY `minOrder` ASC [ RunTime:0.007395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12236862 LIMIT 5 [ RunTime:0.021569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12236862 ORDER BY `minOrder` ASC [ RunTime:0.017455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12236862 ORDER BY `unit` DESC [ RunTime:0.016270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12236862 LIMIT 2 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12236862 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12004361 LIMIT 5 [ RunTime:0.006302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12004361 ORDER BY `minOrder` ASC [ RunTime:0.024195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12004361 ORDER BY `unit` DESC [ RunTime:0.015254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12004361 LIMIT 2 [ RunTime:0.026811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12004361 ORDER BY `minOrder` ASC [ RunTime:0.025082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11413455 LIMIT 5 [ RunTime:0.017288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413455 ORDER BY `minOrder` ASC [ RunTime:0.020249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11413455 ORDER BY `unit` DESC [ RunTime:0.005561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11413455 LIMIT 2 [ RunTime:0.010556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413455 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263391 LIMIT 5 [ RunTime:0.002220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263391 ORDER BY `minOrder` ASC [ RunTime:0.030550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32263391 ORDER BY `unit` DESC [ RunTime:0.024811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32263391 LIMIT 2 [ RunTime:0.029747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32263391 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
select * from pdf where partno='sbe80red-bk' and brandshort='anderson power products' limit 1 [ RunTime:0.012882s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbe80red-bk' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.025018s ]
SELECT `id` FROM `stock` WHERE `id` <> 32263391 AND `partno` = 'sbe80red-bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.007807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32178916 [ RunTime:0.013614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510405 [ RunTime:0.026196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32178916 LIMIT 5 [ RunTime:0.013492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32178916 ORDER BY `minOrder` ASC [ RunTime:0.019827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32178916 ORDER BY `unit` DESC [ RunTime:0.007769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32178916 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32178916 ORDER BY `minOrder` ASC [ RunTime:0.009021s ]
select * from pdf where partno='sbe80red-bk' and brandshort='anderson power products' limit 1 [ RunTime:0.004820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbe80red-bk' OR `brand` LIKE 'anderson power products%' ) ) LIMIT 1 [ RunTime:0.000536s ]
SELECT `id` FROM `stock` WHERE `id` <> 32178916 AND `partno` = 'sbe80red-bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products%' ) [ RunTime:0.000970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32263391 [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510405 [ RunTime:0.002405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078608 LIMIT 5 [ RunTime:0.003434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078608 ORDER BY `minOrder` ASC [ RunTime:0.017878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078608 ORDER BY `unit` DESC [ RunTime:0.014878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078608 LIMIT 2 [ RunTime:0.021968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078608 ORDER BY `minOrder` ASC [ RunTime:0.015154s ]
select * from pdf where partno='sbe70lc-100ir' and brandshort='netburner' limit 1 [ RunTime:0.005533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbe70lc-100ir' OR `brand` LIKE 'netburner%' ) ) LIMIT 1 [ RunTime:0.002706s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078608 AND `partno` = 'sbe70lc-100ir' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%netburner%' ) [ RunTime:0.039099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12004361 [ RunTime:0.009460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080851 LIMIT 5 [ RunTime:0.011533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080851 ORDER BY `minOrder` ASC [ RunTime:0.009404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080851 ORDER BY `unit` DESC [ RunTime:0.008837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080851 LIMIT 2 [ RunTime:0.002745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080851 ORDER BY `minOrder` ASC [ RunTime:0.007474s ]
select * from pdf where partno='sbev' and brandshort='banner engineering' limit 1 [ RunTime:0.006118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbev' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.016868s ]
SELECT `id` FROM `stock` WHERE `id` <> 51080851 AND `partno` = 'sbev' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.012345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32616822 [ RunTime:0.007922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244349 LIMIT 5 [ RunTime:0.002950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244349 ORDER BY `minOrder` ASC [ RunTime:0.035902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32244349 ORDER BY `unit` DESC [ RunTime:0.022848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32244349 LIMIT 2 [ RunTime:0.007040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244349 ORDER BY `minOrder` ASC [ RunTime:0.002983s ]
select * from pdf where partno='sbe' and brandshort='banner engineering' limit 1 [ RunTime:0.025124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbe' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.027828s ]
SELECT `id` FROM `stock` WHERE `id` <> 32244349 AND `partno` = 'sbe' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.014436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173475 [ RunTime:0.034349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215267 [ RunTime:0.026374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613513 [ RunTime:0.010379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215267 LIMIT 5 [ RunTime:0.002313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215267 ORDER BY `minOrder` ASC [ RunTime:0.007322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32215267 ORDER BY `unit` DESC [ RunTime:0.014152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32215267 LIMIT 2 [ RunTime:0.014582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215267 ORDER BY `minOrder` ASC [ RunTime:0.008414s ]
select * from pdf where partno='sbe' and brandshort='banner engineering' limit 1 [ RunTime:0.008636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbe' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.010108s ]
SELECT `id` FROM `stock` WHERE `id` <> 32215267 AND `partno` = 'sbe' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.006490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173475 [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244349 [ RunTime:0.010650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613513 [ RunTime:0.006346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173475 LIMIT 5 [ RunTime:0.017922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173475 ORDER BY `minOrder` ASC [ RunTime:0.037930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32173475 ORDER BY `unit` DESC [ RunTime:0.010140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32173475 LIMIT 2 [ RunTime:0.017025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173475 ORDER BY `minOrder` ASC [ RunTime:0.004082s ]
select * from pdf where partno='sbe' and brandshort='banner engineering' limit 1 [ RunTime:0.007355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbe' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.000615s ]
SELECT `id` FROM `stock` WHERE `id` <> 32173475 AND `partno` = 'sbe' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.002031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215267 [ RunTime:0.004542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244349 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613513 [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244350 LIMIT 5 [ RunTime:0.007354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244350 ORDER BY `minOrder` ASC [ RunTime:0.005509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32244350 ORDER BY `unit` DESC [ RunTime:0.002643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32244350 LIMIT 2 [ RunTime:0.014770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244350 ORDER BY `minOrder` ASC [ RunTime:0.007347s ]
select * from pdf where partno='sbed' and brandshort='banner engineering' limit 1 [ RunTime:0.003453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbed' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.001017s ]
SELECT `id` FROM `stock` WHERE `id` <> 32244350 AND `partno` = 'sbed' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.011318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173476 [ RunTime:0.027244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215268 [ RunTime:0.002498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613514 [ RunTime:0.003394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215268 LIMIT 5 [ RunTime:0.001791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215268 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32215268 ORDER BY `unit` DESC [ RunTime:0.002965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32215268 LIMIT 2 [ RunTime:0.005667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215268 ORDER BY `minOrder` ASC [ RunTime:0.003466s ]
select * from pdf where partno='sbed' and brandshort='banner engineering' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbed' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.001811s ]
SELECT `id` FROM `stock` WHERE `id` <> 32215268 AND `partno` = 'sbed' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.010711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173476 [ RunTime:0.008077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244350 [ RunTime:0.001190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613514 [ RunTime:0.011873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173476 LIMIT 5 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173476 ORDER BY `minOrder` ASC [ RunTime:0.006968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32173476 ORDER BY `unit` DESC [ RunTime:0.011122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32173476 LIMIT 2 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173476 ORDER BY `minOrder` ASC [ RunTime:0.018594s ]
select * from pdf where partno='sbed' and brandshort='banner engineering' limit 1 [ RunTime:0.003724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbed' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.010550s ]
SELECT `id` FROM `stock` WHERE `id` <> 32173476 AND `partno` = 'sbed' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.002742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215268 [ RunTime:0.003066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244350 [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613514 [ RunTime:0.000921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081324 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081324 ORDER BY `minOrder` ASC [ RunTime:0.011553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081324 ORDER BY `unit` DESC [ RunTime:0.005117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081324 LIMIT 2 [ RunTime:0.006667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081324 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
select * from pdf where partno='sbef' and brandshort='banner engineering' limit 1 [ RunTime:0.012556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbef' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.037468s ]
SELECT `id` FROM `stock` WHERE `id` <> 51081324 AND `partno` = 'sbef' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.020357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32632750 [ RunTime:0.013455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244690 LIMIT 5 [ RunTime:0.025497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244690 ORDER BY `minOrder` ASC [ RunTime:0.030116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32244690 ORDER BY `unit` DESC [ RunTime:0.005903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32244690 LIMIT 2 [ RunTime:0.010830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244690 ORDER BY `minOrder` ASC [ RunTime:0.008742s ]
select * from pdf where partno='sbex' and brandshort='banner engineering' limit 1 [ RunTime:0.005653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sbex' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.010636s ]
SELECT `id` FROM `stock` WHERE `id` <> 32244690 AND `partno` = 'sbex' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.006928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622800 [ RunTime:0.024627s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630331 LIMIT 5 [ RunTime:0.009511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630331 ORDER BY `minOrder` ASC [ RunTime:0.017433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630331 ORDER BY `unit` DESC [ RunTime:0.015320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630331 LIMIT 2 [ RunTime:0.018372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630331 ORDER BY `minOrder` ASC [ RunTime:0.020063s ]
select * from pdf where partno='SBE809-TL-E' and brandshort='onsemi' limit 1 [ RunTime:0.020988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE809-TL-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.035478s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630331 AND `partno` = 'SBE809-TL-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.020187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40316920 LIMIT 5 [ RunTime:0.019338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40316920 ORDER BY `minOrder` ASC [ RunTime:0.033153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40316920 ORDER BY `unit` DESC [ RunTime:0.020994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40316920 LIMIT 2 [ RunTime:0.015517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40316920 ORDER BY `minOrder` ASC [ RunTime:0.031408s ]
select * from pdf where partno='SBEC2470JH00K' and brandshort='KEMET' limit 1 [ RunTime:0.023017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBEC2470JH00K' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.012300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630383 LIMIT 5 [ RunTime:0.022974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630383 ORDER BY `minOrder` ASC [ RunTime:0.036890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630383 ORDER BY `unit` DESC [ RunTime:0.021622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630383 LIMIT 2 [ RunTime:0.022943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630383 ORDER BY `minOrder` ASC [ RunTime:0.008293s ]
select * from pdf where partno='SBE802-TL-E' and brandshort='onsemi' limit 1 [ RunTime:0.034470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE802-TL-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.040801s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630383 AND `partno` = 'SBE802-TL-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.011846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44091399 LIMIT 5 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091399 ORDER BY `minOrder` ASC [ RunTime:0.017145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44091399 ORDER BY `unit` DESC [ RunTime:0.024651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44091399 LIMIT 2 [ RunTime:0.004187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44091399 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
select * from pdf where partno='SBE001-TL-E' and brandshort='onsemi' limit 1 [ RunTime:0.008674s ]
select foldpath,foldpath2,filename from pdf_file where id=1620998 limit 1 [ RunTime:0.013148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE001-TL-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.029619s ]
SELECT `id` FROM `stock` WHERE `id` <> 44091399 AND `partno` = 'SBE001-TL-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.007884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58631219 LIMIT 5 [ RunTime:0.034427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631219 ORDER BY `minOrder` ASC [ RunTime:0.020734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58631219 ORDER BY `unit` DESC [ RunTime:0.010976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58631219 LIMIT 2 [ RunTime:0.012505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58631219 ORDER BY `minOrder` ASC [ RunTime:0.011781s ]
select * from pdf where partno='SBE805-S-TL-W' and brandshort='onsemi' limit 1 [ RunTime:0.026645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE805-S-TL-W' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.023387s ]
SELECT `id` FROM `stock` WHERE `id` <> 58631219 AND `partno` = 'SBE805-S-TL-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.022724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58630395 LIMIT 5 [ RunTime:0.004830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630395 ORDER BY `minOrder` ASC [ RunTime:0.027375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58630395 ORDER BY `unit` DESC [ RunTime:0.035805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58630395 LIMIT 2 [ RunTime:0.026691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58630395 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
select * from pdf where partno='SBE601-TL-E' and brandshort='onsemi' limit 1 [ RunTime:0.019916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE601-TL-E' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.027134s ]
SELECT `id` FROM `stock` WHERE `id` <> 58630395 AND `partno` = 'SBE601-TL-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.036048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58628093 LIMIT 5 [ RunTime:0.026014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58628093 ORDER BY `minOrder` ASC [ RunTime:0.018137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58628093 ORDER BY `unit` DESC [ RunTime:0.001789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58628093 LIMIT 2 [ RunTime:0.027478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58628093 ORDER BY `minOrder` ASC [ RunTime:0.001037s ]
select * from pdf where partno='SBE805-TL-W' and brandshort='onsemi' limit 1 [ RunTime:0.014302s ]
select foldpath,foldpath2,filename from pdf_file where id=1115734 limit 1 [ RunTime:0.005506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE805-TL-W' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028400s ]
SELECT `id` FROM `stock` WHERE `id` <> 58628093 AND `partno` = 'SBE805-TL-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.013120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994062 LIMIT 5 [ RunTime:0.014878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994062 ORDER BY `minOrder` ASC [ RunTime:0.019017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994062 ORDER BY `unit` DESC [ RunTime:0.007862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994062 LIMIT 2 [ RunTime:0.004002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994062 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='SBE80ORN-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.008539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80ORN-BK' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001054s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994062 AND `partno` = 'SBE80ORN-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.012745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510506 [ RunTime:0.001083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60993973 LIMIT 5 [ RunTime:0.004752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60993973 ORDER BY `minOrder` ASC [ RunTime:0.025132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60993973 ORDER BY `unit` DESC [ RunTime:0.003541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60993973 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60993973 ORDER BY `minOrder` ASC [ RunTime:0.003377s ]
select * from pdf where partno='SBE80RED-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80RED-BK' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.006138s ]
SELECT `id` FROM `stock` WHERE `id` <> 60993973 AND `partno` = 'SBE80RED-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.014005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510405 [ RunTime:0.008815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994065 LIMIT 5 [ RunTime:0.007040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994065 ORDER BY `minOrder` ASC [ RunTime:0.009751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994065 ORDER BY `unit` DESC [ RunTime:0.006682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994065 LIMIT 2 [ RunTime:0.001714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994065 ORDER BY `minOrder` ASC [ RunTime:0.001522s ]
select * from pdf where partno='SBE80YEL-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.003941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80YEL-BK' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.002408s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994065 AND `partno` = 'SBE80YEL-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.008736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510509 [ RunTime:0.006422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994109 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994109 ORDER BY `minOrder` ASC [ RunTime:0.007186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994109 ORDER BY `unit` DESC [ RunTime:0.001972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994109 LIMIT 2 [ RunTime:0.010193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994109 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
select * from pdf where partno='SBE80GRA-BK' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.005102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80GRA-BK' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001135s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994109 AND `partno` = 'SBE80GRA-BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.010747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510448 [ RunTime:0.012122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994142 LIMIT 5 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994142 ORDER BY `minOrder` ASC [ RunTime:0.001218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994142 ORDER BY `unit` DESC [ RunTime:0.010921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994142 LIMIT 2 [ RunTime:0.002877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994142 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
select * from pdf where partno='SBE80GRA' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.009404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80GRA' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001485s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994142 AND `partno` = 'SBE80GRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.001117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510627 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60391849 LIMIT 5 [ RunTime:0.016932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391849 ORDER BY `minOrder` ASC [ RunTime:0.007621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60391849 ORDER BY `unit` DESC [ RunTime:0.002152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60391849 LIMIT 2 [ RunTime:0.013865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60391849 ORDER BY `minOrder` ASC [ RunTime:0.001724s ]
select * from pdf where partno='SBE80CLPRED' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.004231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80CLPRED' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001130s ]
SELECT `id` FROM `stock` WHERE `id` <> 60391849 AND `partno` = 'SBE80CLPRED' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.000723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510048 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58636689 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58636689 ORDER BY `minOrder` ASC [ RunTime:0.008516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58636689 ORDER BY `unit` DESC [ RunTime:0.003028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58636689 LIMIT 2 [ RunTime:0.006991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58636689 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='SBE807-TL-W' and brandshort='onsemi' limit 1 [ RunTime:0.004031s ]
select foldpath,foldpath2,filename from pdf_file where id=1149635 limit 1 [ RunTime:0.000846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE807-TL-W' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.013242s ]
SELECT `id` FROM `stock` WHERE `id` <> 58636689 AND `partno` = 'SBE807-TL-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64394146 LIMIT 5 [ RunTime:0.002175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64394146 ORDER BY `minOrder` ASC [ RunTime:0.001583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64394146 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64394146 LIMIT 2 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64394146 ORDER BY `minOrder` ASC [ RunTime:0.003045s ]
select * from pdf where partno='SBE70LC-100IR' and brandshort='NetBurner Inc.' limit 1 [ RunTime:0.003192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE70LC-100IR' OR `brand` LIKE 'NetBurner Inc.%' ) ) LIMIT 1 [ RunTime:0.002740s ]
SELECT `id` FROM `stock` WHERE `id` <> 64394146 AND `partno` = 'SBE70LC-100IR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%netburner inc.%' ) [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12004361 [ RunTime:0.004560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994500 LIMIT 5 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994500 ORDER BY `minOrder` ASC [ RunTime:0.001050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994500 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994500 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994500 ORDER BY `minOrder` ASC [ RunTime:0.006002s ]
select * from pdf where partno='SBE80YEL' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.002240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80YEL' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.004183s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994500 AND `partno` = 'SBE80YEL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.005421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510832 [ RunTime:0.004771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994495 LIMIT 5 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994495 ORDER BY `minOrder` ASC [ RunTime:0.000796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994495 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994495 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994495 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='SBE80ORN' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.000627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80ORN' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.001842s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994495 AND `partno` = 'SBE80ORN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510826 [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994222 LIMIT 5 [ RunTime:0.001832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994222 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994222 ORDER BY `unit` DESC [ RunTime:0.002087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994222 LIMIT 2 [ RunTime:0.002499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994222 ORDER BY `minOrder` ASC [ RunTime:0.003417s ]
select * from pdf where partno='SBE80RED' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80RED' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.003896s ]
SELECT `id` FROM `stock` WHERE `id` <> 60994222 AND `partno` = 'SBE80RED' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.009302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510628 [ RunTime:0.004055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60392188 LIMIT 5 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392188 ORDER BY `minOrder` ASC [ RunTime:0.005020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60392188 ORDER BY `unit` DESC [ RunTime:0.015141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60392188 LIMIT 2 [ RunTime:0.003524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392188 ORDER BY `minOrder` ASC [ RunTime:0.000992s ]
select * from pdf where partno='SBE80HDLORN' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.005098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80HDLORN' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.002264s ]
SELECT `id` FROM `stock` WHERE `id` <> 60392188 AND `partno` = 'SBE80HDLORN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60392183 LIMIT 5 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392183 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60392183 ORDER BY `unit` DESC [ RunTime:0.001978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60392183 LIMIT 2 [ RunTime:0.008644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60392183 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='SBE80HDLYEL' and brandshort='Anderson Power Products, Inc.' limit 1 [ RunTime:0.000660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SBE80HDLYEL' OR `brand` LIKE 'Anderson Power Products, Inc.%' ) ) LIMIT 1 [ RunTime:0.002976s ]
SELECT `id` FROM `stock` WHERE `id` <> 60392183 AND `partno` = 'SBE80HDLYEL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%anderson power products, inc.%' ) [ RunTime:0.002556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12510276 [ RunTime:0.002764s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004693s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004344s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005302s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005287s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010357s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006220s ]
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 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005288s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'sbe%' OR `brand` LIKE 'sbe%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010171s ]