Query Metrics
7
Database Queries
7
Different statements
366.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
336.90 ms (91.96%) |
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 395516 399700 404740 407148 407173 416841 421000 421878 421882 421922 422195 425070 425800 426766 426987 430204 430828 431422 433323 435700 437843 439731 439735 439807 446173 446631 458715 462477 470461 471639 475632 481910 482555 483406 485285 486253 487513 490769 492121 493221 494296 495778 501193 504929 505018 506908 512374 513020 513427 513953 514888 518750 518751 518940 519179 520639 520793 521091 523404 523901 524560 524897 525263 527669 528181 529516 531431 531500 531513 534000 539739 539744 544463 549742 557558 559845 562355 562895 563021 564824 565317 573234 573806 582531 584703 586457 586929 588144 589665 593831 595595 598122 598128 598652 605298 605461 606806 609102 612843 621645 624283 632010 640721 649175 671348 671351 673960 673988 682531 685682 688324 688548 689001 698284 717744 721617 788136 788604 814865 816086 ] |
||||||||||||||||||||||||||||||
|
18.48 ms (5.04%) |
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 439807 470461 501193 513020 514888 523404 490769 494296 504929 513427 814865 816086 458715 519179 539744 521091 518750 531500 549742 685682 689001 721617 649175 688548 688324 698284 563021 589665 593831 595595 609102 640721 586929 598652 586457 598128 788604 612843 399700 407173 426766 421922 435700 439731 421878 425800 407148 425070 475632 512374 524560 529516 483406 513953 485285 486253 404740 539739 518940 557558 559845 565317 562895 544463 717744 671351 673988 582531 588144 598122 606806 624283 788136 621645 395516 422195 446173 462477 421882 426987 431422 437843 439735 433323 523901 528181 487513 493221 520793 492121 495778 505018 416841 482555 446631 481910 525263 531431 531513 534000 573234 562355 564824 584703 671348 682531 673960 573806 605461 632010 605298 471639 421000 430828 430204 506908 518751 524897 527669 520639 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (1.12%) |
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 395516 399700 404740 407148 407173 416841 421000 421878 421882 421922 422195 425070 425800 426766 426987 430204 430828 431422 433323 435700 437843 439731 439735 439807 446173 446631 458715 462477 470461 471639 475632 481910 482555 483406 485285 486253 487513 490769 492121 493221 494296 495778 501193 504929 505018 506908 512374 513020 513427 513953 514888 518750 518751 518940 519179 520639 520793 521091 523404 523901 524560 524897 525263 527669 528181 529516 531431 531500 531513 534000 539739 539744 544463 549742 557558 559845 562355 562895 563021 564824 565317 573234 573806 582531 584703 586457 586929 588144 589665 593831 595595 598122 598128 598652 605298 605461 606806 609102 612843 621645 624283 632010 640721 649175 671348 671351 673960 673988 682531 685682 688324 688548 689001 698284 717744 721617 788136 788604 814865 816086 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom mom"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom mom"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom mom"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.