Query Metrics
7
Database Queries
7
Different statements
159.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.47 ms (83.02%) |
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 11393 96946 261144 357595 378401 383985 391087 392986 400483 405042 408319 408668 409814 417744 423706 432744 439135 442980 445135 445468 446694 447557 447749 452779 454536 455641 457014 457514 461447 461722 463876 465040 468105 468183 469574 472773 472951 474946 474956 475981 476742 482338 483114 484278 484689 484899 485073 488700 489128 490278 490788 491944 493236 493319 493743 496882 497906 497949 505905 508950 513157 513499 515848 516485 518922 520937 521885 522970 523548 523832 524876 524939 526527 527859 535309 541860 544401 545711 546762 552809 556474 557969 560478 561361 561649 561880 563173 565119 567392 569012 569981 572556 572697 574237 574664 575512 576271 578484 581242 591149 591398 592413 595436 599031 602102 604326 606299 608464 609883 619484 621794 622364 622893 623435 627420 653549 654372 668559 677362 687174 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (11.04%) |
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 604326 627420 619484 468183 357595 383985 400483 461447 472773 261144 454536 457514 455641 468105 474956 527859 484689 490278 491944 522970 493743 524939 497906 526527 439135 513157 556474 606299 508950 546762 608464 96946 445468 483114 469574 552809 391087 392986 11393 474946 409814 417744 475981 482338 563173 569012 569981 575512 561880 578484 541860 561361 654372 687174 653549 581242 609883 595436 602102 592413 622893 476742 472951 447557 505905 520937 523832 493236 513499 515848 432744 423706 668559 489128 457014 518922 521885 535309 544401 557969 576271 574664 545711 561649 565119 574237 677362 560478 567392 572556 591149 591398 621794 623435 599031 622364 447749 461722 408668 405042 445135 463876 516485 524876 484899 490788 496882 488700 497949 484278 493319 523548 572697 378401 408319 442980 446694 452779 485073 465040 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.50%) |
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 11393 96946 261144 357595 378401 383985 391087 392986 400483 405042 408319 408668 409814 417744 423706 432744 439135 442980 445135 445468 446694 447557 447749 452779 454536 455641 457014 457514 461447 461722 463876 465040 468105 468183 469574 472773 472951 474946 474956 475981 476742 482338 483114 484278 484689 484899 485073 488700 489128 490278 490788 491944 493236 493319 493743 496882 497906 497949 505905 508950 513157 513499 515848 516485 518922 520937 521885 522970 523548 523832 524876 524939 526527 527859 535309 541860 544401 545711 546762 552809 556474 557969 560478 561361 561649 561880 563173 565119 567392 569012 569981 572556 572697 574237 574664 575512 576271 578484 581242 591149 591398 592413 595436 599031 602102 604326 606299 608464 609883 619484 621794 622364 622893 623435 627420 653549 654372 668559 677362 687174 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skirt in anal"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"юбк анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.