Query Metrics
7
Database Queries
7
Different statements
570.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
412.55 ms (72.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
135.09 ms (23.70%) |
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 182895 326207 388912 411675 413112 420377 429406 430567 441838 441841 441952 443183 443461 448040 448043 448067 448939 449126 449200 452273 452818 456418 460976 460980 462356 462366 464149 464302 464546 466892 468827 468856 470420 470952 471441 471659 472566 474470 476045 476142 476176 477460 477683 478515 482260 482547 482566 482804 483387 483656 487030 489285 491126 491829 491921 491997 492412 493201 493543 494164 494758 495067 495633 496304 500977 502488 504620 505254 506501 506901 507799 508469 508884 510825 512170 512860 512878 513118 513119 513150 513366 513982 515702 516569 517925 519505 520673 520933 521599 521765 522352 522869 523337 524355 526471 527876 527882 528317 528362 528853 529269 529899 530328 531412 531414 532764 533256 533260 533490 533983 534224 534304 536460 536470 537132 539518 540115 540370 547815 818442 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (2.57%) |
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 491921 547815 468827 476176 468856 470952 520673 483656 491997 519505 505254 182895 326207 388912 430567 441838 441952 420377 411675 413112 443183 443461 429406 441841 818442 482566 482547 448043 448067 452818 456418 462356 462366 464302 472566 476142 478515 482260 482804 487030 493543 448939 452273 460980 464149 464546 470420 471659 474470 476045 477460 483387 448040 449126 449200 460976 466892 471441 477683 489285 491126 491829 492412 493201 494164 495633 496304 500977 504620 507799 508469 510825 512860 512878 513118 513150 513366 521599 522869 524355 527882 528317 529899 531414 532764 533256 533260 533490 533983 536460 540370 502488 506901 513982 517925 521765 522352 523337 526471 528362 528853 530328 534224 534304 536470 537132 540115 495067 506501 508884 512170 513119 515702 516569 520933 527876 529269 531412 539518 494758 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.43%) |
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 182895 326207 388912 411675 413112 420377 429406 430567 441838 441841 441952 443183 443461 448040 448043 448067 448939 449126 449200 452273 452818 456418 460976 460980 462356 462366 464149 464302 464546 466892 468827 468856 470420 470952 471441 471659 472566 474470 476045 476142 476176 477460 477683 478515 482260 482547 482566 482804 483387 483656 487030 489285 491126 491829 491921 491997 492412 493201 493543 494164 494758 495067 495633 496304 500977 502488 504620 505254 506501 506901 507799 508469 508884 510825 512170 512860 512878 513118 513119 513150 513366 513982 515702 516569 517925 519505 520673 520933 521599 521765 522352 522869 523337 524355 526471 527876 527882 528317 528362 528853 529269 529899 530328 531412 531414 532764 533256 533260 533490 533983 534224 534304 536460 536470 537132 539518 540115 540370 547815 818442 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf domination"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf domination"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf domination"
]
|
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.