Query Metrics
7
Database Queries
7
Different statements
149.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.23 ms (85.59%) |
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 509565 519820 529575 530253 530266 533701 539630 542687 545310 555162 555907 557464 557706 559277 560801 563693 572956 579074 580014 584852 610725 619343 631271 634194 640540 644184 648002 651659 654979 657834 658229 671855 674102 674485 684379 692075 692435 692497 692707 694432 697699 698247 700877 704487 706260 707690 713463 713862 716671 717227 717957 718424 718533 718861 719215 721604 722191 723430 724634 724808 733190 737464 739253 747541 751806 754735 754851 758341 761418 763655 763872 763902 763905 763972 764827 767337 767801 767803 767835 768106 769618 772339 773815 775078 775478 779807 781030 781031 781090 781284 781534 784380 787222 787258 787261 787622 789615 790175 791695 791787 792194 792827 794551 796357 798144 798724 803400 803407 803701 804849 811596 813159 813618 816189 820632 823039 823980 825223 ] |
||||||||||||||||||||||||||||||
|
11.45 ms (7.64%) |
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 692497 694432 761418 724634 519820 572956 557706 707690 509565 768106 813618 820632 823039 816189 823980 825223 533701 539630 530253 529575 530266 555162 555907 579074 580014 542687 545310 559277 557464 563693 584852 674102 684379 692075 692707 713463 716671 719215 721604 654979 658229 674485 692435 698247 706260 713862 717957 718424 718533 718861 723430 648002 651659 657834 671855 697699 717227 722191 560801 634194 640540 631271 644184 775478 779807 780496 784380 789615 792194 794551 803701 811596 777101 781030 781031 781090 796357 803407 739253 763905 763972 767803 781534 787258 787622 791695 792827 798144 803400 804849 813159 724808 758341 764827 767337 767835 772339 737464 751806 769618 773815 733190 747541 754851 767801 754735 763655 763872 763902 610725 619343 700877 704487 775078 781284 787222 787261 790175 791787 798724 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.11%) |
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 509565 519820 529575 530253 530266 533701 539630 542687 545310 555162 555907 557464 557706 559277 560801 563693 572956 579074 580014 584852 610725 619343 631271 634194 640540 644184 648002 651659 654979 657834 658229 671855 674102 674485 684379 692075 692435 692497 692707 694432 697699 698247 700877 704487 706260 707690 713463 713862 716671 717227 717957 718424 718533 718861 719215 721604 722191 723430 724634 724808 733190 737464 739253 747541 751806 754735 754851 758341 761418 763655 763872 763902 763905 763972 764827 767337 767801 767803 767835 768106 769618 772339 773815 775078 775478 779807 781030 781031 781090 781284 781534 784380 787222 787258 787261 787622 789615 790175 791695 791787 792194 792827 794551 796357 798144 798724 803400 803407 803701 804849 811596 813159 813618 816189 820632 823039 823980 825223 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close up blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up минет оральн секс"
]
|
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.