Query Metrics
7
Database Queries
7
Different statements
147.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.64 ms (81.87%) |
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 334474 397283 422284 438708 445736 446163 451038 451223 451850 456743 456838 456960 458244 458432 459684 462352 463151 463632 464826 467620 469637 472971 475232 475463 478402 483231 485056 487153 487680 488196 488201 489784 489789 489792 494279 494298 495077 496115 496147 497047 497197 499735 500923 502229 503317 505189 505636 505932 506118 506517 507428 508436 508586 510153 510497 511772 513445 515777 517600 519126 522453 522458 523435 525252 527175 536154 544459 544982 549813 553685 553957 554625 555667 555698 559677 566911 567558 572214 577679 582872 583954 584162 586558 592143 592975 593769 595546 599289 604052 606297 613599 617122 617436 618101 618199 618952 624013 625711 626143 626268 635689 640388 650528 654273 676418 697010 697026 697928 705765 710188 717029 718436 719837 727374 745827 758024 758099 758381 778297 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (11.56%) |
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 472971 456838 502229 496147 508586 515777 483231 487680 489789 495077 496115 510153 334474 397283 505636 710188 717029 727374 718436 640388 604052 635689 586558 758381 462352 488201 705765 626268 506517 463151 513445 446163 458244 505932 506118 654273 745827 697010 422284 467620 488196 527175 567558 445736 517600 494298 536154 451038 451223 456743 456960 458432 478402 485056 475463 497047 508436 519126 500923 499735 510497 497197 463632 549813 553957 554625 583954 544459 553685 555698 559677 582872 584162 650528 697928 664464 676418 719837 566911 577679 592975 617122 618101 618199 595546 624013 625711 592143 599289 606297 617436 626143 778297 758099 758024 438708 459684 464826 523435 487153 505189 522458 503317 489784 489792 507428 555667 572214 593769 618952 522453 525252 494279 451850 469637 511772 544982 697026 613599 475232 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.75%) |
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 334474 397283 422284 438708 445736 446163 451038 451223 451850 456743 456838 456960 458244 458432 459684 462352 463151 463632 464826 467620 469637 472971 475232 475463 478402 483231 485056 487153 487680 488196 488201 489784 489789 489792 494279 494298 495077 496115 496147 497047 497197 499735 500923 502229 503317 505189 505636 505932 506118 506517 507428 508436 508586 510153 510497 511772 513445 515777 517600 519126 522453 522458 523435 525252 527175 536154 544459 544982 549813 553685 553957 554625 555667 555698 559677 566911 567558 572214 577679 582872 583954 584162 586558 592143 592975 593769 595546 599289 604052 606297 613599 617122 617436 618101 618199 618952 624013 625711 626143 626268 635689 640388 650528 654273 676418 697010 697026 697928 705765 710188 717029 718436 719837 727374 745827 758024 758099 758381 778297 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stranger wife"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stranger жен"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stranger жен"
]
|
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.