SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002465s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=5228&search=1' [ RunTime:0.008809s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002697s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003553s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002646s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.004772s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001870s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003191s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001959s ]
SELECT * FROM `stock_search` WHERE `partno` = '5228' LIMIT 1 [ RunTime:0.011397s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-01 15:22:34' WHERE `partno` = '5228' [ RunTime:0.002810s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003411s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035724s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388658 LIMIT 5 [ RunTime:0.006555s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388658 ORDER BY `minOrder` ASC [ RunTime:0.005179s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388658 ORDER BY `unit` DESC [ RunTime:0.017554s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388658 LIMIT 2 [ RunTime:0.002490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388658 ORDER BY `minOrder` ASC [ RunTime:0.002409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678227 LIMIT 5 [ RunTime:0.009347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11678227 ORDER BY `minOrder` ASC [ RunTime:0.011579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11678227 ORDER BY `unit` DESC [ RunTime:0.012539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11678227 LIMIT 2 [ RunTime:0.019181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11678227 ORDER BY `minOrder` ASC [ RunTime:0.008252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879666 LIMIT 5 [ RunTime:0.024901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879666 ORDER BY `minOrder` ASC [ RunTime:0.005905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12879666 ORDER BY `unit` DESC [ RunTime:0.002271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12879666 LIMIT 2 [ RunTime:0.001298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12879666 ORDER BY `minOrder` ASC [ RunTime:0.005029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681595 LIMIT 5 [ RunTime:0.014737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681595 ORDER BY `minOrder` ASC [ RunTime:0.007952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681595 ORDER BY `unit` DESC [ RunTime:0.024065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681595 LIMIT 2 [ RunTime:0.034307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681595 ORDER BY `minOrder` ASC [ RunTime:0.011518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14349147 LIMIT 5 [ RunTime:0.048448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14349147 ORDER BY `minOrder` ASC [ RunTime:0.019458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14349147 ORDER BY `unit` DESC [ RunTime:0.013008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14349147 LIMIT 2 [ RunTime:0.020944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14349147 ORDER BY `minOrder` ASC [ RunTime:0.018753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957403 LIMIT 5 [ RunTime:0.011722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957403 ORDER BY `minOrder` ASC [ RunTime:0.015657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18957403 ORDER BY `unit` DESC [ RunTime:0.010150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18957403 LIMIT 2 [ RunTime:0.016059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957403 ORDER BY `minOrder` ASC [ RunTime:0.015503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16358746 LIMIT 5 [ RunTime:0.068030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16358746 ORDER BY `minOrder` ASC [ RunTime:0.033484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16358746 ORDER BY `unit` DESC [ RunTime:0.035367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16358746 LIMIT 2 [ RunTime:0.010626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16358746 ORDER BY `minOrder` ASC [ RunTime:0.009980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289415 LIMIT 5 [ RunTime:0.020728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289415 ORDER BY `minOrder` ASC [ RunTime:0.031108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289415 ORDER BY `unit` DESC [ RunTime:0.032331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289415 LIMIT 2 [ RunTime:0.040067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289415 ORDER BY `minOrder` ASC [ RunTime:0.014201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880064 LIMIT 5 [ RunTime:0.030202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880064 ORDER BY `minOrder` ASC [ RunTime:0.060553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880064 ORDER BY `unit` DESC [ RunTime:0.018112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880064 LIMIT 2 [ RunTime:0.027017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880064 ORDER BY `minOrder` ASC [ RunTime:0.014233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880059 LIMIT 5 [ RunTime:0.050198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880059 ORDER BY `minOrder` ASC [ RunTime:0.093460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880059 ORDER BY `unit` DESC [ RunTime:0.028588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880059 LIMIT 2 [ RunTime:0.038906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880059 ORDER BY `minOrder` ASC [ RunTime:0.034399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12877738 LIMIT 5 [ RunTime:0.038270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12877738 ORDER BY `minOrder` ASC [ RunTime:0.013987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12877738 ORDER BY `unit` DESC [ RunTime:0.010671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12877738 LIMIT 2 [ RunTime:0.045865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12877738 ORDER BY `minOrder` ASC [ RunTime:0.016947s ]
select * from pdf where partno='5228686-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.063764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12873792 LIMIT 5 [ RunTime:0.046996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873792 ORDER BY `minOrder` ASC [ RunTime:0.047465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12873792 ORDER BY `unit` DESC [ RunTime:0.022744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12873792 LIMIT 2 [ RunTime:0.001184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12873792 ORDER BY `minOrder` ASC [ RunTime:0.004591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872580 LIMIT 5 [ RunTime:0.024621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872580 ORDER BY `minOrder` ASC [ RunTime:0.028296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12872580 ORDER BY `unit` DESC [ RunTime:0.009417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12872580 LIMIT 2 [ RunTime:0.030717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872580 ORDER BY `minOrder` ASC [ RunTime:0.001139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12514639 LIMIT 5 [ RunTime:0.044744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514639 ORDER BY `minOrder` ASC [ RunTime:0.043419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12514639 ORDER BY `unit` DESC [ RunTime:0.032736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12514639 LIMIT 2 [ RunTime:0.025722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12514639 ORDER BY `minOrder` ASC [ RunTime:0.008566s ]
select * from pdf where partno='52284-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513223 LIMIT 5 [ RunTime:0.023468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513223 ORDER BY `minOrder` ASC [ RunTime:0.029016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513223 ORDER BY `unit` DESC [ RunTime:0.049898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513223 LIMIT 2 [ RunTime:0.033831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513223 ORDER BY `minOrder` ASC [ RunTime:0.003455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12513218 LIMIT 5 [ RunTime:0.007140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513218 ORDER BY `minOrder` ASC [ RunTime:0.019495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12513218 ORDER BY `unit` DESC [ RunTime:0.043930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12513218 LIMIT 2 [ RunTime:0.030273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12513218 ORDER BY `minOrder` ASC [ RunTime:0.010380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416154 LIMIT 5 [ RunTime:0.019425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416154 ORDER BY `minOrder` ASC [ RunTime:0.012839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11416154 ORDER BY `unit` DESC [ RunTime:0.030128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11416154 LIMIT 2 [ RunTime:0.048254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416154 ORDER BY `minOrder` ASC [ RunTime:0.032602s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027062s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104550 LIMIT 5 [ RunTime:0.045138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104550 ORDER BY `minOrder` ASC [ RunTime:0.043123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104550 ORDER BY `unit` DESC [ RunTime:0.014338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104550 LIMIT 2 [ RunTime:0.010948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104550 ORDER BY `minOrder` ASC [ RunTime:0.010522s ]
select * from pdf where partno='5228' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.020769s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.006034s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104550 AND `partno` = '5228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388658 [ RunTime:0.021788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50752939 LIMIT 5 [ RunTime:0.002329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50752939 ORDER BY `minOrder` ASC [ RunTime:0.008100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50752939 ORDER BY `unit` DESC [ RunTime:0.010754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50752939 LIMIT 2 [ RunTime:0.009309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50752939 ORDER BY `minOrder` ASC [ RunTime:0.008173s ]
select * from pdf where partno='5228CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.022553s ]
SELECT `id` FROM `stock` WHERE `id` <> 50752939 AND `partno` = '5228CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38161020 [ RunTime:0.019465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38161020 LIMIT 5 [ RunTime:0.010035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38161020 ORDER BY `minOrder` ASC [ RunTime:0.018203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38161020 ORDER BY `unit` DESC [ RunTime:0.025726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38161020 LIMIT 2 [ RunTime:0.030716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38161020 ORDER BY `minOrder` ASC [ RunTime:0.004662s ]
select * from pdf where partno='5228CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013158s ]
SELECT `id` FROM `stock` WHERE `id` <> 38161020 AND `partno` = '5228CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.015664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50752939 [ RunTime:0.005137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53824486 LIMIT 5 [ RunTime:0.006989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53824486 ORDER BY `minOrder` ASC [ RunTime:0.031558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53824486 ORDER BY `unit` DESC [ RunTime:0.046043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53824486 LIMIT 2 [ RunTime:0.017329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53824486 ORDER BY `minOrder` ASC [ RunTime:0.019647s ]
select * from pdf where partno='52284-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52284-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.038598s ]
SELECT `id` FROM `stock` WHERE `id` <> 53824486 AND `partno` = '52284-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.034519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55087732 LIMIT 5 [ RunTime:0.042922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55087732 ORDER BY `minOrder` ASC [ RunTime:0.010155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55087732 ORDER BY `unit` DESC [ RunTime:0.055980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55087732 LIMIT 2 [ RunTime:0.042215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55087732 ORDER BY `minOrder` ASC [ RunTime:0.004725s ]
select * from pdf where partno='5228980-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.038414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228980-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.024877s ]
SELECT `id` FROM `stock` WHERE `id` <> 55087732 AND `partno` = '5228980-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.065105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678227 [ RunTime:0.031026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55089972 LIMIT 5 [ RunTime:0.020684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55089972 ORDER BY `minOrder` ASC [ RunTime:0.020355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55089972 ORDER BY `unit` DESC [ RunTime:0.013014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55089972 LIMIT 2 [ RunTime:0.020533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55089972 ORDER BY `minOrder` ASC [ RunTime:0.024816s ]
select * from pdf where partno='5228686-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228686-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017090s ]
SELECT `id` FROM `stock` WHERE `id` <> 55089972 AND `partno` = '5228686-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.112915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12877738 [ RunTime:0.022411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55090573 LIMIT 5 [ RunTime:0.030367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090573 ORDER BY `minOrder` ASC [ RunTime:0.008607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55090573 ORDER BY `unit` DESC [ RunTime:0.024325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55090573 LIMIT 2 [ RunTime:0.013720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090573 ORDER BY `minOrder` ASC [ RunTime:0.003546s ]
select * from pdf where partno='5228664-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.061749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228664-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014086s ]
SELECT `id` FROM `stock` WHERE `id` <> 55090573 AND `partno` = '5228664-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.024049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12879666 [ RunTime:0.015133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297873 LIMIT 5 [ RunTime:0.009088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297873 ORDER BY `minOrder` ASC [ RunTime:0.033266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297873 ORDER BY `unit` DESC [ RunTime:0.023261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297873 LIMIT 2 [ RunTime:0.015630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297873 ORDER BY `minOrder` ASC [ RunTime:0.009508s ]
select * from pdf where partno='5228' and brandshort='Pololu' limit 1 [ RunTime:0.018538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.024959s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297873 AND `partno` = '5228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.038960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14349147 [ RunTime:0.017757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55093578 LIMIT 5 [ RunTime:0.031205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55093578 ORDER BY `minOrder` ASC [ RunTime:0.010334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55093578 ORDER BY `unit` DESC [ RunTime:0.021258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55093578 LIMIT 2 [ RunTime:0.025983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55093578 ORDER BY `minOrder` ASC [ RunTime:0.027131s ]
select * from pdf where partno='5228980-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228980-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008788s ]
SELECT `id` FROM `stock` WHERE `id` <> 55093578 AND `partno` = '5228980-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.020175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48080685 LIMIT 5 [ RunTime:0.004710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48080685 ORDER BY `minOrder` ASC [ RunTime:0.014894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48080685 ORDER BY `unit` DESC [ RunTime:0.008188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48080685 LIMIT 2 [ RunTime:0.012815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48080685 ORDER BY `minOrder` ASC [ RunTime:0.005244s ]
select * from pdf where partno='5228979-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228979-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011805s ]
SELECT `id` FROM `stock` WHERE `id` <> 48080685 AND `partno` = '5228979-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681595 [ RunTime:0.011156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35271173 LIMIT 5 [ RunTime:0.005428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35271173 ORDER BY `minOrder` ASC [ RunTime:0.009105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35271173 ORDER BY `unit` DESC [ RunTime:0.003266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35271173 LIMIT 2 [ RunTime:0.005363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35271173 ORDER BY `minOrder` ASC [ RunTime:0.003301s ]
select * from pdf where partno='5228979-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228979-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014883s ]
SELECT `id` FROM `stock` WHERE `id` <> 35271173 AND `partno` = '5228979-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.021139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681595 [ RunTime:0.019750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58134526 LIMIT 5 [ RunTime:0.019649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134526 ORDER BY `minOrder` ASC [ RunTime:0.016280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58134526 ORDER BY `unit` DESC [ RunTime:0.013572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58134526 LIMIT 2 [ RunTime:0.010261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134526 ORDER BY `minOrder` ASC [ RunTime:0.004196s ]
select * from pdf where partno='5228' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.017391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.023195s ]
SELECT `id` FROM `stock` WHERE `id` <> 58134526 AND `partno` = '5228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.012849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957403 [ RunTime:0.015963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57404876 LIMIT 5 [ RunTime:0.022949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57404876 ORDER BY `minOrder` ASC [ RunTime:0.007850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57404876 ORDER BY `unit` DESC [ RunTime:0.001648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57404876 LIMIT 2 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57404876 ORDER BY `minOrder` ASC [ RunTime:0.002477s ]
select * from pdf where partno='5228' and brandshort='Laird Technologies EMI' limit 1 [ RunTime:0.006080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228' OR `brand` LIKE 'Laird Technologies EMI%' ) ) LIMIT 1 [ RunTime:0.005980s ]
SELECT `id` FROM `stock` WHERE `id` <> 57404876 AND `partno` = '5228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies emi%' ) [ RunTime:0.002249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55102010 LIMIT 5 [ RunTime:0.001628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55102010 ORDER BY `minOrder` ASC [ RunTime:0.021789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55102010 ORDER BY `unit` DESC [ RunTime:0.022884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55102010 LIMIT 2 [ RunTime:0.012520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55102010 ORDER BY `minOrder` ASC [ RunTime:0.020089s ]
select * from pdf where partno='5228665-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.028995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228665-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002151s ]
SELECT `id` FROM `stock` WHERE `id` <> 55102010 AND `partno` = '5228665-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12873792 [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55097820 LIMIT 5 [ RunTime:0.006753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55097820 ORDER BY `minOrder` ASC [ RunTime:0.020309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55097820 ORDER BY `unit` DESC [ RunTime:0.011194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55097820 LIMIT 2 [ RunTime:0.002918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55097820 ORDER BY `minOrder` ASC [ RunTime:0.002389s ]
select * from pdf where partno='5228979-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228979-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016565s ]
SELECT `id` FROM `stock` WHERE `id` <> 55097820 AND `partno` = '5228979-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872580 [ RunTime:0.034871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55090651 LIMIT 5 [ RunTime:0.040050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090651 ORDER BY `minOrder` ASC [ RunTime:0.036356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55090651 ORDER BY `unit` DESC [ RunTime:0.013283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55090651 LIMIT 2 [ RunTime:0.026220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090651 ORDER BY `minOrder` ASC [ RunTime:0.013693s ]
select * from pdf where partno='5228435-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228435-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.034801s ]
SELECT `id` FROM `stock` WHERE `id` <> 55090651 AND `partno` = '5228435-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55090593 LIMIT 5 [ RunTime:0.002747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090593 ORDER BY `minOrder` ASC [ RunTime:0.026276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55090593 ORDER BY `unit` DESC [ RunTime:0.025329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55090593 LIMIT 2 [ RunTime:0.006904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090593 ORDER BY `minOrder` ASC [ RunTime:0.008583s ]
select * from pdf where partno='5228217-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228217-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006155s ]
SELECT `id` FROM `stock` WHERE `id` <> 55090593 AND `partno` = '5228217-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.040274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55090262 LIMIT 5 [ RunTime:0.019592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090262 ORDER BY `minOrder` ASC [ RunTime:0.007435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55090262 ORDER BY `unit` DESC [ RunTime:0.014357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55090262 LIMIT 2 [ RunTime:0.022150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090262 ORDER BY `minOrder` ASC [ RunTime:0.006481s ]
select * from pdf where partno='5228979-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.029839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228979-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017070s ]
SELECT `id` FROM `stock` WHERE `id` <> 55090262 AND `partno` = '5228979-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.034620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880064 [ RunTime:0.041810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55090249 LIMIT 5 [ RunTime:0.029374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090249 ORDER BY `minOrder` ASC [ RunTime:0.012270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55090249 ORDER BY `unit` DESC [ RunTime:0.009915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55090249 LIMIT 2 [ RunTime:0.028173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55090249 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
select * from pdf where partno='5228980-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5228980-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.030740s ]
SELECT `id` FROM `stock` WHERE `id` <> 55090249 AND `partno` = '5228980-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.057162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880059 [ RunTime:0.017924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53828588 LIMIT 5 [ RunTime:0.014866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53828588 ORDER BY `minOrder` ASC [ RunTime:0.027515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53828588 ORDER BY `unit` DESC [ RunTime:0.021729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53828588 LIMIT 2 [ RunTime:0.012174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53828588 ORDER BY `minOrder` ASC [ RunTime:0.016177s ]
select * from pdf where partno='52289' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '52289' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013371s ]
SELECT `id` FROM `stock` WHERE `id` <> 53828588 AND `partno` = '52289' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416154 [ RunTime:0.020056s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004562s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015119s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017778s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014826s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004229s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016703s ]
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 '5228%' OR `brand` LIKE '5228%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031105s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5228%' OR `brand` LIKE '5228%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011499s ]