Query Metrics
7
Database Queries
7
Different statements
135.72 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.66 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.92 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"romantic 2023"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.72 ms |
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 489105 516950 490331 499604 507293 521622 499667 513396 518356 534163 442146 441237 520921 510930 511939 521377 520501 525924 526826 584480 545729 722738 549679 565586 624838 628711 618883 605194 383823 408056 470205 439526 456550 470251 478155 449254 479592 425337 469024 473259 484119 491025 490423 482921 509543 523991 526579 393391 418484 815374 458702 460807 517302 567219 587751 599048 585711 624142 473537 523352 416422 594009 455846 431210 481650 529168 492333 508737 458905 498056 527387 566330 611339 506966 483208 525226 562397 547525 552909 569065 607797 625172 613819 483607 526220 ] |
||||||||||||||||||||||||||||||
| 4 | 2.06 ms |
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 383823 393391 408056 416422 418484 425337 431210 439526 441237 442146 449254 455846 456550 458702 458905 460807 469024 470205 470251 473259 473537 478155 479592 481650 482921 483208 483607 484119 489105 490331 490423 491025 492333 498056 499604 499667 506966 507293 508737 509543 510930 511939 513396 516950 517302 518356 520501 520921 521377 521622 523352 523991 525226 525924 526220 526579 526826 527387 529168 534163 545729 547525 549679 552909 562397 565586 566330 567219 569065 584480 585711 587751 594009 599048 605194 607797 611339 613819 618883 624142 624838 625172 628711 722738 815374 ] |
||||||||||||||||||||||||||||||
| 5 | 113.40 ms |
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 383823 393391 408056 416422 418484 425337 431210 439526 441237 442146 449254 455846 456550 458702 458905 460807 469024 470205 470251 473259 473537 478155 479592 481650 482921 483208 483607 484119 489105 490331 490423 491025 492333 498056 499604 499667 506966 507293 508737 509543 510930 511939 513396 516950 517302 518356 520501 520921 521377 521622 523352 523991 525226 525924 526220 526579 526826 527387 529168 534163 545729 547525 549679 552909 562397 565586 566330 567219 569065 584480 585711 587751 594009 599048 605194 607797 611339 613819 618883 624142 624838 625172 628711 722738 815374 ] |
||||||||||||||||||||||||||||||
| 6 | 1.41 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"romantic"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.55 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"romantic"
]
|
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.