SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002581s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=10436&search=1' [ RunTime:0.045459s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001121s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.056669s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002482s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.030130s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001470s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016570s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001575s ]
SELECT * FROM `stock_search` WHERE `partno` = '10436' LIMIT 1 [ RunTime:0.028976s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-30 09:08:16' WHERE `partno` = '10436' [ RunTime:0.027446s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002656s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093396s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.025687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16487851 LIMIT 5 [ RunTime:0.105889s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487851 ORDER BY `minOrder` ASC [ RunTime:0.045900s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.016181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16487851 ORDER BY `unit` DESC [ RunTime:0.009886s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16487851 LIMIT 2 [ RunTime:0.105358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16487851 ORDER BY `minOrder` ASC [ RunTime:0.039643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773143 LIMIT 5 [ RunTime:0.043256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773143 ORDER BY `minOrder` ASC [ RunTime:0.041217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773143 ORDER BY `unit` DESC [ RunTime:0.031490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773143 LIMIT 2 [ RunTime:0.055733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773143 ORDER BY `minOrder` ASC [ RunTime:0.042678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347611 LIMIT 5 [ RunTime:0.054346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347611 ORDER BY `minOrder` ASC [ RunTime:0.079121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347611 ORDER BY `unit` DESC [ RunTime:0.013227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347611 LIMIT 2 [ RunTime:0.029155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347611 ORDER BY `minOrder` ASC [ RunTime:0.021168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12665815 LIMIT 5 [ RunTime:0.027085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12665815 ORDER BY `minOrder` ASC [ RunTime:0.034219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12665815 ORDER BY `unit` DESC [ RunTime:0.054885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12665815 LIMIT 2 [ RunTime:0.056742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12665815 ORDER BY `minOrder` ASC [ RunTime:0.003439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19818956 LIMIT 5 [ RunTime:0.050259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818956 ORDER BY `minOrder` ASC [ RunTime:0.046793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19818956 ORDER BY `unit` DESC [ RunTime:0.055046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19818956 LIMIT 2 [ RunTime:0.057016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818956 ORDER BY `minOrder` ASC [ RunTime:0.030655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680487 LIMIT 5 [ RunTime:0.032524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680487 ORDER BY `minOrder` ASC [ RunTime:0.045285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680487 ORDER BY `unit` DESC [ RunTime:0.065368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680487 LIMIT 2 [ RunTime:0.035929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680487 ORDER BY `minOrder` ASC [ RunTime:0.015150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646600 LIMIT 5 [ RunTime:0.036450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646600 ORDER BY `minOrder` ASC [ RunTime:0.032744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12646600 ORDER BY `unit` DESC [ RunTime:0.034263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12646600 LIMIT 2 [ RunTime:0.018115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646600 ORDER BY `minOrder` ASC [ RunTime:0.010789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12560742 LIMIT 5 [ RunTime:0.036695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12560742 ORDER BY `minOrder` ASC [ RunTime:0.045553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12560742 ORDER BY `unit` DESC [ RunTime:0.033054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12560742 LIMIT 2 [ RunTime:0.016020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12560742 ORDER BY `minOrder` ASC [ RunTime:0.011835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307641 LIMIT 5 [ RunTime:0.032175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307641 ORDER BY `minOrder` ASC [ RunTime:0.025663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17307641 ORDER BY `unit` DESC [ RunTime:0.063011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17307641 LIMIT 2 [ RunTime:0.051403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307641 ORDER BY `minOrder` ASC [ RunTime:0.007598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12666905 LIMIT 5 [ RunTime:0.035888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12666905 ORDER BY `minOrder` ASC [ RunTime:0.010180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12666905 ORDER BY `unit` DESC [ RunTime:0.037097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12666905 LIMIT 2 [ RunTime:0.029620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12666905 ORDER BY `minOrder` ASC [ RunTime:0.018396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958197 LIMIT 5 [ RunTime:0.078423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11958197 ORDER BY `minOrder` ASC [ RunTime:0.045187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11958197 ORDER BY `unit` DESC [ RunTime:0.045113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11958197 LIMIT 2 [ RunTime:0.056906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11958197 ORDER BY `minOrder` ASC [ RunTime:0.007267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792060 LIMIT 5 [ RunTime:0.030508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792060 ORDER BY `minOrder` ASC [ RunTime:0.039161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792060 ORDER BY `unit` DESC [ RunTime:0.022736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792060 LIMIT 2 [ RunTime:0.026002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792060 ORDER BY `minOrder` ASC [ RunTime:0.014809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834660 LIMIT 5 [ RunTime:0.021155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834660 ORDER BY `minOrder` ASC [ RunTime:0.013778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19834660 ORDER BY `unit` DESC [ RunTime:0.014597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19834660 LIMIT 2 [ RunTime:0.011062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834660 ORDER BY `minOrder` ASC [ RunTime:0.009245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19824586 LIMIT 5 [ RunTime:0.009694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19824586 ORDER BY `minOrder` ASC [ RunTime:0.018519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19824586 ORDER BY `unit` DESC [ RunTime:0.039713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19824586 LIMIT 2 [ RunTime:0.013125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19824586 ORDER BY `minOrder` ASC [ RunTime:0.012254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19820507 LIMIT 5 [ RunTime:0.033613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19820507 ORDER BY `minOrder` ASC [ RunTime:0.051981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19820507 ORDER BY `unit` DESC [ RunTime:0.020615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19820507 LIMIT 2 [ RunTime:0.025302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19820507 ORDER BY `minOrder` ASC [ RunTime:0.016551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19818448 LIMIT 5 [ RunTime:0.027041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818448 ORDER BY `minOrder` ASC [ RunTime:0.024338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19818448 ORDER BY `unit` DESC [ RunTime:0.017434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19818448 LIMIT 2 [ RunTime:0.016683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19818448 ORDER BY `minOrder` ASC [ RunTime:0.002911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19817567 LIMIT 5 [ RunTime:0.017498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19817567 ORDER BY `minOrder` ASC [ RunTime:0.017423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19817567 ORDER BY `unit` DESC [ RunTime:0.030235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19817567 LIMIT 2 [ RunTime:0.068899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19817567 ORDER BY `minOrder` ASC [ RunTime:0.018968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19816583 LIMIT 5 [ RunTime:0.052260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816583 ORDER BY `minOrder` ASC [ RunTime:0.039149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19816583 ORDER BY `unit` DESC [ RunTime:0.065960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19816583 LIMIT 2 [ RunTime:0.001688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816583 ORDER BY `minOrder` ASC [ RunTime:0.010767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19814867 LIMIT 5 [ RunTime:0.048465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19814867 ORDER BY `minOrder` ASC [ RunTime:0.047355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19814867 ORDER BY `unit` DESC [ RunTime:0.061810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19814867 LIMIT 2 [ RunTime:0.042066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19814867 ORDER BY `minOrder` ASC [ RunTime:0.005853s ]
select * from pdf where partno='104362-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19779704 LIMIT 5 [ RunTime:0.030886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19779704 ORDER BY `minOrder` ASC [ RunTime:0.034847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19779704 ORDER BY `unit` DESC [ RunTime:0.023804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19779704 LIMIT 2 [ RunTime:0.024582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19779704 ORDER BY `minOrder` ASC [ RunTime:0.011467s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026742s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56148257 LIMIT 5 [ RunTime:0.018218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56148257 ORDER BY `minOrder` ASC [ RunTime:0.015281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56148257 ORDER BY `unit` DESC [ RunTime:0.007588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56148257 LIMIT 2 [ RunTime:0.024340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56148257 ORDER BY `minOrder` ASC [ RunTime:0.003343s ]
select * from pdf where partno='10436-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.011640s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10436-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.017936s ]
SELECT `id` FROM `stock` WHERE `id` <> 56148257 AND `partno` = '10436-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.024923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16487851 [ RunTime:0.012542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53088428 LIMIT 5 [ RunTime:0.016871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53088428 ORDER BY `minOrder` ASC [ RunTime:0.023547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53088428 ORDER BY `unit` DESC [ RunTime:0.022899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53088428 LIMIT 2 [ RunTime:0.032874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53088428 ORDER BY `minOrder` ASC [ RunTime:0.014912s ]
select * from pdf where partno='104363-4' and brandshort='TE Connectivity' limit 1 [ RunTime:0.036029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104363-4' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.045881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52588271 LIMIT 5 [ RunTime:0.023199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52588271 ORDER BY `minOrder` ASC [ RunTime:0.030743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52588271 ORDER BY `unit` DESC [ RunTime:0.024893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52588271 LIMIT 2 [ RunTime:0.036008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52588271 ORDER BY `minOrder` ASC [ RunTime:0.024895s ]
select * from pdf where partno='104361-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.044654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104361-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007407s ]
SELECT `id` FROM `stock` WHERE `id` <> 52588271 AND `partno` = '104361-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773143 [ RunTime:0.035321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52618116 LIMIT 5 [ RunTime:0.017212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52618116 ORDER BY `minOrder` ASC [ RunTime:0.034331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52618116 ORDER BY `unit` DESC [ RunTime:0.015649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52618116 LIMIT 2 [ RunTime:0.016429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52618116 ORDER BY `minOrder` ASC [ RunTime:0.005507s ]
select * from pdf where partno='104361-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.042313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104361-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.058829s ]
SELECT `id` FROM `stock` WHERE `id` <> 52618116 AND `partno` = '104361-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.022917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19820507 [ RunTime:0.031687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57737496 LIMIT 5 [ RunTime:0.025974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737496 ORDER BY `minOrder` ASC [ RunTime:0.033295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57737496 ORDER BY `unit` DESC [ RunTime:0.012942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57737496 LIMIT 2 [ RunTime:0.001715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737496 ORDER BY `minOrder` ASC [ RunTime:0.004679s ]
select * from pdf where partno='10436CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.016125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10436CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.018185s ]
SELECT `id` FROM `stock` WHERE `id` <> 57737496 AND `partno` = '10436CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347611 [ RunTime:0.004454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52890108 LIMIT 5 [ RunTime:0.018572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890108 ORDER BY `minOrder` ASC [ RunTime:0.021197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52890108 ORDER BY `unit` DESC [ RunTime:0.025203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52890108 LIMIT 2 [ RunTime:0.016022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890108 ORDER BY `minOrder` ASC [ RunTime:0.009668s ]
select * from pdf where partno='1043685' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.024842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043685' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52615334 LIMIT 5 [ RunTime:0.045304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52615334 ORDER BY `minOrder` ASC [ RunTime:0.032550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52615334 ORDER BY `unit` DESC [ RunTime:0.031649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52615334 LIMIT 2 [ RunTime:0.034763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52615334 ORDER BY `minOrder` ASC [ RunTime:0.018993s ]
select * from pdf where partno='104363-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104363-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009597s ]
SELECT `id` FROM `stock` WHERE `id` <> 52615334 AND `partno` = '104363-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19818956 [ RunTime:0.021373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52607223 LIMIT 5 [ RunTime:0.026676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52607223 ORDER BY `minOrder` ASC [ RunTime:0.016642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52607223 ORDER BY `unit` DESC [ RunTime:0.015618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52607223 LIMIT 2 [ RunTime:0.020730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52607223 ORDER BY `minOrder` ASC [ RunTime:0.016420s ]
select * from pdf where partno='104361-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.061098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104361-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.015273s ]
SELECT `id` FROM `stock` WHERE `id` <> 52607223 AND `partno` = '104361-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.040971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485960 [ RunTime:0.059535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52890009 LIMIT 5 [ RunTime:0.030473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890009 ORDER BY `minOrder` ASC [ RunTime:0.012932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52890009 ORDER BY `unit` DESC [ RunTime:0.018392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52890009 LIMIT 2 [ RunTime:0.011943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890009 ORDER BY `minOrder` ASC [ RunTime:0.004263s ]
select * from pdf where partno='1043684' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043684' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667682 LIMIT 5 [ RunTime:0.031299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667682 ORDER BY `minOrder` ASC [ RunTime:0.018087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667682 ORDER BY `unit` DESC [ RunTime:0.024323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667682 LIMIT 2 [ RunTime:0.033127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667682 ORDER BY `minOrder` ASC [ RunTime:0.022648s ]
select * from pdf where partno='1043670000' and brandshort='Weidmüller' limit 1 [ RunTime:0.024452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043670000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.026748s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667682 AND `partno` = '1043670000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12560742 [ RunTime:0.007337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667840 LIMIT 5 [ RunTime:0.024575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667840 ORDER BY `minOrder` ASC [ RunTime:0.025209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667840 ORDER BY `unit` DESC [ RunTime:0.021182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667840 LIMIT 2 [ RunTime:0.049088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667840 ORDER BY `minOrder` ASC [ RunTime:0.006990s ]
select * from pdf where partno='1043600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011315s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667840 AND `partno` = '1043600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.025818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52917157 LIMIT 5 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52917157 ORDER BY `minOrder` ASC [ RunTime:0.007877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52917157 ORDER BY `unit` DESC [ RunTime:0.009352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52917157 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52917157 ORDER BY `minOrder` ASC [ RunTime:0.003055s ]
select * from pdf where partno='1043682' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043682' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.062794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667884 LIMIT 5 [ RunTime:0.011996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667884 ORDER BY `minOrder` ASC [ RunTime:0.011364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667884 ORDER BY `unit` DESC [ RunTime:0.027579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667884 LIMIT 2 [ RunTime:0.019547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667884 ORDER BY `minOrder` ASC [ RunTime:0.015582s ]
select * from pdf where partno='1043610000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043610000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.020027s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667884 AND `partno` = '1043610000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.023919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667794 LIMIT 5 [ RunTime:0.072110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667794 ORDER BY `minOrder` ASC [ RunTime:0.098347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667794 ORDER BY `unit` DESC [ RunTime:0.073993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667794 LIMIT 2 [ RunTime:0.073436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667794 ORDER BY `minOrder` ASC [ RunTime:0.043508s ]
select * from pdf where partno='1043680000' and brandshort='Weidmüller' limit 1 [ RunTime:0.050972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043680000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.051811s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667794 AND `partno` = '1043680000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.068182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307641 [ RunTime:0.050356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667811 LIMIT 5 [ RunTime:0.021393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667811 ORDER BY `minOrder` ASC [ RunTime:0.061293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667811 ORDER BY `unit` DESC [ RunTime:0.040430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667811 LIMIT 2 [ RunTime:0.024412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667811 ORDER BY `minOrder` ASC [ RunTime:0.025122s ]
select * from pdf where partno='1043620000' and brandshort='Weidmüller' limit 1 [ RunTime:0.052248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043620000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.092287s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667811 AND `partno` = '1043620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.071913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667863 LIMIT 5 [ RunTime:0.038697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667863 ORDER BY `minOrder` ASC [ RunTime:0.040744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667863 ORDER BY `unit` DESC [ RunTime:0.028049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667863 LIMIT 2 [ RunTime:0.015760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667863 ORDER BY `minOrder` ASC [ RunTime:0.021933s ]
select * from pdf where partno='1043690000' and brandshort='Weidmüller' limit 1 [ RunTime:0.035251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043690000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013868s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667863 AND `partno` = '1043690000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.048627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57964858 LIMIT 5 [ RunTime:0.019770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57964858 ORDER BY `minOrder` ASC [ RunTime:0.066256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57964858 ORDER BY `unit` DESC [ RunTime:0.053651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57964858 LIMIT 2 [ RunTime:0.024634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57964858 ORDER BY `minOrder` ASC [ RunTime:0.020124s ]
select * from pdf where partno='1043660' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043660' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014380s ]
SELECT `id` FROM `stock` WHERE `id` <> 57964858 AND `partno` = '1043660' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792060 [ RunTime:0.010497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56490846 LIMIT 5 [ RunTime:0.012144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56490846 ORDER BY `minOrder` ASC [ RunTime:0.046154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56490846 ORDER BY `unit` DESC [ RunTime:0.027457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56490846 LIMIT 2 [ RunTime:0.014986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56490846 ORDER BY `minOrder` ASC [ RunTime:0.022270s ]
select * from pdf where partno='1043697' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.055781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1043697' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023402s ]
SELECT `id` FROM `stock` WHERE `id` <> 56490846 AND `partno` = '1043697' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11958197 [ RunTime:0.060684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56569816 LIMIT 5 [ RunTime:0.035915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569816 ORDER BY `minOrder` ASC [ RunTime:0.019759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56569816 ORDER BY `unit` DESC [ RunTime:0.005439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56569816 LIMIT 2 [ RunTime:0.011187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569816 ORDER BY `minOrder` ASC [ RunTime:0.017455s ]
select * from pdf where partno='10436F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.022583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10436F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.015827s ]
SELECT `id` FROM `stock` WHERE `id` <> 56569816 AND `partno` = '10436F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.013603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56569073 LIMIT 5 [ RunTime:0.024183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569073 ORDER BY `minOrder` ASC [ RunTime:0.037371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56569073 ORDER BY `unit` DESC [ RunTime:0.047555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56569073 LIMIT 2 [ RunTime:0.061797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56569073 ORDER BY `minOrder` ASC [ RunTime:0.008738s ]
select * from pdf where partno='10436' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.035490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10436' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.018781s ]
SELECT `id` FROM `stock` WHERE `id` <> 56569073 AND `partno` = '10436' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.011057s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054469s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048689s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048406s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023564s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019375s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027522s ]
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 '10436%' OR `brand` LIKE '10436%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036846s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10436%' OR `brand` LIKE '10436%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022019s ]