Query Metrics
7
Database Queries
7
Different statements
201.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.87 ms (87.24%) |
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 192691 233133 383539 388274 391600 393810 397714 398593 399255 412038 416905 418156 418868 418882 419914 420042 420901 421144 424569 428963 430949 435818 436478 441543 442367 442988 447742 448307 450699 451567 451999 455798 455807 456850 457043 457721 457743 457787 457792 457800 457801 458489 460957 466451 469236 470435 471699 474299 476475 479928 480806 482475 482940 484866 486962 486978 487215 488236 489431 489778 491521 494126 495866 499526 511030 512043 521913 523934 528947 529114 537721 541910 547675 552505 556856 562262 562281 562370 564092 567467 578499 579900 585342 599450 615909 632020 648295 650950 651917 671085 713509 738630 770479 779688 784887 787449 787475 804374 806677 816855 817484 817891 818742 819097 819124 819193 819469 820609 820671 821134 821609 821986 821997 822219 822763 822974 823490 827193 827683 828288 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (8.17%) |
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 419914 484866 457043 547675 436478 487215 450699 816855 827193 818742 822974 822763 827683 383539 399255 482475 512043 562262 562370 474299 397714 421144 418156 457800 632020 486962 817484 819124 819097 828288 651917 787449 398593 416905 457792 469236 455798 488236 650950 428963 418868 418882 420901 435818 455807 523934 486978 192691 823490 820609 819469 821609 821997 804374 787475 770479 447742 448307 817891 821134 458489 556856 713509 738630 233133 482940 499526 511030 552505 585342 460957 430949 457801 480806 471699 579900 615909 393810 821986 822219 457721 457743 456850 567467 541910 779688 412038 388274 451999 489431 494126 562281 441543 391600 420042 529114 820671 819193 489778 451567 470435 537721 466451 564092 784887 806677 442988 491521 521913 599450 442367 424569 495866 528947 578499 671085 648295 457787 476475 479928 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.34%) |
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 192691 233133 383539 388274 391600 393810 397714 398593 399255 412038 416905 418156 418868 418882 419914 420042 420901 421144 424569 428963 430949 435818 436478 441543 442367 442988 447742 448307 450699 451567 451999 455798 455807 456850 457043 457721 457743 457787 457792 457800 457801 458489 460957 466451 469236 470435 471699 474299 476475 479928 480806 482475 482940 484866 486962 486978 487215 488236 489431 489778 491521 494126 495866 499526 511030 512043 521913 523934 528947 529114 537721 541910 547675 552505 556856 562262 562281 562370 564092 567467 578499 579900 585342 599450 615909 632020 648295 650950 651917 671085 713509 738630 770479 779688 784887 787449 787475 804374 806677 816855 817484 817891 818742 819097 819124 819193 819469 820609 820671 821134 821609 821986 821997 822219 822763 822974 823490 827193 827683 828288 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beach teens"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пляж природ teens"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пляж природ teens"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.73%) |
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.