Query Metrics
7
Database Queries
7
Different statements
204.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.90 ms (86.21%) |
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 370875 387146 388440 388766 393102 396983 400948 401148 401952 405411 407270 407656 407683 409080 409300 409864 412790 416346 418270 418746 419111 420022 424032 424481 427536 428892 431750 435551 443071 447371 449085 449622 449702 449716 449760 450776 450803 453167 459947 464404 464407 464408 466384 466655 471701 472536 476105 477337 478748 488514 489971 492156 505518 512895 522168 525469 529305 547809 550137 557490 557969 565240 568373 571494 573270 578492 580288 588647 591155 602194 611330 623416 633829 643078 681092 683301 685613 712642 720711 730625 732065 737590 743986 746772 748549 752187 753007 754598 755145 759453 760613 761473 766543 771678 772092 774738 777043 777057 779610 784894 787764 789195 791562 797124 797289 797469 798626 799211 801437 805816 805945 807088 807121 807910 808229 810604 811496 812091 814335 826663 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (8.09%) |
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 789195 805816 784894 787764 797124 797289 797469 798626 801437 807910 737590 752187 755145 759453 771678 772092 791562 810604 812091 730625 766543 746772 754598 732065 743986 753007 760613 761473 712642 774738 799211 807088 807121 387146 400948 826663 571494 602194 611330 591155 805945 464407 388766 427536 428892 450803 464404 449760 489971 512895 529305 522168 525469 370875 396983 405411 409864 443071 407656 420022 435551 409300 814335 447371 453167 449716 459947 471701 488514 449702 466655 476105 505518 466384 472536 492156 547809 557969 573270 550137 557490 683301 685613 720711 681092 565240 568373 578492 580288 588647 643078 623416 777043 777057 779610 811496 748549 633829 808229 388440 393102 407270 409080 412790 419111 424032 424481 464408 478748 401952 416346 431750 449085 449622 450776 477337 401148 407683 418270 418746 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.66%) |
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 370875 387146 388440 388766 393102 396983 400948 401148 401952 405411 407270 407656 407683 409080 409300 409864 412790 416346 418270 418746 419111 420022 424032 424481 427536 428892 431750 435551 443071 447371 449085 449622 449702 449716 449760 450776 450803 453167 459947 464404 464407 464408 466384 466655 471701 472536 476105 477337 478748 488514 489971 492156 505518 512895 522168 525469 529305 547809 550137 557490 557969 565240 568373 571494 573270 578492 580288 588647 591155 602194 611330 623416 633829 643078 681092 683301 685613 712642 720711 730625 732065 737590 743986 746772 748549 752187 753007 754598 755145 759453 760613 761473 766543 771678 772092 774738 777043 777057 779610 784894 787764 789195 791562 797124 797289 797469 798626 799211 801437 805816 805945 807088 807121 807910 808229 810604 811496 812091 814335 826663 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette mom"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая mom"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая mom"
]
|
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.