Query Metrics
7
Database Queries
7
Different statements
406.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.10 ms (57.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 824443 624366 443127 612066 612917 537306 500114 569024 561734 504774 608363 689296 418513 400569 473284 395895 409261 815886 449809 519095 565149 647901 705785 714119 715670 808060 772807 792530 413524 445182 436040 434804 429255 429650 453161 519231 529277 534632 485055 541370 567155 430135 511816 391018 817639 821717 498877 530831 672396 670958 544693 585896 599746 621941 622792 732121 740832 758983 391158 94529 389142 570595 662214 692432 572598 732913 759569 393039 440646 409931 526487 572818 576304 571575 680403 591319 614170 622038 748163 760781 774209 471992 401089 484374 519762 12405 507208 570646 673574 677934 684947 563650 738001 624790 701649 564923 818595 818812 821942 817427 818746 817931 460939 515198 536348 560384 558369 576383 582586 672095 697688 660999 663919 712927 693230 715097 716149 720430 572796 606417 ] |
||||||||||||||||||||||||||||||
|
162.97 ms (40.07%) |
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 12405 94529 389142 391018 391158 393039 395895 400569 401089 409261 409931 413524 418513 429255 429650 430135 434804 436040 440646 443127 445182 449809 453161 460939 471992 473284 484374 485055 498877 500114 504774 507208 511816 515198 519095 519231 519762 526487 529277 530831 534632 536348 537306 541370 544693 558369 560384 561734 563650 564923 565149 567155 569024 570595 570646 571575 572598 572796 572818 576304 576383 582586 585896 591319 599746 606417 608363 612066 612917 614170 621941 622038 622792 624366 624790 647901 660999 662214 663919 670958 672095 672396 673574 677934 680403 684947 689296 692432 693230 697688 701649 705785 712927 714119 715097 715670 716149 720430 732121 732913 738001 740832 748163 758983 759569 760781 772807 774209 792530 808060 815886 817427 817639 817931 818595 818746 818812 821717 821942 824443 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.54%) |
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 12405 94529 389142 391018 391158 393039 395895 400569 401089 409261 409931 413524 418513 429255 429650 430135 434804 436040 440646 443127 445182 449809 453161 460939 471992 473284 484374 485055 498877 500114 504774 507208 511816 515198 519095 519231 519762 526487 529277 530831 534632 536348 537306 541370 544693 558369 560384 561734 563650 564923 565149 567155 569024 570595 570646 571575 572598 572796 572818 576304 576383 582586 585896 591319 599746 606417 608363 612066 612917 614170 621941 622038 622792 624366 624790 647901 660999 662214 663919 670958 672095 672396 673574 677934 680403 684947 689296 692432 693230 697688 701649 705785 712927 714119 715097 715670 716149 720430 732121 732913 738001 740832 748163 758983 759569 760781 772807 774209 792530 808060 815886 817427 817639 817931 818595 818746 818812 821717 821942 824443 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на pussy улиц лиза"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на pussy улиц лиза"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.44%) |
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.