Query Metrics
7
Database Queries
7
Different statements
367.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.73 ms (57.02%) |
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 326158 383020 391945 397766 413058 414103 414135 415050 417243 418112 418148 419319 419599 420774 421579 423485 423663 424197 426532 429553 449412 449692 452298 452302 452659 452696 452767 454004 455408 455900 456208 456229 456236 460619 460813 463792 464210 464811 467949 468388 472299 473529 474273 474597 489319 492136 493300 493304 498239 504482 505382 509257 509566 510855 513158 513380 513839 514999 516922 517431 518368 522020 528327 534494 536426 539293 544976 545515 545631 550241 552837 554956 555091 555094 555128 559756 561441 564363 565630 571726 573206 589071 596208 601749 604406 620266 624953 627316 632502 633937 640837 656932 667986 671465 672806 675375 715089 715289 716986 720747 724720 724816 727799 742281 751435 758486 765860 767183 768386 781187 782091 786525 790504 795460 796180 810303 825762 825764 825838 826130 ] |
||||||||||||||||||||||||||||||
|
134.78 ms (36.64%) |
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 326158 383020 391945 397766 413058 414103 414135 415050 417243 418112 418148 419319 419599 420774 421579 423485 423663 424197 426532 429553 449412 449692 452298 452302 452659 452696 452767 454004 455408 455900 456208 456229 456236 460619 460813 463792 464210 464811 467949 468388 472299 473529 474273 474597 489319 492136 493300 493304 498239 504482 505382 509257 509566 510855 513158 513380 513839 514999 516922 517431 518368 522020 528327 534494 536426 539293 544976 545515 545631 550241 552837 554956 555091 555094 555128 559756 561441 564363 565630 571726 573206 589071 596208 601749 604406 620266 624953 627316 632502 633937 640837 656932 667986 671465 672806 675375 715089 715289 716986 720747 724720 724816 727799 742281 751435 758486 765860 767183 768386 781187 782091 786525 790504 795460 796180 810303 825762 825764 825838 826130 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (4.50%) |
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 456229 463792 424197 493300 489319 504482 493304 420774 419599 423485 455900 452696 536426 539293 545515 544976 545631 672806 675375 589071 768386 727799 452767 474597 554956 559756 565630 571726 449412 452302 517431 573206 472299 414135 413058 552837 418112 667986 534494 555128 656932 715289 671465 601749 633937 786525 751435 468388 391945 421579 455408 456236 456208 449692 509566 513380 498239 452298 513839 596208 473529 564363 825838 825764 716986 795460 724816 758486 528327 724720 467949 415050 383020 426532 604406 326158 414103 417243 826130 454004 474273 555094 555091 561441 627316 810303 765860 742281 767183 632502 790504 397766 460813 464811 509257 796180 781187 715089 419319 452659 505382 513158 460619 550241 640837 624953 782091 620266 418148 464210 514999 518368 522020 510855 516922 492136 720747 429553 423663 825762 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard жен анал"
]
|
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.