SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001356s ]
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=714&search=1' [ RunTime:0.004796s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001184s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004880s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002106s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001540s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001750s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001372s ]
SELECT * FROM `stock_search` WHERE `partno` = '714' LIMIT 1 [ RunTime:0.000660s ]
UPDATE `stock_search` SET `count` = 150 , `updatetime` = '2026-08-28 16:53:12' WHERE `partno` = '714' [ RunTime:0.002793s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002026s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.154885s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351108 LIMIT 5 [ RunTime:0.006254s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351108 ORDER BY `minOrder` ASC [ RunTime:0.001362s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351108 ORDER BY `unit` DESC [ RunTime:0.010501s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351108 LIMIT 2 [ RunTime:0.003486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351108 ORDER BY `minOrder` ASC [ RunTime:0.002717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350694 LIMIT 5 [ RunTime:0.013069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350694 ORDER BY `minOrder` ASC [ RunTime:0.017532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350694 ORDER BY `unit` DESC [ RunTime:0.005333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350694 LIMIT 2 [ RunTime:0.004655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350694 ORDER BY `minOrder` ASC [ RunTime:0.001841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351097 LIMIT 5 [ RunTime:0.008541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351097 ORDER BY `minOrder` ASC [ RunTime:0.003188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351097 ORDER BY `unit` DESC [ RunTime:0.008119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351097 LIMIT 2 [ RunTime:0.013023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351097 ORDER BY `minOrder` ASC [ RunTime:0.004038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068166 LIMIT 5 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068166 ORDER BY `minOrder` ASC [ RunTime:0.009588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068166 ORDER BY `unit` DESC [ RunTime:0.001474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068166 LIMIT 2 [ RunTime:0.005184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068166 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349789 LIMIT 5 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349789 ORDER BY `minOrder` ASC [ RunTime:0.002644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349789 ORDER BY `unit` DESC [ RunTime:0.004268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349789 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349789 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19597353 LIMIT 5 [ RunTime:0.005447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597353 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19597353 ORDER BY `unit` DESC [ RunTime:0.002111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19597353 LIMIT 2 [ RunTime:0.004184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597353 ORDER BY `minOrder` ASC [ RunTime:0.002239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068052 LIMIT 5 [ RunTime:0.007335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068052 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068052 ORDER BY `unit` DESC [ RunTime:0.008237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068052 LIMIT 2 [ RunTime:0.010423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068052 ORDER BY `minOrder` ASC [ RunTime:0.006022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067783 LIMIT 5 [ RunTime:0.012643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067783 ORDER BY `minOrder` ASC [ RunTime:0.001812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067783 ORDER BY `unit` DESC [ RunTime:0.003745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067783 LIMIT 2 [ RunTime:0.002083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067783 ORDER BY `minOrder` ASC [ RunTime:0.018536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350560 LIMIT 5 [ RunTime:0.010604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350560 ORDER BY `minOrder` ASC [ RunTime:0.027818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350560 ORDER BY `unit` DESC [ RunTime:0.015016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350560 LIMIT 2 [ RunTime:0.009530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350560 ORDER BY `minOrder` ASC [ RunTime:0.012572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349677 LIMIT 5 [ RunTime:0.013092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349677 ORDER BY `minOrder` ASC [ RunTime:0.021729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349677 ORDER BY `unit` DESC [ RunTime:0.009279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349677 LIMIT 2 [ RunTime:0.024475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349677 ORDER BY `minOrder` ASC [ RunTime:0.006001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350696 LIMIT 5 [ RunTime:0.015561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350696 ORDER BY `minOrder` ASC [ RunTime:0.008708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350696 ORDER BY `unit` DESC [ RunTime:0.012229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350696 LIMIT 2 [ RunTime:0.016603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350696 ORDER BY `minOrder` ASC [ RunTime:0.003062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068167 LIMIT 5 [ RunTime:0.007057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068167 ORDER BY `minOrder` ASC [ RunTime:0.004114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068167 ORDER BY `unit` DESC [ RunTime:0.011628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068167 LIMIT 2 [ RunTime:0.025287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068167 ORDER BY `minOrder` ASC [ RunTime:0.010635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350958 LIMIT 5 [ RunTime:0.017480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350958 ORDER BY `minOrder` ASC [ RunTime:0.011432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350958 ORDER BY `unit` DESC [ RunTime:0.036796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350958 LIMIT 2 [ RunTime:0.030206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350958 ORDER BY `minOrder` ASC [ RunTime:0.004091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19534122 LIMIT 5 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534122 ORDER BY `minOrder` ASC [ RunTime:0.017281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19534122 ORDER BY `unit` DESC [ RunTime:0.026339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19534122 LIMIT 2 [ RunTime:0.015700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19534122 ORDER BY `minOrder` ASC [ RunTime:0.017633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068401 LIMIT 5 [ RunTime:0.051205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068401 ORDER BY `minOrder` ASC [ RunTime:0.025644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068401 ORDER BY `unit` DESC [ RunTime:0.027670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068401 LIMIT 2 [ RunTime:0.019885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068401 ORDER BY `minOrder` ASC [ RunTime:0.006416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350963 LIMIT 5 [ RunTime:0.030148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350963 ORDER BY `minOrder` ASC [ RunTime:0.042193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350963 ORDER BY `unit` DESC [ RunTime:0.031525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350963 LIMIT 2 [ RunTime:0.018368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350963 ORDER BY `minOrder` ASC [ RunTime:0.001957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350404 LIMIT 5 [ RunTime:0.013902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350404 ORDER BY `minOrder` ASC [ RunTime:0.012858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350404 ORDER BY `unit` DESC [ RunTime:0.147046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350404 LIMIT 2 [ RunTime:0.077998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350404 ORDER BY `minOrder` ASC [ RunTime:0.029947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679201 LIMIT 5 [ RunTime:0.083754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679201 ORDER BY `minOrder` ASC [ RunTime:0.056516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679201 ORDER BY `unit` DESC [ RunTime:0.019151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679201 LIMIT 2 [ RunTime:0.057258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679201 ORDER BY `minOrder` ASC [ RunTime:0.062647s ]
select * from pdf where partno='714-43-103-41-001000' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.056161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067341 LIMIT 5 [ RunTime:0.025135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067341 ORDER BY `minOrder` ASC [ RunTime:0.022378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067341 ORDER BY `unit` DESC [ RunTime:0.036958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067341 LIMIT 2 [ RunTime:0.021043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067341 ORDER BY `minOrder` ASC [ RunTime:0.005133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18634227 LIMIT 5 [ RunTime:0.010199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18634227 ORDER BY `minOrder` ASC [ RunTime:0.021310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18634227 ORDER BY `unit` DESC [ RunTime:0.011290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18634227 LIMIT 2 [ RunTime:0.011722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18634227 ORDER BY `minOrder` ASC [ RunTime:0.011634s ]
select * from pdf where partno='7142DG' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.014060s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268391 LIMIT 5 [ RunTime:0.010273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268391 ORDER BY `minOrder` ASC [ RunTime:0.004181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268391 ORDER BY `unit` DESC [ RunTime:0.004878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268391 LIMIT 2 [ RunTime:0.012749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268391 ORDER BY `minOrder` ASC [ RunTime:0.011435s ]
select * from pdf where partno='71436-0464' and brandshort='molex' limit 1 [ RunTime:0.007976s ]
select foldpath,foldpath2,filename from pdf_file where id=772346 limit 1 [ RunTime:0.004865s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71436-0464' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268373 LIMIT 5 [ RunTime:0.004460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268373 ORDER BY `minOrder` ASC [ RunTime:0.015482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268373 ORDER BY `unit` DESC [ RunTime:0.004736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268373 LIMIT 2 [ RunTime:0.019273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268373 ORDER BY `minOrder` ASC [ RunTime:0.007753s ]
select * from pdf where partno='71436-2864' and brandshort='molex' limit 1 [ RunTime:0.018760s ]
select foldpath,foldpath2,filename from pdf_file where id=830111 limit 1 [ RunTime:0.017553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71436-2864' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.042038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269388 LIMIT 5 [ RunTime:0.005465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269388 ORDER BY `minOrder` ASC [ RunTime:0.010259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269388 ORDER BY `unit` DESC [ RunTime:0.009249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269388 LIMIT 2 [ RunTime:0.009001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269388 ORDER BY `minOrder` ASC [ RunTime:0.001051s ]
select * from pdf where partno='71439-0964' and brandshort='molex' limit 1 [ RunTime:0.010336s ]
select foldpath,foldpath2,filename from pdf_file where id=827395 limit 1 [ RunTime:0.012132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71439-0964' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.025497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269309 LIMIT 5 [ RunTime:0.011421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269309 ORDER BY `minOrder` ASC [ RunTime:0.011319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269309 ORDER BY `unit` DESC [ RunTime:0.001860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269309 LIMIT 2 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269309 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='71436-1164' and brandshort='molex' limit 1 [ RunTime:0.004607s ]
select foldpath,foldpath2,filename from pdf_file where id=772347 limit 1 [ RunTime:0.004325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71436-1164' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.015433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256322 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256322 ORDER BY `minOrder` ASC [ RunTime:0.002602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256322 ORDER BY `unit` DESC [ RunTime:0.001496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256322 LIMIT 2 [ RunTime:0.002932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256322 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
select * from pdf where partno='714-43-102-31-012000' and brandshort='mill-max' limit 1 [ RunTime:0.002679s ]
select foldpath,foldpath2,filename from pdf_file where id=1490434 limit 1 [ RunTime:0.004733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714-43-102-31-012000' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.005978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256140 LIMIT 5 [ RunTime:0.002802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256140 ORDER BY `minOrder` ASC [ RunTime:0.001158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256140 ORDER BY `unit` DESC [ RunTime:0.015082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256140 LIMIT 2 [ RunTime:0.003293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256140 ORDER BY `minOrder` ASC [ RunTime:0.005484s ]
select * from pdf where partno='714-43-103-31-018000' and brandshort='mill-max' limit 1 [ RunTime:0.020946s ]
select foldpath,foldpath2,filename from pdf_file where id=1509867 limit 1 [ RunTime:0.018001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714-43-103-31-018000' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.011779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269232 LIMIT 5 [ RunTime:0.010266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269232 ORDER BY `minOrder` ASC [ RunTime:0.005517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269232 ORDER BY `unit` DESC [ RunTime:0.009061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269232 LIMIT 2 [ RunTime:0.010186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269232 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
select * from pdf where partno='71439-3364' and brandshort='molex' limit 1 [ RunTime:0.011472s ]
select foldpath,foldpath2,filename from pdf_file where id=827476 limit 1 [ RunTime:0.017198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71439-3364' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.022016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51035773 LIMIT 5 [ RunTime:0.016982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51035773 ORDER BY `minOrder` ASC [ RunTime:0.011566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51035773 ORDER BY `unit` DESC [ RunTime:0.012143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51035773 LIMIT 2 [ RunTime:0.001869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51035773 ORDER BY `minOrder` ASC [ RunTime:0.011239s ]
select * from pdf where partno='71421la25pfgi' and brandshort='renesas electronics' limit 1 [ RunTime:0.007214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71421la25pfgi' OR `brand` LIKE 'renesas electronics%' ) ) LIMIT 1 [ RunTime:0.010125s ]
SELECT `id` FROM `stock` WHERE `id` <> 51035773 AND `partno` = '71421la25pfgi' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics%' ) [ RunTime:0.019881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19051446 [ RunTime:0.012363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256335 LIMIT 5 [ RunTime:0.011172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256335 ORDER BY `minOrder` ASC [ RunTime:0.023723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256335 ORDER BY `unit` DESC [ RunTime:0.005226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256335 LIMIT 2 [ RunTime:0.013206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256335 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='714-43-108-31-018000' and brandshort='mill-max' limit 1 [ RunTime:0.005697s ]
select foldpath,foldpath2,filename from pdf_file where id=1509867 limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714-43-108-31-018000' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.002353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302012 LIMIT 5 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302012 ORDER BY `minOrder` ASC [ RunTime:0.001788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302012 ORDER BY `unit` DESC [ RunTime:0.004196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302012 LIMIT 2 [ RunTime:0.004332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302012 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
select * from pdf where partno='7145-1521-002' and brandshort='radiall' limit 1 [ RunTime:0.001441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7145-1521-002' OR `brand` LIKE 'radiall%' ) ) LIMIT 1 [ RunTime:0.010219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274002 LIMIT 5 [ RunTime:0.005871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274002 ORDER BY `minOrder` ASC [ RunTime:0.008834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274002 ORDER BY `unit` DESC [ RunTime:0.004208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274002 LIMIT 2 [ RunTime:0.009556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274002 ORDER BY `minOrder` ASC [ RunTime:0.008983s ]
select * from pdf where partno='7145-1521-002' and brandshort='radiall' limit 1 [ RunTime:0.000610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7145-1521-002' OR `brand` LIKE 'radiall%' ) ) LIMIT 1 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32180566 LIMIT 5 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32180566 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32180566 ORDER BY `unit` DESC [ RunTime:0.003052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32180566 LIMIT 2 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32180566 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='714' and brandshort='keystone electronics' limit 1 [ RunTime:0.005218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.000775s ]
SELECT `id` FROM `stock` WHERE `id` <> 32180566 AND `partno` = '714' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18992150 [ RunTime:0.004620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256072 LIMIT 5 [ RunTime:0.006986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256072 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256072 ORDER BY `unit` DESC [ RunTime:0.016948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256072 LIMIT 2 [ RunTime:0.001092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256072 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
select * from pdf where partno='714-43-164-31-018000' and brandshort='mill-max' limit 1 [ RunTime:0.002158s ]
select foldpath,foldpath2,filename from pdf_file where id=1572757 limit 1 [ RunTime:0.004381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714-43-164-31-018000' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.002493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51106244 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106244 ORDER BY `minOrder` ASC [ RunTime:0.005729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51106244 ORDER BY `unit` DESC [ RunTime:0.001452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51106244 LIMIT 2 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106244 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
select * from pdf where partno='714' and brandshort='adafruit' limit 1 [ RunTime:0.001791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51036165 LIMIT 5 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51036165 ORDER BY `minOrder` ASC [ RunTime:0.012041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51036165 ORDER BY `unit` DESC [ RunTime:0.007486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51036165 LIMIT 2 [ RunTime:0.003912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51036165 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='7140la25pfg' and brandshort='renesas electronics' limit 1 [ RunTime:0.011577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7140la25pfg' OR `brand` LIKE 'renesas electronics%' ) ) LIMIT 1 [ RunTime:0.000761s ]
SELECT `id` FROM `stock` WHERE `id` <> 51036165 AND `partno` = '7140la25pfg' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics%' ) [ RunTime:0.005550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19041211 [ RunTime:0.010531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32233143 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233143 ORDER BY `minOrder` ASC [ RunTime:0.002054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32233143 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32233143 LIMIT 2 [ RunTime:0.008710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32233143 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
select * from pdf where partno='714' and brandshort='jkl components' limit 1 [ RunTime:0.006491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '714' OR `brand` LIKE 'jkl components%' ) ) LIMIT 1 [ RunTime:0.013177s ]
SELECT `id` FROM `stock` WHERE `id` <> 32233143 AND `partno` = '714' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jkl components%' ) [ RunTime:0.002593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867544 [ RunTime:0.003689s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.165497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562462 LIMIT 5 [ RunTime:0.014814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562462 ORDER BY `minOrder` ASC [ RunTime:0.013811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562462 ORDER BY `unit` DESC [ RunTime:0.074332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562462 LIMIT 2 [ RunTime:0.045626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562462 ORDER BY `minOrder` ASC [ RunTime:0.028048s ]
select * from pdf where partno='71489SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.071303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71489SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.040739s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562462 AND `partno` = '71489SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.232433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351120 [ RunTime:0.057490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561171 LIMIT 5 [ RunTime:0.069199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561171 ORDER BY `minOrder` ASC [ RunTime:0.094702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561171 ORDER BY `unit` DESC [ RunTime:0.102927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561171 LIMIT 2 [ RunTime:0.035323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561171 ORDER BY `minOrder` ASC [ RunTime:0.049501s ]
select * from pdf where partno='71456CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.045275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71456CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.055123s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561171 AND `partno` = '71456CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.091185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067605 [ RunTime:0.058516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560264 LIMIT 5 [ RunTime:0.029800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560264 ORDER BY `minOrder` ASC [ RunTime:0.053699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560264 ORDER BY `unit` DESC [ RunTime:0.068801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560264 LIMIT 2 [ RunTime:0.044153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560264 ORDER BY `minOrder` ASC [ RunTime:0.046777s ]
select * from pdf where partno='71495CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.035126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71495CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.091196s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560264 AND `partno` = '71495CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.066874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561478 LIMIT 5 [ RunTime:0.027367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561478 ORDER BY `minOrder` ASC [ RunTime:0.029464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561478 ORDER BY `unit` DESC [ RunTime:0.063991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561478 LIMIT 2 [ RunTime:0.030477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561478 ORDER BY `minOrder` ASC [ RunTime:0.021476s ]
select * from pdf where partno='71401CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.035877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71401CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.055978s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561478 AND `partno` = '71401CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.069031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350540 [ RunTime:0.052341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561751 LIMIT 5 [ RunTime:0.017779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561751 ORDER BY `minOrder` ASC [ RunTime:0.014070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561751 ORDER BY `unit` DESC [ RunTime:0.040531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561751 LIMIT 2 [ RunTime:0.040499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561751 ORDER BY `minOrder` ASC [ RunTime:0.044869s ]
select * from pdf where partno='71417CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.010591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71417CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.031866s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561751 AND `partno` = '71417CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.016433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067872 [ RunTime:0.009441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562960 LIMIT 5 [ RunTime:0.011562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562960 ORDER BY `minOrder` ASC [ RunTime:0.005972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562960 ORDER BY `unit` DESC [ RunTime:0.010027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562960 LIMIT 2 [ RunTime:0.023804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562960 ORDER BY `minOrder` ASC [ RunTime:0.010685s ]
select * from pdf where partno='71433SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.018545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71433SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008105s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562960 AND `partno` = '71433SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068404 [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561173 LIMIT 5 [ RunTime:0.019429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561173 ORDER BY `minOrder` ASC [ RunTime:0.013125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561173 ORDER BY `unit` DESC [ RunTime:0.011603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561173 LIMIT 2 [ RunTime:0.005628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561173 ORDER BY `minOrder` ASC [ RunTime:0.012360s ]
select * from pdf where partno='71450CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.014433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71450CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010202s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561173 AND `partno` = '71450CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350319 [ RunTime:0.010185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562464 LIMIT 5 [ RunTime:0.009340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562464 ORDER BY `minOrder` ASC [ RunTime:0.003524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562464 ORDER BY `unit` DESC [ RunTime:0.010166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562464 LIMIT 2 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562464 ORDER BY `minOrder` ASC [ RunTime:0.005972s ]
select * from pdf where partno='71474SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.022909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71474SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004349s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562464 AND `partno` = '71474SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.018465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351125 [ RunTime:0.006508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50740657 LIMIT 5 [ RunTime:0.026136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50740657 ORDER BY `minOrder` ASC [ RunTime:0.017013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50740657 ORDER BY `unit` DESC [ RunTime:0.026046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50740657 LIMIT 2 [ RunTime:0.019272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50740657 ORDER BY `minOrder` ASC [ RunTime:0.002892s ]
select * from pdf where partno='71429CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71429CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.019525s ]
SELECT `id` FROM `stock` WHERE `id` <> 50740657 AND `partno` = '71429CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350704 [ RunTime:0.003359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38142957 LIMIT 5 [ RunTime:0.005440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38142957 ORDER BY `minOrder` ASC [ RunTime:0.007376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38142957 ORDER BY `unit` DESC [ RunTime:0.004672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38142957 LIMIT 2 [ RunTime:0.014567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38142957 ORDER BY `minOrder` ASC [ RunTime:0.002302s ]
select * from pdf where partno='71429CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.010090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71429CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003949s ]
SELECT `id` FROM `stock` WHERE `id` <> 38142957 AND `partno` = '71429CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.022695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350704 [ RunTime:0.015445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562405 LIMIT 5 [ RunTime:0.008307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562405 ORDER BY `minOrder` ASC [ RunTime:0.013677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562405 ORDER BY `unit` DESC [ RunTime:0.036756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562405 LIMIT 2 [ RunTime:0.001220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562405 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='71457SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71457SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000834s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562405 AND `partno` = '71457SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068148 [ RunTime:0.016052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562209 LIMIT 5 [ RunTime:0.014330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562209 ORDER BY `minOrder` ASC [ RunTime:0.018658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562209 ORDER BY `unit` DESC [ RunTime:0.012186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562209 LIMIT 2 [ RunTime:0.017990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562209 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='71492SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71492SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003468s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562209 AND `partno` = '71492SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350963 [ RunTime:0.005213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562306 LIMIT 5 [ RunTime:0.019343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562306 ORDER BY `minOrder` ASC [ RunTime:0.011598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562306 ORDER BY `unit` DESC [ RunTime:0.004872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562306 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562306 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='71425CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.013175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71425CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.033859s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562306 AND `partno` = '71425CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.023688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068099 [ RunTime:0.007369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560266 LIMIT 5 [ RunTime:0.005574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560266 ORDER BY `minOrder` ASC [ RunTime:0.008073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560266 ORDER BY `unit` DESC [ RunTime:0.001752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560266 LIMIT 2 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560266 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
select * from pdf where partno='71488CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71488CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.015762s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560266 AND `partno` = '71488CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067249 [ RunTime:0.012313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562008 LIMIT 5 [ RunTime:0.011078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562008 ORDER BY `minOrder` ASC [ RunTime:0.027118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562008 ORDER BY `unit` DESC [ RunTime:0.027343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562008 LIMIT 2 [ RunTime:0.021527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562008 ORDER BY `minOrder` ASC [ RunTime:0.004558s ]
select * from pdf where partno='71406SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71406SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006767s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562008 AND `partno` = '71406SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.036252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067992 [ RunTime:0.011286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561486 LIMIT 5 [ RunTime:0.029555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561486 ORDER BY `minOrder` ASC [ RunTime:0.023958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561486 ORDER BY `unit` DESC [ RunTime:0.002100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561486 LIMIT 2 [ RunTime:0.017875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561486 ORDER BY `minOrder` ASC [ RunTime:0.005676s ]
select * from pdf where partno='71404CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71404CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004264s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561486 AND `partno` = '71404CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067764 [ RunTime:0.017010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561431 LIMIT 5 [ RunTime:0.014659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561431 ORDER BY `minOrder` ASC [ RunTime:0.014853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561431 ORDER BY `unit` DESC [ RunTime:0.015168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561431 LIMIT 2 [ RunTime:0.037753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561431 ORDER BY `minOrder` ASC [ RunTime:0.010128s ]
select * from pdf where partno='71455CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.014129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71455CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006725s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561431 AND `partno` = '71455CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.041960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067712 [ RunTime:0.005029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562315 LIMIT 5 [ RunTime:0.007459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562315 ORDER BY `minOrder` ASC [ RunTime:0.004908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562315 ORDER BY `unit` DESC [ RunTime:0.001774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562315 LIMIT 2 [ RunTime:0.010898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562315 ORDER BY `minOrder` ASC [ RunTime:0.010141s ]
select * from pdf where partno='71400SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.016213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71400SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000908s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562315 AND `partno` = '71400SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.018703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068112 [ RunTime:0.002308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562961 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562961 ORDER BY `minOrder` ASC [ RunTime:0.009151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562961 ORDER BY `unit` DESC [ RunTime:0.011896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562961 LIMIT 2 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562961 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='71431SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71431SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006981s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562961 AND `partno` = '71431SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.013402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068411 [ RunTime:0.005899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562466 LIMIT 5 [ RunTime:0.003969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562466 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562466 ORDER BY `unit` DESC [ RunTime:0.007232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562466 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562466 ORDER BY `minOrder` ASC [ RunTime:0.001184s ]
select * from pdf where partno='71478SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71478SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002075s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562466 AND `partno` = '71478SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351111 [ RunTime:0.002604s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020001s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002416s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023727s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019679s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053782s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001283s ]
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 '714%' OR `brand` LIKE '714%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018542s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '714%' OR `brand` LIKE '714%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.040999s ]