Query Metrics
7
Database Queries
7
Different statements
205.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.97 ms (86.04%) |
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 382352 386016 391184 400624 401921 405249 405565 405810 407156 407973 409685 413471 420232 425694 428891 430178 431812 442231 444412 445182 445551 446303 446697 447454 448721 448869 449809 450861 451115 451999 453044 454944 457117 457515 459382 465345 466635 466666 468119 471618 472208 472521 474094 474509 476295 478707 479683 480731 485099 486058 486262 486414 486454 488628 491785 492839 493260 495418 497096 497196 504323 505320 511052 513298 518771 518857 523951 527334 536869 541891 543587 547969 551477 552009 556247 557384 558469 559026 565360 566996 567024 569021 569867 569981 570031 570304 570457 570544 570662 570673 571926 572373 572397 572548 573817 574888 576072 576341 579519 583370 584244 585397 587267 593989 594167 594868 608363 613598 615040 616683 623471 623692 650291 651676 680633 691677 700190 749106 763739 787532 ] |
||||||||||||||||||||||||||||||
|
18.78 ms (9.13%) |
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 391184 446697 474094 543587 559026 569021 572548 584244 556247 570673 572397 569867 573817 570544 570662 763739 431812 425694 536869 523951 493260 497096 613598 479683 472208 430178 691677 615040 616683 650291 557384 449809 587267 445182 457117 478707 497196 485099 551477 451115 459382 511052 451999 400624 444412 445551 453044 472521 569981 576341 572373 454944 593989 585397 787532 476295 594868 700190 407156 428891 567024 608363 594167 749106 623692 505320 579519 495418 450861 386016 382352 405810 405565 409685 413471 471618 488628 491785 541891 576072 680633 570457 446303 401921 405249 448721 468119 466635 448869 466666 486058 486262 518771 518857 486454 570304 465345 504323 527334 420232 623471 442231 492839 486414 552009 570031 574888 583370 558469 566996 565360 571926 457515 447454 480731 407973 513298 547969 651676 474509 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.49%) |
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 382352 386016 391184 400624 401921 405249 405565 405810 407156 407973 409685 413471 420232 425694 428891 430178 431812 442231 444412 445182 445551 446303 446697 447454 448721 448869 449809 450861 451115 451999 453044 454944 457117 457515 459382 465345 466635 466666 468119 471618 472208 472521 474094 474509 476295 478707 479683 480731 485099 486058 486262 486414 486454 488628 491785 492839 493260 495418 497096 497196 504323 505320 511052 513298 518771 518857 523951 527334 536869 541891 543587 547969 551477 552009 556247 557384 558469 559026 565360 566996 567024 569021 569867 569981 570031 570304 570457 570544 570662 570673 571926 572373 572397 572548 573817 574888 576072 576341 579519 583370 584244 585397 587267 593989 594167 594868 608363 613598 615040 616683 623471 623692 650291 651676 680633 691677 700190 749106 763739 787532 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade public"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.66%) |
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.