Query Metrics
7
Database Queries
7
Different statements
194.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.31 ms (82.24%) |
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 70082 238809 383118 385742 387682 388713 390508 391208 391541 395406 396358 396526 396577 397639 398154 400943 402092 402876 404317 404459 407357 407444 407515 411768 414047 414110 414850 417891 417929 418933 419148 419509 419621 419738 419804 419854 419868 421241 422785 425125 425173 425903 425962 428334 428373 428388 429523 429729 430884 435497 437678 440687 445017 445741 445751 446152 446344 446864 447102 447691 449032 449868 451265 451977 452206 452257 457332 457430 458916 460071 460799 462829 463894 464146 468046 468387 468694 468786 469579 470848 471836 471859 472163 475724 481151 481625 481839 482710 483251 484503 492718 494253 497725 498511 499889 502921 503428 504876 508426 508775 516770 519819 521741 522140 522598 522846 523900 526073 526405 527988 528831 543878 548733 559986 562333 566235 570242 575748 576360 595337 ] |
||||||||||||||||||||||||||||||
|
24.06 ms (12.34%) |
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 425903 451265 522140 398154 422785 504876 402876 414850 411768 470848 483251 463894 519819 494253 566235 446152 402092 419148 419868 492718 383118 468694 445741 451977 452206 460071 460799 419621 462829 396577 404317 391541 425125 464146 457430 497725 482710 385742 425962 446864 523900 484503 387682 508775 469579 419738 397639 498511 521741 238809 388713 428334 559986 595337 400943 428388 471859 395406 481839 522846 440687 445017 526405 570242 575748 421241 472163 407515 445751 548733 418933 468046 499889 407444 419804 429729 396358 407357 417891 516770 502921 419854 458916 522598 70082 391208 404459 414047 435497 437678 457332 481625 425173 430884 449868 449032 475724 562333 396526 471836 414110 528831 429523 452257 446344 447691 447102 468786 503428 481151 543878 419509 417929 527988 390508 428373 468387 576360 526073 508426 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (1.84%) |
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 70082 238809 383118 385742 387682 388713 390508 391208 391541 395406 396358 396526 396577 397639 398154 400943 402092 402876 404317 404459 407357 407444 407515 411768 414047 414110 414850 417891 417929 418933 419148 419509 419621 419738 419804 419854 419868 421241 422785 425125 425173 425903 425962 428334 428373 428388 429523 429729 430884 435497 437678 440687 445017 445741 445751 446152 446344 446864 447102 447691 449032 449868 451265 451977 452206 452257 457332 457430 458916 460071 460799 462829 463894 464146 468046 468387 468694 468786 469579 470848 471836 471859 472163 475724 481151 481625 481839 482710 483251 484503 492718 494253 497725 498511 499889 502921 503428 504876 508426 508775 516770 519819 521741 522140 522598 522846 523900 526073 526405 527988 528831 543878 548733 559986 562333 566235 570242 575748 576360 595337 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex negro"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.