Query Metrics
7
Database Queries
7
Different statements
229.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.85 ms (87.34%) |
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 12203 83386 233147 324395 382182 383000 387874 390760 396768 400813 402419 404582 405485 409929 411864 422294 450136 450155 453893 454058 458007 459988 461035 461815 465791 466716 466930 467518 468112 469345 471605 476271 476586 484672 485695 486365 489299 490188 490410 490915 493102 497207 514706 523023 523191 527270 531821 533219 539023 539464 543289 543592 547807 547853 549504 549646 554235 555120 555141 556899 557594 558523 563444 563898 570155 589650 591304 593047 593541 595928 597843 619511 620211 647602 662380 664848 667017 667743 693032 699370 710368 712561 716279 717545 720236 721910 726897 727653 736741 737182 741777 741778 742753 743065 745341 759914 760534 765822 770610 785435 792142 794250 794794 796027 796149 797178 800731 801881 803086 803295 804339 807489 812662 813539 814851 815094 816062 817371 824011 824345 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (7.46%) |
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 466930 563444 543592 662380 667017 555141 467518 814851 461815 664848 794794 797178 801881 813539 737182 83386 422294 396768 383000 404582 411864 409929 454058 549646 558523 593541 597843 400813 514706 527270 484672 815094 539023 543289 712561 693032 716279 717545 595928 812662 741778 785435 800731 699370 461035 469345 554235 619511 743065 466716 458007 459988 471605 489299 490915 490410 485695 547807 324395 390760 817371 816062 824011 824345 450136 450155 539464 486365 556899 549504 667743 710368 794250 792142 807489 727653 741777 759914 736741 770610 765822 745341 760534 803295 405485 490188 523191 555120 557594 591304 593047 803086 476271 465791 476586 497207 523023 493102 720236 382182 12203 402419 468112 531821 533219 547853 563898 721910 570155 589650 796149 804339 796027 726897 742753 453893 387874 233147 647602 620211 ] |
||||||||||||||||||||||||||||||
|
4.58 ms (1.99%) |
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 12203 83386 233147 324395 382182 383000 387874 390760 396768 400813 402419 404582 405485 409929 411864 422294 450136 450155 453893 454058 458007 459988 461035 461815 465791 466716 466930 467518 468112 469345 471605 476271 476586 484672 485695 486365 489299 490188 490410 490915 493102 497207 514706 523023 523191 527270 531821 533219 539023 539464 543289 543592 547807 547853 549504 549646 554235 555120 555141 556899 557594 558523 563444 563898 570155 589650 591304 593047 593541 595928 597843 619511 620211 647602 662380 664848 667017 667743 693032 699370 710368 712561 716279 717545 720236 721910 726897 727653 736741 737182 741777 741778 742753 743065 745341 759914 760534 765822 770610 785435 792142 794250 794794 796027 796149 797178 800731 801881 803086 803295 804339 807489 812662 813539 814851 815094 816062 817371 824011 824345 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot mature sex"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot mature секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot mature секс"
]
|
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.