Query Metrics
7
Database Queries
7
Different statements
175.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.86 ms (83.78%) |
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 16946 28386 35067 66716 82710 97107 131726 194687 268637 385788 385946 391760 392068 392880 393456 395101 395755 398124 398492 398882 400042 400587 401766 404078 404731 407293 407562 409168 411977 412091 412227 415508 417419 419861 423625 425835 426031 434080 436462 443028 444698 444735 448592 455822 457016 457508 457855 458359 458591 459096 459505 465228 470046 472150 473228 475819 477316 482610 483147 486011 486894 490164 504162 513036 516100 519161 519260 520892 520938 521401 522600 524282 526056 527917 531120 551242 556655 566833 569861 572095 577087 589573 591788 592227 592735 598216 598349 603482 606611 611020 615023 622967 630267 637520 646000 653876 665622 673141 681646 692077 702224 712879 713364 731623 737533 739820 741710 743208 758789 785026 785967 801282 808064 811493 814429 817785 821478 821496 824921 827009 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (9.42%) |
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 577087 569861 637520 603482 785026 459096 412227 591788 395101 268637 35067 398124 404078 817785 824921 821478 821496 827009 448592 524282 673141 681646 622967 611020 811493 801282 737533 743208 731623 385788 423625 457016 458591 477316 28386 425835 455822 472150 482610 519161 522600 566833 653876 606611 444698 486011 131726 444735 457508 519260 615023 592227 702224 391760 392880 521401 419861 814429 526056 556655 712879 589573 82710 486894 393456 392068 400587 409168 415508 551242 665622 713364 785967 741710 739820 630267 808064 417419 412091 457855 459505 520938 97107 400042 407562 465228 490164 520892 527917 572095 646000 692077 598216 592735 598349 758789 66716 194687 395755 16946 411977 426031 443028 473228 475819 470046 516100 513036 458359 483147 504162 531120 385946 398492 398882 401766 404731 434080 436462 407293 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (2.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 16946 28386 35067 66716 82710 97107 131726 194687 268637 385788 385946 391760 392068 392880 393456 395101 395755 398124 398492 398882 400042 400587 401766 404078 404731 407293 407562 409168 411977 412091 412227 415508 417419 419861 423625 425835 426031 434080 436462 443028 444698 444735 448592 455822 457016 457508 457855 458359 458591 459096 459505 465228 470046 472150 473228 475819 477316 482610 483147 486011 486894 490164 504162 513036 516100 519161 519260 520892 520938 521401 522600 524282 526056 527917 531120 551242 556655 566833 569861 572095 577087 589573 591788 592227 592735 598216 598349 603482 606611 611020 615023 622967 630267 637520 646000 653876 665622 673141 681646 692077 702224 712879 713364 731623 737533 739820 741710 743208 758789 785026 785967 801282 808064 811493 814429 817785 821478 821496 824921 827009 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking blonde"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking беловолосая"
]
|
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.