Query Metrics
7
Database Queries
7
Different statements
124.02 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.50 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina lips"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.17 ms |
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 432985 439236 499350 484503 622777 386371 718070 569826 621457 628515 416164 520918 587986 604994 451273 488782 710221 602136 705528 478216 390794 448450 516501 524953 540014 529917 562867 676426 734687 460568 629457 429708 471012 472706 554418 447229 516363 525729 552795 557113 463795 548837 557533 450939 486648 586593 593277 594893 598083 456328 571026 391076 439249 468577 424288 516490 521910 568079 498459 588022 503136 451267 588620 443060 476839 515435 402146 812043 490129 525727 596904 603612 509440 382245 529565 625165 439560 603092 584602 627089 523033 604364 486864 512927 509433 611525 562790 ] |
||||||||||||||||||||||||||||||
| 4 | 2.47 ms |
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 382245 386371 390794 391076 402146 416164 424288 429708 432985 439236 439249 439560 443060 447229 448450 450939 451267 451273 456328 460568 463795 468577 471012 472706 476839 478216 484503 486648 486864 488782 490129 498459 499350 503136 509433 509440 512927 515435 516363 516490 516501 520918 521910 523033 524953 525727 525729 529565 529917 540014 548837 552795 554418 557113 557533 562790 562867 568079 569826 571026 584602 586593 587986 588022 588620 593277 594893 596904 598083 602136 603092 603612 604364 604994 611525 621457 622777 625165 627089 628515 629457 676426 705528 710221 718070 734687 812043 ] |
||||||||||||||||||||||||||||||
| 5 | 103.26 ms |
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 382245 386371 390794 391076 402146 416164 424288 429708 432985 439236 439249 439560 443060 447229 448450 450939 451267 451273 456328 460568 463795 468577 471012 472706 476839 478216 484503 486648 486864 488782 490129 498459 499350 503136 509433 509440 512927 515435 516363 516490 516501 520918 521910 523033 524953 525727 525729 529565 529917 540014 548837 552795 554418 557113 557533 562790 562867 568079 569826 571026 584602 586593 587986 588022 588620 593277 594893 596904 598083 602136 603092 603612 604364 604994 611525 621457 622777 625165 627089 628515 629457 676426 705528 710221 718070 734687 812043 ] |
||||||||||||||||||||||||||||||
| 6 | 1.35 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин lips"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.26 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин lips"
]
|
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.