SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001338s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=579&search=1' [ RunTime:0.017436s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001815s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001132s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001533s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.008928s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001137s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008052s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001280s ]
SELECT * FROM `stock_search` WHERE `partno` = '579' LIMIT 1 [ RunTime:0.056103s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-24 04:05:38' WHERE `partno` = '579' [ RunTime:0.010739s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001871s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059829s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.027012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205123 LIMIT 5 [ RunTime:0.060257s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205123 ORDER BY `minOrder` ASC [ RunTime:0.066982s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16205123 ORDER BY `unit` DESC [ RunTime:0.055436s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16205123 LIMIT 2 [ RunTime:0.066520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205123 ORDER BY `minOrder` ASC [ RunTime:0.033773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621935 LIMIT 5 [ RunTime:0.062436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621935 ORDER BY `minOrder` ASC [ RunTime:0.051600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621935 ORDER BY `unit` DESC [ RunTime:0.058559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621935 LIMIT 2 [ RunTime:0.177034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621935 ORDER BY `minOrder` ASC [ RunTime:0.046205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621754 LIMIT 5 [ RunTime:0.049253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621754 ORDER BY `minOrder` ASC [ RunTime:0.196306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621754 ORDER BY `unit` DESC [ RunTime:0.044014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621754 LIMIT 2 [ RunTime:0.068637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621754 ORDER BY `minOrder` ASC [ RunTime:0.015895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621523 LIMIT 5 [ RunTime:0.115270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621523 ORDER BY `minOrder` ASC [ RunTime:0.104244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621523 ORDER BY `unit` DESC [ RunTime:0.035990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621523 LIMIT 2 [ RunTime:0.040760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621523 ORDER BY `minOrder` ASC [ RunTime:0.018366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621397 LIMIT 5 [ RunTime:0.038382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621397 ORDER BY `minOrder` ASC [ RunTime:0.029618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621397 ORDER BY `unit` DESC [ RunTime:0.006497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621397 LIMIT 2 [ RunTime:0.087950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621397 ORDER BY `minOrder` ASC [ RunTime:0.042577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621396 LIMIT 5 [ RunTime:0.022375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621396 ORDER BY `minOrder` ASC [ RunTime:0.021638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12621396 ORDER BY `unit` DESC [ RunTime:0.010495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12621396 LIMIT 2 [ RunTime:0.042680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12621396 ORDER BY `minOrder` ASC [ RunTime:0.020571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11490165 LIMIT 5 [ RunTime:0.007486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11490165 ORDER BY `minOrder` ASC [ RunTime:0.013754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11490165 ORDER BY `unit` DESC [ RunTime:0.029848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11490165 LIMIT 2 [ RunTime:0.012518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11490165 ORDER BY `minOrder` ASC [ RunTime:0.030652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489844 LIMIT 5 [ RunTime:0.016259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489844 ORDER BY `minOrder` ASC [ RunTime:0.026068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489844 ORDER BY `unit` DESC [ RunTime:0.011579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489844 LIMIT 2 [ RunTime:0.023661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489844 ORDER BY `minOrder` ASC [ RunTime:0.008731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489843 LIMIT 5 [ RunTime:0.008778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489843 ORDER BY `minOrder` ASC [ RunTime:0.009918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489843 ORDER BY `unit` DESC [ RunTime:0.015356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489843 LIMIT 2 [ RunTime:0.009414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489843 ORDER BY `minOrder` ASC [ RunTime:0.010421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489760 LIMIT 5 [ RunTime:0.017921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489760 ORDER BY `minOrder` ASC [ RunTime:0.013742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489760 ORDER BY `unit` DESC [ RunTime:0.023400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489760 LIMIT 2 [ RunTime:0.001653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489760 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489447 LIMIT 5 [ RunTime:0.012009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489447 ORDER BY `minOrder` ASC [ RunTime:0.008474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489447 ORDER BY `unit` DESC [ RunTime:0.007799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489447 LIMIT 2 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489447 ORDER BY `minOrder` ASC [ RunTime:0.006214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11490020 LIMIT 5 [ RunTime:0.013705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11490020 ORDER BY `minOrder` ASC [ RunTime:0.006388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11490020 ORDER BY `unit` DESC [ RunTime:0.042181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11490020 LIMIT 2 [ RunTime:0.015549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11490020 ORDER BY `minOrder` ASC [ RunTime:0.021859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486306 LIMIT 5 [ RunTime:0.026891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486306 ORDER BY `minOrder` ASC [ RunTime:0.043761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486306 ORDER BY `unit` DESC [ RunTime:0.013135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486306 LIMIT 2 [ RunTime:0.037204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486306 ORDER BY `minOrder` ASC [ RunTime:0.019396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415280 LIMIT 5 [ RunTime:0.024017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415280 ORDER BY `minOrder` ASC [ RunTime:0.047067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16415280 ORDER BY `unit` DESC [ RunTime:0.017336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16415280 LIMIT 2 [ RunTime:0.022336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415280 ORDER BY `minOrder` ASC [ RunTime:0.011723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11861108 LIMIT 5 [ RunTime:0.072862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11861108 ORDER BY `minOrder` ASC [ RunTime:0.095784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11861108 ORDER BY `unit` DESC [ RunTime:0.038507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11861108 LIMIT 2 [ RunTime:0.026877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11861108 ORDER BY `minOrder` ASC [ RunTime:0.009445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18634240 LIMIT 5 [ RunTime:0.022115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18634240 ORDER BY `minOrder` ASC [ RunTime:0.047825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18634240 ORDER BY `unit` DESC [ RunTime:0.022747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18634240 LIMIT 2 [ RunTime:0.034439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18634240 ORDER BY `minOrder` ASC [ RunTime:0.021460s ]
select * from pdf where partno='579402B00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.015340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18634178 LIMIT 5 [ RunTime:0.015119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18634178 ORDER BY `minOrder` ASC [ RunTime:0.039083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18634178 ORDER BY `unit` DESC [ RunTime:0.043675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18634178 LIMIT 2 [ RunTime:0.031784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18634178 ORDER BY `minOrder` ASC [ RunTime:0.031042s ]
select * from pdf where partno='579302B00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.045619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616684 LIMIT 5 [ RunTime:0.019613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616684 ORDER BY `minOrder` ASC [ RunTime:0.043831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616684 ORDER BY `unit` DESC [ RunTime:0.004691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616684 LIMIT 2 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616684 ORDER BY `minOrder` ASC [ RunTime:0.008108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616677 LIMIT 5 [ RunTime:0.023848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616677 ORDER BY `minOrder` ASC [ RunTime:0.054429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616677 ORDER BY `unit` DESC [ RunTime:0.020894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616677 LIMIT 2 [ RunTime:0.022047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616677 ORDER BY `minOrder` ASC [ RunTime:0.020246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616667 LIMIT 5 [ RunTime:0.013041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616667 ORDER BY `minOrder` ASC [ RunTime:0.027622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616667 ORDER BY `unit` DESC [ RunTime:0.020770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616667 LIMIT 2 [ RunTime:0.038717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616667 ORDER BY `minOrder` ASC [ RunTime:0.021778s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290564 LIMIT 5 [ RunTime:0.021240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290564 ORDER BY `minOrder` ASC [ RunTime:0.059030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290564 ORDER BY `unit` DESC [ RunTime:0.000704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290564 LIMIT 2 [ RunTime:0.028105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290564 ORDER BY `minOrder` ASC [ RunTime:0.004505s ]
select * from pdf where partno='579103b00000g' and brandshort='aavid' limit 1 [ RunTime:0.029816s ]
select foldpath,foldpath2,filename from pdf_file where id=1219126 limit 1 [ RunTime:0.039024s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.005090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '579103b00000g' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.023339s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290564 AND `partno` = '579103b00000g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.034752s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944278 LIMIT 5 [ RunTime:0.026425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944278 ORDER BY `minOrder` ASC [ RunTime:0.032917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944278 ORDER BY `unit` DESC [ RunTime:0.011120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944278 LIMIT 2 [ RunTime:0.013291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944278 ORDER BY `minOrder` ASC [ RunTime:0.016393s ]
select * from pdf where partno='57960-024H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.034304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-024H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.041815s ]
SELECT `id` FROM `stock` WHERE `id` <> 59944278 AND `partno` = '57960-024H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.027112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943985 LIMIT 5 [ RunTime:0.029685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943985 ORDER BY `minOrder` ASC [ RunTime:0.058361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943985 ORDER BY `unit` DESC [ RunTime:0.038839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943985 LIMIT 2 [ RunTime:0.023551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943985 ORDER BY `minOrder` ASC [ RunTime:0.006727s ]
select * from pdf where partno='57960-012H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.020948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-012H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.028604s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943985 AND `partno` = '57960-012H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.055495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489843 [ RunTime:0.005497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943893 LIMIT 5 [ RunTime:0.024717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943893 ORDER BY `minOrder` ASC [ RunTime:0.054150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943893 ORDER BY `unit` DESC [ RunTime:0.044680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943893 LIMIT 2 [ RunTime:0.061264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943893 ORDER BY `minOrder` ASC [ RunTime:0.012502s ]
select * from pdf where partno='57960-006H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.018260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-006H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.017130s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943893 AND `partno` = '57960-006H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.052763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621397 [ RunTime:0.032698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59456984 LIMIT 5 [ RunTime:0.044715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59456984 ORDER BY `minOrder` ASC [ RunTime:0.022403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59456984 ORDER BY `unit` DESC [ RunTime:0.014567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59456984 LIMIT 2 [ RunTime:0.014517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59456984 ORDER BY `minOrder` ASC [ RunTime:0.004963s ]
select * from pdf where partno='57959-0062N-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.029560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57959-0062N-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.017995s ]
SELECT `id` FROM `stock` WHERE `id` <> 59456984 AND `partno` = '57959-0062N-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.027326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205123 [ RunTime:0.030166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944252 LIMIT 5 [ RunTime:0.012920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944252 ORDER BY `minOrder` ASC [ RunTime:0.016351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944252 ORDER BY `unit` DESC [ RunTime:0.026530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944252 LIMIT 2 [ RunTime:0.028669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944252 ORDER BY `minOrder` ASC [ RunTime:0.010073s ]
select * from pdf where partno='57960-024H0H1-002' and brandshort='Aces Connectors' limit 1 [ RunTime:0.013680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-024H0H1-002' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.038184s ]
SELECT `id` FROM `stock` WHERE `id` <> 59944252 AND `partno` = '57960-024H0H1-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.066070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944187 LIMIT 5 [ RunTime:0.028467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944187 ORDER BY `minOrder` ASC [ RunTime:0.052347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944187 ORDER BY `unit` DESC [ RunTime:0.012833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944187 LIMIT 2 [ RunTime:0.014931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944187 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
select * from pdf where partno='57960-018H0H1-002' and brandshort='Aces Connectors' limit 1 [ RunTime:0.013734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-018H0H1-002' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.040810s ]
SELECT `id` FROM `stock` WHERE `id` <> 59944187 AND `partno` = '57960-018H0H1-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.033097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11490165 [ RunTime:0.029176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943986 LIMIT 5 [ RunTime:0.003013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943986 ORDER BY `minOrder` ASC [ RunTime:0.015790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943986 ORDER BY `unit` DESC [ RunTime:0.009441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943986 LIMIT 2 [ RunTime:0.026377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943986 ORDER BY `minOrder` ASC [ RunTime:0.006850s ]
select * from pdf where partno='57960-016H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.002837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-016H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.009725s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943986 AND `partno` = '57960-016H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.014536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621754 [ RunTime:0.009543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943968 LIMIT 5 [ RunTime:0.008868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943968 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943968 ORDER BY `unit` DESC [ RunTime:0.011010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943968 LIMIT 2 [ RunTime:0.008907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943968 ORDER BY `minOrder` ASC [ RunTime:0.028338s ]
select * from pdf where partno='57960-014H0H1-002' and brandshort='Aces Connectors' limit 1 [ RunTime:0.016226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-014H0H1-002' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.005965s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943968 AND `partno` = '57960-014H0H1-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.004747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489844 [ RunTime:0.014368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943967 LIMIT 5 [ RunTime:0.021643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943967 ORDER BY `minOrder` ASC [ RunTime:0.024014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943967 ORDER BY `unit` DESC [ RunTime:0.003879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943967 LIMIT 2 [ RunTime:0.015730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943967 ORDER BY `minOrder` ASC [ RunTime:0.006553s ]
select * from pdf where partno='57960-010H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-010H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.002211s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943967 AND `partno` = '57960-010H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.007832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621523 [ RunTime:0.011668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943935 LIMIT 5 [ RunTime:0.018232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943935 ORDER BY `minOrder` ASC [ RunTime:0.010171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943935 ORDER BY `unit` DESC [ RunTime:0.010267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943935 LIMIT 2 [ RunTime:0.016959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943935 ORDER BY `minOrder` ASC [ RunTime:0.017868s ]
select * from pdf where partno='57960-012H0H1-002' and brandshort='Aces Connectors' limit 1 [ RunTime:0.002088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-012H0H1-002' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.007552s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943935 AND `partno` = '57960-012H0H1-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.025915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943895 LIMIT 5 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943895 ORDER BY `minOrder` ASC [ RunTime:0.003037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943895 ORDER BY `unit` DESC [ RunTime:0.005960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943895 LIMIT 2 [ RunTime:0.019020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943895 ORDER BY `minOrder` ASC [ RunTime:0.004900s ]
select * from pdf where partno='57960-014H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.008901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-014H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.005436s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943895 AND `partno` = '57960-014H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.018979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489760 [ RunTime:0.001984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943894 LIMIT 5 [ RunTime:0.026692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943894 ORDER BY `minOrder` ASC [ RunTime:0.007629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943894 ORDER BY `unit` DESC [ RunTime:0.009449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943894 LIMIT 2 [ RunTime:0.010585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943894 ORDER BY `minOrder` ASC [ RunTime:0.006105s ]
select * from pdf where partno='57960-004H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.000734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-004H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.012551s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943894 AND `partno` = '57960-004H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.010876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621396 [ RunTime:0.030455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943702 LIMIT 5 [ RunTime:0.005636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943702 ORDER BY `minOrder` ASC [ RunTime:0.016825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943702 ORDER BY `unit` DESC [ RunTime:0.019006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943702 LIMIT 2 [ RunTime:0.113459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943702 ORDER BY `minOrder` ASC [ RunTime:0.027744s ]
select * from pdf where partno='57960-002H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.055524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-002H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.054100s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943702 AND `partno` = '57960-002H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.011679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489447 [ RunTime:0.035441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944105 LIMIT 5 [ RunTime:0.069548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944105 ORDER BY `minOrder` ASC [ RunTime:0.091045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944105 ORDER BY `unit` DESC [ RunTime:0.017060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944105 LIMIT 2 [ RunTime:0.003076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944105 ORDER BY `minOrder` ASC [ RunTime:0.006167s ]
select * from pdf where partno='57960-020H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.009806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-020H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.022815s ]
SELECT `id` FROM `stock` WHERE `id` <> 59944105 AND `partno` = '57960-020H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.014834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12621935 [ RunTime:0.026315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944086 LIMIT 5 [ RunTime:0.022294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944086 ORDER BY `minOrder` ASC [ RunTime:0.013134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944086 ORDER BY `unit` DESC [ RunTime:0.020207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944086 LIMIT 2 [ RunTime:0.011390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944086 ORDER BY `minOrder` ASC [ RunTime:0.009950s ]
select * from pdf where partno='57960-018H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.012605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-018H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.013344s ]
SELECT `id` FROM `stock` WHERE `id` <> 59944086 AND `partno` = '57960-018H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.021780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11490020 [ RunTime:0.026947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59472584 LIMIT 5 [ RunTime:0.006281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59472584 ORDER BY `minOrder` ASC [ RunTime:0.020370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59472584 ORDER BY `unit` DESC [ RunTime:0.010257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59472584 LIMIT 2 [ RunTime:0.011673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59472584 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
select * from pdf where partno='57965-0040N-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.008311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57965-0040N-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.020813s ]
SELECT `id` FROM `stock` WHERE `id` <> 59472584 AND `partno` = '57965-0040N-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.022548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486306 [ RunTime:0.019731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64573718 LIMIT 5 [ RunTime:0.004665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573718 ORDER BY `minOrder` ASC [ RunTime:0.022271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64573718 ORDER BY `unit` DESC [ RunTime:0.012068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64573718 LIMIT 2 [ RunTime:0.023039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573718 ORDER BY `minOrder` ASC [ RunTime:0.021383s ]
select * from pdf where partno='579CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.017407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '579CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004982s ]
SELECT `id` FROM `stock` WHERE `id` <> 64573718 AND `partno` = '579CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.012093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344559 [ RunTime:0.021103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884504 LIMIT 5 [ RunTime:0.029671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884504 ORDER BY `minOrder` ASC [ RunTime:0.043912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884504 ORDER BY `unit` DESC [ RunTime:0.033873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884504 LIMIT 2 [ RunTime:0.021752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884504 ORDER BY `minOrder` ASC [ RunTime:0.008439s ]
select * from pdf where partno='579402B00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.004359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '579402B00000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.037373s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884504 AND `partno` = '579402B00000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.020858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18634240 [ RunTime:0.028880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943942 LIMIT 5 [ RunTime:0.017234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943942 ORDER BY `minOrder` ASC [ RunTime:0.014853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943942 ORDER BY `unit` DESC [ RunTime:0.034241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943942 LIMIT 2 [ RunTime:0.017106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943942 ORDER BY `minOrder` ASC [ RunTime:0.001649s ]
select * from pdf where partno='57958-012H0H1-001' and brandshort='Aces Connectors' limit 1 [ RunTime:0.015440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57958-012H0H1-001' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.015806s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943942 AND `partno` = '57958-012H0H1-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.035665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616684 [ RunTime:0.007595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59943941 LIMIT 5 [ RunTime:0.005937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943941 ORDER BY `minOrder` ASC [ RunTime:0.004923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59943941 ORDER BY `unit` DESC [ RunTime:0.015698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59943941 LIMIT 2 [ RunTime:0.030470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59943941 ORDER BY `minOrder` ASC [ RunTime:0.022367s ]
select * from pdf where partno='57960-010H0H1-002' and brandshort='Aces Connectors' limit 1 [ RunTime:0.007798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57960-010H0H1-002' OR `brand` LIKE 'Aces Connectors%' ) ) LIMIT 1 [ RunTime:0.028965s ]
SELECT `id` FROM `stock` WHERE `id` <> 59943941 AND `partno` = '57960-010H0H1-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aces connectors%' ) [ RunTime:0.031367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486187 [ RunTime:0.036576s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008656s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025295s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019103s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017645s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019301s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023117s ]
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 '579%' OR `brand` LIKE '579%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016107s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '579%' OR `brand` LIKE '579%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.038455s ]