SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002387s ]
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=19421&search=1' [ RunTime:0.003551s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001855s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002068s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002059s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001801s ]
SELECT * FROM `stock_search` WHERE `partno` = '19421' LIMIT 1 [ RunTime:0.001969s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-10 02:11:14' WHERE `partno` = '19421' [ RunTime:0.003995s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001344s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015656s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651005 LIMIT 5 [ RunTime:0.025524s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651005 ORDER BY `minOrder` ASC [ RunTime:0.026927s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651005 ORDER BY `unit` DESC [ RunTime:0.005614s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651005 LIMIT 2 [ RunTime:0.019759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651005 ORDER BY `minOrder` ASC [ RunTime:0.013003s ]
select * from pdf where partno='1942154' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.024608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12559741 LIMIT 5 [ RunTime:0.012091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12559741 ORDER BY `minOrder` ASC [ RunTime:0.019954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12559741 ORDER BY `unit` DESC [ RunTime:0.003737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12559741 LIMIT 2 [ RunTime:0.013519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12559741 ORDER BY `minOrder` ASC [ RunTime:0.025395s ]
select * from pdf where partno='1942170' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15452673 LIMIT 5 [ RunTime:0.023355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15452673 ORDER BY `minOrder` ASC [ RunTime:0.021739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15452673 ORDER BY `unit` DESC [ RunTime:0.007000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15452673 LIMIT 2 [ RunTime:0.025797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15452673 ORDER BY `minOrder` ASC [ RunTime:0.005393s ]
select * from pdf where partno='1942196' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13108748 LIMIT 5 [ RunTime:0.009385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13108748 ORDER BY `minOrder` ASC [ RunTime:0.018479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13108748 ORDER BY `unit` DESC [ RunTime:0.014676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13108748 LIMIT 2 [ RunTime:0.021415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13108748 ORDER BY `minOrder` ASC [ RunTime:0.017474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639558 LIMIT 5 [ RunTime:0.015310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639558 ORDER BY `minOrder` ASC [ RunTime:0.056909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19639558 ORDER BY `unit` DESC [ RunTime:0.017770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19639558 LIMIT 2 [ RunTime:0.054910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19639558 ORDER BY `minOrder` ASC [ RunTime:0.027117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638489 LIMIT 5 [ RunTime:0.018274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638489 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638489 ORDER BY `unit` DESC [ RunTime:0.009345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638489 LIMIT 2 [ RunTime:0.001409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638489 ORDER BY `minOrder` ASC [ RunTime:0.029635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638311 LIMIT 5 [ RunTime:0.019295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638311 ORDER BY `minOrder` ASC [ RunTime:0.033558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638311 ORDER BY `unit` DESC [ RunTime:0.043083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638311 LIMIT 2 [ RunTime:0.012452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638311 ORDER BY `minOrder` ASC [ RunTime:0.012783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636829 LIMIT 5 [ RunTime:0.006895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636829 ORDER BY `minOrder` ASC [ RunTime:0.013560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636829 ORDER BY `unit` DESC [ RunTime:0.019362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636829 LIMIT 2 [ RunTime:0.013111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636829 ORDER BY `minOrder` ASC [ RunTime:0.025787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19629223 LIMIT 5 [ RunTime:0.010030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19629223 ORDER BY `minOrder` ASC [ RunTime:0.013995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19629223 ORDER BY `unit` DESC [ RunTime:0.026661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19629223 LIMIT 2 [ RunTime:0.023267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19629223 ORDER BY `minOrder` ASC [ RunTime:0.023923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19626486 LIMIT 5 [ RunTime:0.020959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19626486 ORDER BY `minOrder` ASC [ RunTime:0.021958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19626486 ORDER BY `unit` DESC [ RunTime:0.019041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19626486 LIMIT 2 [ RunTime:0.003740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19626486 ORDER BY `minOrder` ASC [ RunTime:0.021298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19618518 LIMIT 5 [ RunTime:0.008675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19618518 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19618518 ORDER BY `unit` DESC [ RunTime:0.006952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19618518 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19618518 ORDER BY `minOrder` ASC [ RunTime:0.003446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572563 LIMIT 5 [ RunTime:0.003633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572563 ORDER BY `minOrder` ASC [ RunTime:0.001900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19572563 ORDER BY `unit` DESC [ RunTime:0.016699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19572563 LIMIT 2 [ RunTime:0.015738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572563 ORDER BY `minOrder` ASC [ RunTime:0.007019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307563 LIMIT 5 [ RunTime:0.011577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307563 ORDER BY `minOrder` ASC [ RunTime:0.004037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17307563 ORDER BY `unit` DESC [ RunTime:0.028958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17307563 LIMIT 2 [ RunTime:0.003738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307563 ORDER BY `minOrder` ASC [ RunTime:0.001267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17306972 LIMIT 5 [ RunTime:0.009720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17306972 ORDER BY `minOrder` ASC [ RunTime:0.016437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17306972 ORDER BY `unit` DESC [ RunTime:0.018359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17306972 LIMIT 2 [ RunTime:0.001759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17306972 ORDER BY `minOrder` ASC [ RunTime:0.004210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428483 LIMIT 5 [ RunTime:0.005539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16428483 ORDER BY `minOrder` ASC [ RunTime:0.015485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16428483 ORDER BY `unit` DESC [ RunTime:0.004609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16428483 LIMIT 2 [ RunTime:0.005204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16428483 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448432 LIMIT 5 [ RunTime:0.006982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448432 ORDER BY `minOrder` ASC [ RunTime:0.022970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15448432 ORDER BY `unit` DESC [ RunTime:0.009704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15448432 LIMIT 2 [ RunTime:0.011747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448432 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418024 LIMIT 5 [ RunTime:0.019276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418024 ORDER BY `minOrder` ASC [ RunTime:0.008497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14418024 ORDER BY `unit` DESC [ RunTime:0.008877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14418024 LIMIT 2 [ RunTime:0.013036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418024 ORDER BY `minOrder` ASC [ RunTime:0.005314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417952 LIMIT 5 [ RunTime:0.002605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417952 ORDER BY `minOrder` ASC [ RunTime:0.007598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417952 ORDER BY `unit` DESC [ RunTime:0.003903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417952 LIMIT 2 [ RunTime:0.007210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417952 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543633 LIMIT 5 [ RunTime:0.007550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543633 ORDER BY `minOrder` ASC [ RunTime:0.003704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543633 ORDER BY `unit` DESC [ RunTime:0.001859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543633 LIMIT 2 [ RunTime:0.009837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543633 ORDER BY `minOrder` ASC [ RunTime:0.007319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612562 LIMIT 5 [ RunTime:0.026352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612562 ORDER BY `minOrder` ASC [ RunTime:0.016692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612562 ORDER BY `unit` DESC [ RunTime:0.020812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612562 LIMIT 2 [ RunTime:0.007553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612562 ORDER BY `minOrder` ASC [ RunTime:0.001703s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276148 LIMIT 5 [ RunTime:0.004894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276148 ORDER BY `minOrder` ASC [ RunTime:0.007695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276148 ORDER BY `unit` DESC [ RunTime:0.003717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276148 LIMIT 2 [ RunTime:0.008371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276148 ORDER BY `minOrder` ASC [ RunTime:0.004689s ]
select * from pdf where partno='1942141' and brandshort='phoenix contact' limit 1 [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942141' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.000637s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60485724 LIMIT 5 [ RunTime:0.022355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60485724 ORDER BY `minOrder` ASC [ RunTime:0.026470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60485724 ORDER BY `unit` DESC [ RunTime:0.004850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60485724 LIMIT 2 [ RunTime:0.019189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60485724 ORDER BY `minOrder` ASC [ RunTime:0.014534s ]
select * from pdf where partno='1942196' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942196' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.034533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60490983 LIMIT 5 [ RunTime:0.012792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60490983 ORDER BY `minOrder` ASC [ RunTime:0.041749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60490983 ORDER BY `unit` DESC [ RunTime:0.027283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60490983 LIMIT 2 [ RunTime:0.015261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60490983 ORDER BY `minOrder` ASC [ RunTime:0.012013s ]
select * from pdf where partno='1942167' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942167' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60492683 LIMIT 5 [ RunTime:0.011215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60492683 ORDER BY `minOrder` ASC [ RunTime:0.029682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60492683 ORDER BY `unit` DESC [ RunTime:0.005901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60492683 LIMIT 2 [ RunTime:0.009870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60492683 ORDER BY `minOrder` ASC [ RunTime:0.009890s ]
select * from pdf where partno='1942100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022669s ]
select foldpath,foldpath2,filename from pdf_file where id=1209477 limit 1 [ RunTime:0.008863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001889s ]
SELECT `id` FROM `stock` WHERE `id` <> 60492683 AND `partno` = '1942100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.027884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11445471 [ RunTime:0.024812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60400481 LIMIT 5 [ RunTime:0.017409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400481 ORDER BY `minOrder` ASC [ RunTime:0.016535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60400481 ORDER BY `unit` DESC [ RunTime:0.002591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60400481 LIMIT 2 [ RunTime:0.014478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60400481 ORDER BY `minOrder` ASC [ RunTime:0.008202s ]
select * from pdf where partno='19421900' and brandshort='LAPP' limit 1 [ RunTime:0.014016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19421900' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.024717s ]
SELECT `id` FROM `stock` WHERE `id` <> 60400481 AND `partno` = '19421900' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.040520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13108748 [ RunTime:0.023507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63152947 LIMIT 5 [ RunTime:0.017665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152947 ORDER BY `minOrder` ASC [ RunTime:0.035586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63152947 ORDER BY `unit` DESC [ RunTime:0.019305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63152947 LIMIT 2 [ RunTime:0.022422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63152947 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
select * from pdf where partno='19421.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.003386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19421.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.026361s ]
SELECT `id` FROM `stock` WHERE `id` <> 63152947 AND `partno` = '19421.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.006197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16428483 [ RunTime:0.005794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149799 LIMIT 5 [ RunTime:0.015266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149799 ORDER BY `minOrder` ASC [ RunTime:0.015392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149799 ORDER BY `unit` DESC [ RunTime:0.022017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149799 LIMIT 2 [ RunTime:0.013191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149799 ORDER BY `minOrder` ASC [ RunTime:0.010836s ]
select * from pdf where partno='19421.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.004994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19421.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.008904s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149799 AND `partno` = '19421.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.007144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543633 [ RunTime:0.021036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63148163 LIMIT 5 [ RunTime:0.028746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63148163 ORDER BY `minOrder` ASC [ RunTime:0.021578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63148163 ORDER BY `unit` DESC [ RunTime:0.012798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63148163 LIMIT 2 [ RunTime:0.036021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63148163 ORDER BY `minOrder` ASC [ RunTime:0.018575s ]
select * from pdf where partno='19421.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.008795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19421.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.023570s ]
SELECT `id` FROM `stock` WHERE `id` <> 63148163 AND `partno` = '19421.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.006091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418024 [ RunTime:0.017286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63147960 LIMIT 5 [ RunTime:0.020000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63147960 ORDER BY `minOrder` ASC [ RunTime:0.001826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63147960 ORDER BY `unit` DESC [ RunTime:0.013843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63147960 LIMIT 2 [ RunTime:0.003078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63147960 ORDER BY `minOrder` ASC [ RunTime:0.015179s ]
select * from pdf where partno='19421.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.009986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19421.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.005456s ]
SELECT `id` FROM `stock` WHERE `id` <> 63147960 AND `partno` = '19421.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.007253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417952 [ RunTime:0.024424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60537403 LIMIT 5 [ RunTime:0.036892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60537403 ORDER BY `minOrder` ASC [ RunTime:0.026900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60537403 ORDER BY `unit` DESC [ RunTime:0.026628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60537403 LIMIT 2 [ RunTime:0.029956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60537403 ORDER BY `minOrder` ASC [ RunTime:0.006975s ]
select * from pdf where partno='1942183' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.034914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942183' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60532965 LIMIT 5 [ RunTime:0.027324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60532965 ORDER BY `minOrder` ASC [ RunTime:0.037311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60532965 ORDER BY `unit` DESC [ RunTime:0.020955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60532965 LIMIT 2 [ RunTime:0.050356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60532965 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='1942190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.063389s ]
select foldpath,foldpath2,filename from pdf_file where id=1128599 limit 1 [ RunTime:0.037736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.067484s ]
SELECT `id` FROM `stock` WHERE `id` <> 60532965 AND `partno` = '1942190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.062023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19639558 [ RunTime:0.051805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60531289 LIMIT 5 [ RunTime:0.033213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60531289 ORDER BY `minOrder` ASC [ RunTime:0.007980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60531289 ORDER BY `unit` DESC [ RunTime:0.014534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60531289 LIMIT 2 [ RunTime:0.015782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60531289 ORDER BY `minOrder` ASC [ RunTime:0.059810s ]
select * from pdf where partno='1942180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.052898s ]
select foldpath,foldpath2,filename from pdf_file where id=1128598 limit 1 [ RunTime:0.048435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014616s ]
SELECT `id` FROM `stock` WHERE `id` <> 60531289 AND `partno` = '1942180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.035006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638489 [ RunTime:0.040956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60528846 LIMIT 5 [ RunTime:0.035686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60528846 ORDER BY `minOrder` ASC [ RunTime:0.123742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60528846 ORDER BY `unit` DESC [ RunTime:0.017844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60528846 LIMIT 2 [ RunTime:0.104452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60528846 ORDER BY `minOrder` ASC [ RunTime:0.038133s ]
select * from pdf where partno='1942170000' and brandshort='Weidmüller' limit 1 [ RunTime:0.057663s ]
select foldpath,foldpath2,filename from pdf_file where id=1209482 limit 1 [ RunTime:0.056192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942170000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.036487s ]
SELECT `id` FROM `stock` WHERE `id` <> 60528846 AND `partno` = '1942170000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.048127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636829 [ RunTime:0.014047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60526267 LIMIT 5 [ RunTime:0.037125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60526267 ORDER BY `minOrder` ASC [ RunTime:0.059530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60526267 ORDER BY `unit` DESC [ RunTime:0.024270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60526267 LIMIT 2 [ RunTime:0.013578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60526267 ORDER BY `minOrder` ASC [ RunTime:0.008541s ]
select * from pdf where partno='1942160000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008086s ]
select foldpath,foldpath2,filename from pdf_file where id=1209481 limit 1 [ RunTime:0.009372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942160000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.042395s ]
SELECT `id` FROM `stock` WHERE `id` <> 60526267 AND `partno` = '1942160000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.019568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307563 [ RunTime:0.012990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60524014 LIMIT 5 [ RunTime:0.030583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60524014 ORDER BY `minOrder` ASC [ RunTime:0.012356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60524014 ORDER BY `unit` DESC [ RunTime:0.021879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60524014 LIMIT 2 [ RunTime:0.040353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60524014 ORDER BY `minOrder` ASC [ RunTime:0.009881s ]
select * from pdf where partno='1942150000' and brandshort='Weidmüller' limit 1 [ RunTime:0.024749s ]
select foldpath,foldpath2,filename from pdf_file where id=1209480 limit 1 [ RunTime:0.009671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942150000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.035677s ]
SELECT `id` FROM `stock` WHERE `id` <> 60524014 AND `partno` = '1942150000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.025090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448432 [ RunTime:0.008536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60521078 LIMIT 5 [ RunTime:0.001753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60521078 ORDER BY `minOrder` ASC [ RunTime:0.017509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60521078 ORDER BY `unit` DESC [ RunTime:0.007633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60521078 LIMIT 2 [ RunTime:0.002867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60521078 ORDER BY `minOrder` ASC [ RunTime:0.004409s ]
select * from pdf where partno='1942140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010168s ]
select foldpath,foldpath2,filename from pdf_file where id=1128597 limit 1 [ RunTime:0.007628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008533s ]
SELECT `id` FROM `stock` WHERE `id` <> 60521078 AND `partno` = '1942140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17306972 [ RunTime:0.005001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60518044 LIMIT 5 [ RunTime:0.015120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60518044 ORDER BY `minOrder` ASC [ RunTime:0.009916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60518044 ORDER BY `unit` DESC [ RunTime:0.011142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60518044 LIMIT 2 [ RunTime:0.017966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60518044 ORDER BY `minOrder` ASC [ RunTime:0.005106s ]
select * from pdf where partno='1942130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005907s ]
select foldpath,foldpath2,filename from pdf_file where id=1209479 limit 1 [ RunTime:0.013584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942130000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018113s ]
SELECT `id` FROM `stock` WHERE `id` <> 60518044 AND `partno` = '1942130000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19629223 [ RunTime:0.008123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60515063 LIMIT 5 [ RunTime:0.019056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60515063 ORDER BY `minOrder` ASC [ RunTime:0.027337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60515063 ORDER BY `unit` DESC [ RunTime:0.002878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60515063 LIMIT 2 [ RunTime:0.003115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60515063 ORDER BY `minOrder` ASC [ RunTime:0.013674s ]
select * from pdf where partno='1942120000' and brandshort='Weidmüller' limit 1 [ RunTime:0.025826s ]
select foldpath,foldpath2,filename from pdf_file where id=1209478 limit 1 [ RunTime:0.026217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942120000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004095s ]
SELECT `id` FROM `stock` WHERE `id` <> 60515063 AND `partno` = '1942120000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19626486 [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60510102 LIMIT 5 [ RunTime:0.005725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60510102 ORDER BY `minOrder` ASC [ RunTime:0.012676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60510102 ORDER BY `unit` DESC [ RunTime:0.017115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60510102 LIMIT 2 [ RunTime:0.016101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60510102 ORDER BY `minOrder` ASC [ RunTime:0.003832s ]
select * from pdf where partno='1942141' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942141' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60492837 LIMIT 5 [ RunTime:0.005610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60492837 ORDER BY `minOrder` ASC [ RunTime:0.009799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60492837 ORDER BY `unit` DESC [ RunTime:0.003115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60492837 LIMIT 2 [ RunTime:0.020340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60492837 ORDER BY `minOrder` ASC [ RunTime:0.026735s ]
select * from pdf where partno='1942170' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942170' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60490798 LIMIT 5 [ RunTime:0.002641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60490798 ORDER BY `minOrder` ASC [ RunTime:0.029728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60490798 ORDER BY `unit` DESC [ RunTime:0.021997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60490798 LIMIT 2 [ RunTime:0.030954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60490798 ORDER BY `minOrder` ASC [ RunTime:0.011279s ]
select * from pdf where partno='1942154' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1942154' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.046898s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048663s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037838s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040520s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037362s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030912s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072025s ]
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 '19421%' OR `brand` LIKE '19421%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087200s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19421%' OR `brand` LIKE '19421%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.050232s ]