Query Metrics
7
Database Queries
7
Different statements
176.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.50 ms (84.76%) |
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 382184 389729 390218 393102 395922 421155 421813 421859 422168 422187 422191 422204 422235 422243 424798 426701 426865 428137 429552 429586 430486 430495 431481 433351 434044 439560 439666 439678 439770 440771 443167 443184 443702 443801 443946 444044 444468 446968 451127 454432 454446 454964 456605 458928 460197 460262 460601 460659 460677 463624 464388 464438 464552 464890 466145 466762 467662 468091 471883 472701 474781 474788 474791 474799 475174 476263 476280 486540 489381 492309 493185 495222 495226 502809 502812 505399 506131 506833 514441 516226 516281 516476 516478 516712 518159 518160 518847 519480 521759 523837 523846 524262 526001 526450 526523 528839 532012 537020 537122 538001 549739 549822 549825 549848 549849 550219 566928 578124 580061 588755 603055 622667 665492 676591 699596 729635 756209 761275 806084 808675 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (9.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 518159 521759 549848 439678 421859 439666 538001 421155 486540 382184 467662 526001 580061 699596 578124 393102 395922 431481 444468 424798 430495 434044 446968 451127 454432 454446 456605 458928 464552 454964 464388 476263 506833 518847 537122 524262 502812 505399 516476 518160 528839 460262 460677 492309 549849 665492 549739 566928 588755 622667 806084 808675 761275 729635 756209 389729 390218 422243 426701 429552 433351 440771 463624 474799 475174 428137 443946 460659 468091 471883 474791 444044 466762 476280 443184 443702 443801 460601 474781 474788 422187 422235 430486 466145 516478 516712 519480 495226 506131 514441 516281 537020 489381 495222 502809 523837 516226 549822 421813 472701 439560 422204 426865 439770 429586 526523 493185 523846 526450 676591 422191 443167 464890 464438 532012 460197 550219 549825 603055 422168 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.71%) |
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 382184 389729 390218 393102 395922 421155 421813 421859 422168 422187 422191 422204 422235 422243 424798 426701 426865 428137 429552 429586 430486 430495 431481 433351 434044 439560 439666 439678 439770 440771 443167 443184 443702 443801 443946 444044 444468 446968 451127 454432 454446 454964 456605 458928 460197 460262 460601 460659 460677 463624 464388 464438 464552 464890 466145 466762 467662 468091 471883 472701 474781 474788 474791 474799 475174 476263 476280 486540 489381 492309 493185 495222 495226 502809 502812 505399 506131 506833 514441 516226 516281 516476 516478 516712 518159 518160 518847 519480 521759 523837 523846 524262 526001 526450 526523 528839 532012 537020 537122 538001 549739 549822 549825 549848 549849 550219 566928 578124 580061 588755 603055 622667 665492 676591 699596 729635 756209 761275 806084 808675 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom ass son"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom жоп son"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom жоп son"
]
|
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.