Query Metrics
7
Database Queries
7
Different statements
181.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.25 ms (85.94%) |
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 391808 395849 411849 418914 423491 424523 427059 429559 429952 433883 434793 438929 443293 445322 447093 448800 448868 448874 454107 454113 456029 456380 459551 463026 466889 467269 468638 475930 478048 482845 485040 490945 491792 492341 492579 494705 495930 499109 499207 499374 500971 501193 502508 508491 509025 509330 510024 515058 515862 516336 520884 520989 521580 523138 523183 526053 526910 527101 527121 529244 529833 531093 533950 535732 537241 537912 539894 543012 543179 543352 543506 543595 543850 543867 545649 557391 558601 559143 566563 573230 582785 593168 595789 600252 600387 601578 602655 603220 603607 608441 614186 619204 624229 632656 634563 636269 648534 648589 649147 650127 650350 650802 650851 664459 665916 665920 666532 676095 720050 731971 746366 804180 807512 809228 809301 817115 818160 819530 819565 825122 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (8.39%) |
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 650851 475930 438929 526910 650127 411849 545649 582785 529244 593168 463026 600252 601578 535732 492341 499109 520989 501193 509330 499374 516336 520884 445322 448874 543352 467269 527101 434793 466889 523138 391808 443293 456029 502508 499207 485040 427059 447093 459551 495930 523183 508491 595789 500971 558601 557391 543179 454107 482845 429559 494705 490945 492579 515058 543012 429952 509025 746366 433883 543506 804180 676095 624229 468638 424523 478048 650802 527121 515862 825122 456380 648534 665916 636269 807512 731971 533950 819565 521580 543595 543850 573230 650350 665920 559143 603607 632656 603220 608441 809301 537241 539894 602655 817115 818160 819530 448800 531093 510024 537912 566563 543867 649147 666532 648589 664459 720050 600387 614186 619204 634563 809228 395849 418914 423491 454113 491792 448868 526053 529833 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.63%) |
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 391808 395849 411849 418914 423491 424523 427059 429559 429952 433883 434793 438929 443293 445322 447093 448800 448868 448874 454107 454113 456029 456380 459551 463026 466889 467269 468638 475930 478048 482845 485040 490945 491792 492341 492579 494705 495930 499109 499207 499374 500971 501193 502508 508491 509025 509330 510024 515058 515862 516336 520884 520989 521580 523138 523183 526053 526910 527101 527121 529244 529833 531093 533950 535732 537241 537912 539894 543012 543179 543352 543506 543595 543850 543867 545649 557391 558601 559143 566563 573230 582785 593168 595789 600252 600387 601578 602655 603220 603607 608441 614186 619204 624229 632656 634563 636269 648534 648589 649147 650127 650350 650802 650851 664459 665916 665920 666532 676095 720050 731971 746366 804180 807512 809228 809301 817115 818160 819530 819565 825122 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"submissive deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован глубокийминет минет оральн секс"
]
|
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.