SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002318s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=9130&search=1' [ RunTime:0.003565s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001980s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001111s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.001204s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001386s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000267s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001058s ]
SELECT * FROM `stock_search` WHERE `partno` = '9130' LIMIT 1 [ RunTime:0.001731s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-11 00:53:38' WHERE `partno` = '9130' [ RunTime:0.006178s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001406s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016491s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986727 LIMIT 5 [ RunTime:0.001108s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13986727 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13986727 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13986727 LIMIT 2 [ RunTime:0.032719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13986727 ORDER BY `minOrder` ASC [ RunTime:0.025819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12158796 LIMIT 5 [ RunTime:0.019927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12158796 ORDER BY `minOrder` ASC [ RunTime:0.053596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12158796 ORDER BY `unit` DESC [ RunTime:0.017385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12158796 LIMIT 2 [ RunTime:0.013731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12158796 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19245649 LIMIT 5 [ RunTime:0.005554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245649 ORDER BY `minOrder` ASC [ RunTime:0.016553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19245649 ORDER BY `unit` DESC [ RunTime:0.016163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19245649 LIMIT 2 [ RunTime:0.014550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245649 ORDER BY `minOrder` ASC [ RunTime:0.004037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19245648 LIMIT 5 [ RunTime:0.013006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245648 ORDER BY `minOrder` ASC [ RunTime:0.009330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19245648 ORDER BY `unit` DESC [ RunTime:0.005369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19245648 LIMIT 2 [ RunTime:0.008660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245648 ORDER BY `minOrder` ASC [ RunTime:0.003856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19245647 LIMIT 5 [ RunTime:0.012368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245647 ORDER BY `minOrder` ASC [ RunTime:0.009532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19245647 ORDER BY `unit` DESC [ RunTime:0.018591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19245647 LIMIT 2 [ RunTime:0.009247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245647 ORDER BY `minOrder` ASC [ RunTime:0.004790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19245646 LIMIT 5 [ RunTime:0.008426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245646 ORDER BY `minOrder` ASC [ RunTime:0.040572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19245646 ORDER BY `unit` DESC [ RunTime:0.005043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19245646 LIMIT 2 [ RunTime:0.051819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19245646 ORDER BY `minOrder` ASC [ RunTime:0.016477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18766374 LIMIT 5 [ RunTime:0.010001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18766374 ORDER BY `minOrder` ASC [ RunTime:0.026184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18766374 ORDER BY `unit` DESC [ RunTime:0.011966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18766374 LIMIT 2 [ RunTime:0.005422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18766374 ORDER BY `minOrder` ASC [ RunTime:0.019623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18762226 LIMIT 5 [ RunTime:0.015430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18762226 ORDER BY `minOrder` ASC [ RunTime:0.014846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18762226 ORDER BY `unit` DESC [ RunTime:0.000756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18762226 LIMIT 2 [ RunTime:0.016897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18762226 ORDER BY `minOrder` ASC [ RunTime:0.013759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18756607 LIMIT 5 [ RunTime:0.003950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18756607 ORDER BY `minOrder` ASC [ RunTime:0.010185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18756607 ORDER BY `unit` DESC [ RunTime:0.013844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18756607 LIMIT 2 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18756607 ORDER BY `minOrder` ASC [ RunTime:0.012081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18745810 LIMIT 5 [ RunTime:0.016300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18745810 ORDER BY `minOrder` ASC [ RunTime:0.023796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18745810 ORDER BY `unit` DESC [ RunTime:0.013105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18745810 LIMIT 2 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18745810 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18745023 LIMIT 5 [ RunTime:0.003619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18745023 ORDER BY `minOrder` ASC [ RunTime:0.017561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18745023 ORDER BY `unit` DESC [ RunTime:0.004049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18745023 LIMIT 2 [ RunTime:0.002491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18745023 ORDER BY `minOrder` ASC [ RunTime:0.008168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18733047 LIMIT 5 [ RunTime:0.001490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18733047 ORDER BY `minOrder` ASC [ RunTime:0.003446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18733047 ORDER BY `unit` DESC [ RunTime:0.006427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18733047 LIMIT 2 [ RunTime:0.000794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18733047 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701131 LIMIT 5 [ RunTime:0.002871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701131 ORDER BY `minOrder` ASC [ RunTime:0.017185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701131 ORDER BY `unit` DESC [ RunTime:0.001008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701131 LIMIT 2 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701131 ORDER BY `minOrder` ASC [ RunTime:0.005534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17129101 LIMIT 5 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17129101 ORDER BY `minOrder` ASC [ RunTime:0.007874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17129101 ORDER BY `unit` DESC [ RunTime:0.007131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17129101 LIMIT 2 [ RunTime:0.019823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17129101 ORDER BY `minOrder` ASC [ RunTime:0.005152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16385855 LIMIT 5 [ RunTime:0.022865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385855 ORDER BY `minOrder` ASC [ RunTime:0.001079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16385855 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16385855 LIMIT 2 [ RunTime:0.006589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385855 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16385854 LIMIT 5 [ RunTime:0.001091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385854 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16385854 ORDER BY `unit` DESC [ RunTime:0.008449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16385854 LIMIT 2 [ RunTime:0.011765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385854 ORDER BY `minOrder` ASC [ RunTime:0.012950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16385853 LIMIT 5 [ RunTime:0.009171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385853 ORDER BY `minOrder` ASC [ RunTime:0.034455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16385853 ORDER BY `unit` DESC [ RunTime:0.021121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16385853 LIMIT 2 [ RunTime:0.004887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385853 ORDER BY `minOrder` ASC [ RunTime:0.004212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16385852 LIMIT 5 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385852 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16385852 ORDER BY `unit` DESC [ RunTime:0.007563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16385852 LIMIT 2 [ RunTime:0.017810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16385852 ORDER BY `minOrder` ASC [ RunTime:0.008825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16130288 LIMIT 5 [ RunTime:0.001849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16130288 ORDER BY `minOrder` ASC [ RunTime:0.009247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16130288 ORDER BY `unit` DESC [ RunTime:0.018676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16130288 LIMIT 2 [ RunTime:0.017081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16130288 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16128361 LIMIT 5 [ RunTime:0.013064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16128361 ORDER BY `minOrder` ASC [ RunTime:0.010491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16128361 ORDER BY `unit` DESC [ RunTime:0.004515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16128361 LIMIT 2 [ RunTime:0.003715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16128361 ORDER BY `minOrder` ASC [ RunTime:0.009321s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283001 LIMIT 5 [ RunTime:0.007603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283001 ORDER BY `minOrder` ASC [ RunTime:0.007449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283001 ORDER BY `unit` DESC [ RunTime:0.003547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283001 LIMIT 2 [ RunTime:0.001643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283001 ORDER BY `minOrder` ASC [ RunTime:0.002126s ]
select * from pdf where partno='9130c' and brandshort='b&k precision' limit 1 [ RunTime:0.007898s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130c' OR `brand` LIKE 'b&k precision%' ) ) LIMIT 1 [ RunTime:0.007199s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283001 AND `partno` = '9130c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.015692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986727 [ RunTime:0.017279s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63523678 LIMIT 5 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523678 ORDER BY `minOrder` ASC [ RunTime:0.005705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63523678 ORDER BY `unit` DESC [ RunTime:0.006038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63523678 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63523678 ORDER BY `minOrder` ASC [ RunTime:0.005725s ]
select * from pdf where partno='9130C' and brandshort='B&K Precision' limit 1 [ RunTime:0.006188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130C' OR `brand` LIKE 'B&K Precision%' ) ) LIMIT 1 [ RunTime:0.000794s ]
SELECT `id` FROM `stock` WHERE `id` <> 63523678 AND `partno` = '9130C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.013428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13986727 [ RunTime:0.004718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58538279 LIMIT 5 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58538279 ORDER BY `minOrder` ASC [ RunTime:0.003059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58538279 ORDER BY `unit` DESC [ RunTime:0.008534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58538279 LIMIT 2 [ RunTime:0.011573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58538279 ORDER BY `minOrder` ASC [ RunTime:0.013460s ]
select * from pdf where partno='91302-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.013393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91302-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.010347s ]
SELECT `id` FROM `stock` WHERE `id` <> 58538279 AND `partno` = '91302-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.012269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44637463 LIMIT 5 [ RunTime:0.031990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44637463 ORDER BY `minOrder` ASC [ RunTime:0.003332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44637463 ORDER BY `unit` DESC [ RunTime:0.005677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44637463 LIMIT 2 [ RunTime:0.006334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44637463 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
select * from pdf where partno='91302-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.014432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91302-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000856s ]
SELECT `id` FROM `stock` WHERE `id` <> 44637463 AND `partno` = '91302-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12158796 [ RunTime:0.003031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33121702 LIMIT 5 [ RunTime:0.005355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33121702 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33121702 ORDER BY `unit` DESC [ RunTime:0.008757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33121702 LIMIT 2 [ RunTime:0.004536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33121702 ORDER BY `minOrder` ASC [ RunTime:0.009614s ]
select * from pdf where partno='91302-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91302-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.001728s ]
SELECT `id` FROM `stock` WHERE `id` <> 33121702 AND `partno` = '91302-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.004604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12158796 [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63853819 LIMIT 5 [ RunTime:0.001878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63853819 ORDER BY `minOrder` ASC [ RunTime:0.006340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63853819 ORDER BY `unit` DESC [ RunTime:0.012841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63853819 LIMIT 2 [ RunTime:0.024057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63853819 ORDER BY `minOrder` ASC [ RunTime:0.013341s ]
select * from pdf where partno='91305AGLF' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.004005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91305AGLF' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.008837s ]
SELECT `id` FROM `stock` WHERE `id` <> 63853819 AND `partno` = '91305AGLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.002844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17129101 [ RunTime:0.006525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63853768 LIMIT 5 [ RunTime:0.003551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63853768 ORDER BY `minOrder` ASC [ RunTime:0.005700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63853768 ORDER BY `unit` DESC [ RunTime:0.014586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63853768 LIMIT 2 [ RunTime:0.003603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63853768 ORDER BY `minOrder` ASC [ RunTime:0.003481s ]
select * from pdf where partno='91305AGLFT' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.004155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '91305AGLFT' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.009612s ]
SELECT `id` FROM `stock` WHERE `id` <> 63853768 AND `partno` = '91305AGLFT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.016347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16130288 [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63524022 LIMIT 5 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524022 ORDER BY `minOrder` ASC [ RunTime:0.011534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63524022 ORDER BY `unit` DESC [ RunTime:0.001557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63524022 LIMIT 2 [ RunTime:0.004839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63524022 ORDER BY `minOrder` ASC [ RunTime:0.008488s ]
select * from pdf where partno='9130B' and brandshort='B&K Precision' limit 1 [ RunTime:0.002323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130B' OR `brand` LIKE 'B&K Precision%' ) ) LIMIT 1 [ RunTime:0.006515s ]
SELECT `id` FROM `stock` WHERE `id` <> 63524022 AND `partno` = '9130B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%b&k precision%' ) [ RunTime:0.007479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14909722 [ RunTime:0.002539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63411262 LIMIT 5 [ RunTime:0.002068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63411262 ORDER BY `minOrder` ASC [ RunTime:0.001609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63411262 ORDER BY `unit` DESC [ RunTime:0.004263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63411262 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63411262 ORDER BY `minOrder` ASC [ RunTime:0.002291s ]
select * from pdf where partno='9130' and brandshort='80/20, LLC' limit 1 [ RunTime:0.007663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.003545s ]
SELECT `id` FROM `stock` WHERE `id` <> 63411262 AND `partno` = '9130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.002107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63403778 LIMIT 5 [ RunTime:0.005600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63403778 ORDER BY `minOrder` ASC [ RunTime:0.001389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63403778 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63403778 LIMIT 2 [ RunTime:0.001546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63403778 ORDER BY `minOrder` ASC [ RunTime:0.001560s ]
select * from pdf where partno='9130' and brandshort='ABBATRON' limit 1 [ RunTime:0.004602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.000995s ]
SELECT `id` FROM `stock` WHERE `id` <> 63403778 AND `partno` = '9130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%abbatron%' ) [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61931128 LIMIT 5 [ RunTime:0.008329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61931128 ORDER BY `minOrder` ASC [ RunTime:0.005208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61931128 ORDER BY `unit` DESC [ RunTime:0.002176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61931128 LIMIT 2 [ RunTime:0.007279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61931128 ORDER BY `minOrder` ASC [ RunTime:0.005387s ]
select * from pdf where partno='9130-1573-119' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130-1573-119' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.002771s ]
SELECT `id` FROM `stock` WHERE `id` <> 61931128 AND `partno` = '9130-1573-119' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.003091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61929459 LIMIT 5 [ RunTime:0.004459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61929459 ORDER BY `minOrder` ASC [ RunTime:0.006025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61929459 ORDER BY `unit` DESC [ RunTime:0.008512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61929459 LIMIT 2 [ RunTime:0.003323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61929459 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
select * from pdf where partno='9130-1573-019' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.008639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130-1573-019' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.004302s ]
SELECT `id` FROM `stock` WHERE `id` <> 61929459 AND `partno` = '9130-1573-019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.004799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12876529 [ RunTime:0.004058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61927796 LIMIT 5 [ RunTime:0.004188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61927796 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61927796 ORDER BY `unit` DESC [ RunTime:0.007756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61927796 LIMIT 2 [ RunTime:0.003535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61927796 ORDER BY `minOrder` ASC [ RunTime:0.001419s ]
select * from pdf where partno='9130-9573-002' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.008335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130-9573-002' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000913s ]
SELECT `id` FROM `stock` WHERE `id` <> 61927796 AND `partno` = '9130-9573-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.013555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875730 [ RunTime:0.002263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623843 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623843 ORDER BY `minOrder` ASC [ RunTime:0.017338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623843 ORDER BY `unit` DESC [ RunTime:0.008855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623843 LIMIT 2 [ RunTime:0.004461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623843 ORDER BY `minOrder` ASC [ RunTime:0.003810s ]
select * from pdf where partno='9130.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.006341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.010380s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623843 AND `partno` = '9130.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60473150 LIMIT 5 [ RunTime:0.003503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60473150 ORDER BY `minOrder` ASC [ RunTime:0.006147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60473150 ORDER BY `unit` DESC [ RunTime:0.004436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60473150 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60473150 ORDER BY `minOrder` ASC [ RunTime:0.002692s ]
select * from pdf where partno='9130980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013662s ]
SELECT `id` FROM `stock` WHERE `id` <> 60473150 AND `partno` = '9130980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563459 [ RunTime:0.027059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60473144 LIMIT 5 [ RunTime:0.018586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60473144 ORDER BY `minOrder` ASC [ RunTime:0.005922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60473144 ORDER BY `unit` DESC [ RunTime:0.000841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60473144 LIMIT 2 [ RunTime:0.020785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60473144 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='9130990000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130990000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018894s ]
SELECT `id` FROM `stock` WHERE `id` <> 60473144 AND `partno` = '9130990000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.021315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447878 [ RunTime:0.003826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58585029 LIMIT 5 [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58585029 ORDER BY `minOrder` ASC [ RunTime:0.013148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58585029 ORDER BY `unit` DESC [ RunTime:0.026948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58585029 LIMIT 2 [ RunTime:0.006559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58585029 ORDER BY `minOrder` ASC [ RunTime:0.004150s ]
select * from pdf where partno='9130D' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.002781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9130D' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.002490s ]
SELECT `id` FROM `stock` WHERE `id` <> 58585029 AND `partno` = '9130D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.001318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701131 [ RunTime:0.000764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44034450 LIMIT 5 [ RunTime:0.006481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034450 ORDER BY `minOrder` ASC [ RunTime:0.001889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44034450 ORDER BY `unit` DESC [ RunTime:0.000816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44034450 LIMIT 2 [ RunTime:0.000867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034450 ORDER BY `minOrder` ASC [ RunTime:0.001937s ]
select * from pdf where partno='913093-7' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.006217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '913093-7' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002871s ]
SELECT `id` FROM `stock` WHERE `id` <> 44034450 AND `partno` = '913093-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18745810 [ RunTime:0.018662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44034444 LIMIT 5 [ RunTime:0.024813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034444 ORDER BY `minOrder` ASC [ RunTime:0.010679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44034444 ORDER BY `unit` DESC [ RunTime:0.003481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44034444 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034444 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='913093-8' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.003060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '913093-8' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002750s ]
SELECT `id` FROM `stock` WHERE `id` <> 44034444 AND `partno` = '913093-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.011522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14175535 [ RunTime:0.010124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44034438 LIMIT 5 [ RunTime:0.004519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034438 ORDER BY `minOrder` ASC [ RunTime:0.003387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44034438 ORDER BY `unit` DESC [ RunTime:0.014380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44034438 LIMIT 2 [ RunTime:0.005333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44034438 ORDER BY `minOrder` ASC [ RunTime:0.001696s ]
select * from pdf where partno='913093-6' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.008426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '913093-6' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004123s ]
SELECT `id` FROM `stock` WHERE `id` <> 44034438 AND `partno` = '913093-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.011710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14175532 [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44032857 LIMIT 5 [ RunTime:0.007500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032857 ORDER BY `minOrder` ASC [ RunTime:0.006240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44032857 ORDER BY `unit` DESC [ RunTime:0.005978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44032857 LIMIT 2 [ RunTime:0.007722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032857 ORDER BY `minOrder` ASC [ RunTime:0.003996s ]
select * from pdf where partno='913096-3' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.009935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '913096-3' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.005081s ]
SELECT `id` FROM `stock` WHERE `id` <> 44032857 AND `partno` = '913096-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.003011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18745023 [ RunTime:0.010772s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003088s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011092s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005190s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011541s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006468s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001223s ]
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 '9130%' OR `brand` LIKE '9130%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006801s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9130%' OR `brand` LIKE '9130%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007646s ]