Query Metrics
7
Database Queries
7
Different statements
215.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.69 ms (86.14%) |
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 80709 384556 398224 403562 404519 405493 407819 409949 411603 418966 419106 426671 435244 435358 437274 440424 445089 445350 448505 449954 453028 454182 454951 455973 457179 458882 464207 465006 466439 468934 472963 473911 474446 480089 485084 485284 486392 486504 494191 494192 494204 496472 502214 504194 506043 506079 511243 511467 512786 514488 518859 522074 524068 525882 527726 541094 543617 553430 554330 556019 557401 557951 560531 565103 565339 568699 569923 574427 579221 579574 580363 580424 580897 587065 589349 597162 601543 624869 625888 628037 650605 693645 697002 697155 701761 710504 711257 718455 718968 721537 724354 726348 726538 726546 732219 732697 741026 742848 742891 744624 748375 753751 756083 758118 765848 774980 776448 786637 788519 789526 791634 794943 794956 797758 802691 802800 807133 808681 812737 814971 ] |
||||||||||||||||||||||||||||||
|
18.78 ms (8.71%) |
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 697155 710504 711257 791634 802800 808681 812737 474446 437274 426671 454951 455973 494191 496472 512786 80709 405493 440424 445089 411603 445350 454182 464207 457179 486504 449954 502214 522074 472963 543617 557401 560531 553430 554330 579574 580897 565103 565339 580363 718455 721537 650605 693645 718968 556019 568699 569923 579221 628037 589349 624869 587065 597162 601543 625888 774980 802691 724354 742891 789526 797758 726348 726538 732219 748375 756083 758118 753751 765848 742848 744624 726546 732697 741026 697002 701761 776448 786637 788519 794943 794956 807133 398224 448505 409949 419106 480089 525882 527726 486392 494192 504194 511243 494204 485084 485284 514488 518859 384556 404519 403562 418966 407819 435244 435358 814971 453028 458882 466439 468934 465006 506079 524068 506043 511467 473911 541094 574427 580424 557951 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.52%) |
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 80709 384556 398224 403562 404519 405493 407819 409949 411603 418966 419106 426671 435244 435358 437274 440424 445089 445350 448505 449954 453028 454182 454951 455973 457179 458882 464207 465006 466439 468934 472963 473911 474446 480089 485084 485284 486392 486504 494191 494192 494204 496472 502214 504194 506043 506079 511243 511467 512786 514488 518859 522074 524068 525882 527726 541094 543617 553430 554330 556019 557401 557951 560531 565103 565339 568699 569923 574427 579221 579574 580363 580424 580897 587065 589349 597162 601543 624869 625888 628037 650605 693645 697002 697155 701761 710504 711257 718455 718968 721537 724354 726348 726538 726546 732219 732697 741026 742848 742891 744624 748375 753751 756083 758118 765848 774980 776448 786637 788519 789526 791634 794943 794956 797758 802691 802800 807133 808681 812737 814971 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs suck"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs suck"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs suck"
]
|
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.