Query Metrics
7
Database Queries
7
Different statements
182.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.98 ms (83.74%) |
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 123610 388426 392563 401216 402146 411361 411393 412367 419545 422275 424259 428049 432766 437960 440827 443712 443814 444926 447962 449693 449757 449877 450312 450811 451476 451485 453028 454200 454208 454310 454706 455058 455993 458842 459406 462708 462720 464129 464163 464351 465333 466129 466319 466836 466941 467026 468034 468804 469405 470771 470964 471162 471611 472595 472618 472933 473237 473960 474004 474034 474154 474160 475885 475888 475977 476691 477597 478510 478935 479044 479091 480304 482786 482872 483590 483600 484455 484689 485952 485961 485977 486446 487052 487763 489138 489462 490307 490913 490945 495246 496370 497828 502001 505465 506334 506656 509540 509918 512069 512346 514853 516221 517565 518500 519137 519753 522978 525025 526737 532138 532893 534334 535456 591997 685682 702430 800773 814781 815255 815789 ] |
||||||||||||||||||||||||||||||
|
18.93 ms (10.36%) |
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 464351 466319 480304 388426 392563 411393 419545 428049 443712 444926 454310 470964 473237 475885 479044 479091 411361 443814 451485 462708 462720 466129 467026 470771 475888 502001 509918 512069 519137 526737 484689 487763 497828 505465 509540 522978 483590 483600 490307 490913 495246 485952 485961 485977 487052 490945 496370 534334 535456 459406 464163 464129 486446 482786 685682 591997 702430 800773 424259 451476 465333 466836 437960 449877 412367 489138 123610 402146 401216 422275 440827 432766 814781 815789 815255 449757 453028 454200 469405 472595 473960 474004 474154 474160 475977 482872 447962 449693 450312 468804 471162 472618 472933 478935 450811 454208 454706 455058 455993 458842 466941 471611 474034 476691 477597 478510 484455 489462 506656 512346 516221 518500 519753 506334 525025 514853 517565 532138 532893 468034 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.07%) |
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 123610 388426 392563 401216 402146 411361 411393 412367 419545 422275 424259 428049 432766 437960 440827 443712 443814 444926 447962 449693 449757 449877 450312 450811 451476 451485 453028 454200 454208 454310 454706 455058 455993 458842 459406 462708 462720 464129 464163 464351 465333 466129 466319 466836 466941 467026 468034 468804 469405 470771 470964 471162 471611 472595 472618 472933 473237 473960 474004 474034 474154 474160 475885 475888 475977 476691 477597 478510 478935 479044 479091 480304 482786 482872 483590 483600 484455 484689 485952 485961 485977 486446 487052 487763 489138 489462 490307 490913 490945 495246 496370 497828 502001 505465 506334 506656 509540 509918 512069 512346 514853 516221 517565 518500 519137 519753 522978 525025 526737 532138 532893 534334 535456 591997 685682 702430 800773 814781 815255 815789 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short milf pussy"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short milf pussy"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short milf pussy"
]
|
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.