Query Metrics
7
Database Queries
7
Different statements
161.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.87 ms (84.00%) |
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 130126 151179 325660 397089 397867 401070 406095 407182 407414 409682 417134 417726 417727 418840 420118 427714 430293 432428 432554 433319 433418 433441 437486 440817 441406 441603 444709 444957 448349 449133 452198 452271 452832 453147 453549 453822 455400 457943 458606 460318 460378 460631 461728 462848 463636 464049 464440 464597 465543 470434 472269 473560 476142 476292 477076 484424 485136 487030 491999 492102 494061 494292 494755 495588 496687 503256 504676 505979 508082 508750 509465 509580 512170 515090 517265 517457 519983 523390 526283 528959 529167 532971 533384 538111 538563 540429 541162 541277 541322 543266 543433 544079 545485 546221 546634 546637 551770 553441 558324 559098 561290 561883 564379 569067 569199 569993 571804 574372 579555 583022 597963 606738 702430 766016 800773 813808 814843 816755 817716 827973 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (9.59%) |
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 606738 766016 702430 800773 407414 409682 476292 491999 433319 597963 130126 151179 325660 397089 397867 401070 406095 407182 417727 420118 441406 430293 432428 432554 433418 433441 437486 441603 444709 427714 417134 417726 440817 444957 418840 814843 816755 817716 813808 827973 452832 457943 460318 464597 470434 476142 487030 448349 449133 453549 455400 458606 461728 463636 464440 477076 452198 452271 453147 453822 460631 462848 464049 472269 473560 485136 492102 494292 505979 509465 526283 532971 533384 540429 509580 523390 528959 494061 503256 504676 508082 508750 512170 517265 517457 529167 538111 538563 494755 495588 496687 515090 519983 460378 465543 484424 541162 541277 543266 543433 544079 545485 546221 551770 553441 558324 564379 569067 571804 579555 583022 541322 546634 546637 559098 561290 561883 569199 569993 574372 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen milf"
]
|
||||||||||||||||||||||||||||||
|
2.41 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 130126 151179 325660 397089 397867 401070 406095 407182 407414 409682 417134 417726 417727 418840 420118 427714 430293 432428 432554 433319 433418 433441 437486 440817 441406 441603 444709 444957 448349 449133 452198 452271 452832 453147 453549 453822 455400 457943 458606 460318 460378 460631 461728 462848 463636 464049 464440 464597 465543 470434 472269 473560 476142 476292 477076 484424 485136 487030 491999 492102 494061 494292 494755 495588 496687 503256 504676 505979 508082 508750 509465 509580 512170 515090 517265 517457 519983 523390 526283 528959 529167 532971 533384 538111 538563 540429 541162 541277 541322 543266 543433 544079 545485 546221 546634 546637 551770 553441 558324 559098 561290 561883 564379 569067 569199 569993 571804 574372 579555 583022 597963 606738 702430 766016 800773 813808 814843 816755 817716 827973 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen milf"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen and milf"
]
|
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.