Query Metrics
7
Database Queries
7
Different statements
147.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.03 ms (84.55%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 424105 428385 428408 428704 446753 447432 451565 452018 457202 461433 462593 465140 465964 468402 470580 472337 484879 485246 489876 496160 498638 500250 502636 504746 509078 511421 516091 516615 521832 522223 522590 523285 527099 527902 533746 534494 541303 543551 544976 546487 551256 552131 552494 561636 561713 561883 564217 565280 571062 573080 573955 575103 576372 576406 589472 590390 590530 595853 595868 597003 597508 597999 598606 598731 599939 613850 618360 619273 619506 624176 626917 628484 634224 634602 652281 657221 668141 673833 679380 689750 700290 701508 704206 704215 707480 708551 712541 720281 723131 733841 733856 733868 733896 733910 738912 741279 746722 747367 751120 751159 753482 754097 766830 767236 769733 770784 775231 779054 782602 785773 787508 788903 788911 790397 800522 803244 804226 809184 809935 814511 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.59%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 733910 522223 552494 428385 428704 424105 447432 472337 484879 489876 452018 516091 521832 652281 814511 534494 527099 500250 552131 561883 576406 668141 673833 679380 720281 704215 589472 590530 624176 590390 597003 597508 619273 779054 775231 785773 741279 746722 754097 767236 809184 733841 751159 733856 738912 747367 753482 769733 766830 770784 626917 782602 787508 800522 803244 504746 509078 522590 511421 523285 496160 599939 533746 595853 516615 527902 446753 576372 597999 451565 461433 498638 790397 543551 485246 468402 465964 462593 541303 546487 544976 551256 561713 564217 571062 573955 565280 573080 657221 700290 701508 723131 689750 704206 712541 707480 708551 561636 575103 613850 628484 598606 598731 618360 619506 634224 595868 634602 788903 788911 804226 733868 733896 751120 809935 428408 457202 465140 470580 502636 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.53%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 424105 428385 428408 428704 446753 447432 451565 452018 457202 461433 462593 465140 465964 468402 470580 472337 484879 485246 489876 496160 498638 500250 502636 504746 509078 511421 516091 516615 521832 522223 522590 523285 527099 527902 533746 534494 541303 543551 544976 546487 551256 552131 552494 561636 561713 561883 564217 565280 571062 573080 573955 575103 576372 576406 589472 590390 590530 595853 595868 597003 597508 597999 598606 598731 599939 613850 618360 619273 619506 624176 626917 628484 634224 634602 652281 657221 668141 673833 679380 689750 700290 701508 704206 704215 707480 708551 712541 720281 723131 733841 733856 733868 733896 733910 738912 741279 746722 747367 751120 751159 753482 754097 766830 767236 769733 770784 775231 779054 782602 785773 787508 788903 788911 790397 800522 803244 804226 809184 809935 814511 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teen хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teen hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teen хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.