Query Metrics
7
Database Queries
7
Different statements
193.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.81 ms (86.25%) |
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 53396 282858 370875 390951 391644 396825 397560 401952 402009 405411 407656 409904 412790 416453 420106 428860 430142 436588 436655 445472 446126 453032 453218 455605 456091 460097 460440 467146 478484 480654 483349 483983 496626 503460 508181 524476 533022 537048 540245 543446 548697 549483 550456 550626 554485 557311 565955 571067 585897 593261 594805 596308 609761 617360 622815 630205 631547 633940 642689 644180 649565 664119 668496 670067 674357 674970 683715 685180 701733 702498 711566 714523 715687 722195 724538 728810 729737 729948 731327 732976 735013 735709 747102 750447 751240 757444 759796 760527 763870 764326 772896 773993 775026 780092 780906 784595 787230 792585 793814 795905 796001 796234 797143 797434 801279 803318 803352 805155 807214 807738 809755 811005 811530 812829 818065 820877 824744 824764 825261 826204 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (7.70%) |
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 818065 820877 826204 824744 824764 825261 483349 524476 533022 537048 460440 550626 543446 557311 549483 685180 701733 711566 649565 664119 674970 668496 670067 674357 683715 722195 594805 622815 630205 642689 633940 585897 593261 596308 644180 631547 780906 795905 796234 803352 812829 775026 801279 803318 811530 729737 729948 760527 773993 784595 793814 796001 797143 797434 807738 809755 735013 751240 724538 732976 735709 759796 728810 731327 747102 750447 757444 763870 764326 772896 609761 702498 714523 715687 780092 787230 792585 805155 807214 397560 409904 391644 370875 53396 396825 402009 405411 416453 407656 430142 420106 436588 453032 460097 483983 480654 445472 453218 455605 456091 496626 508181 540245 503460 478484 554485 565955 571067 550456 548697 617360 811005 390951 412790 428860 446126 467146 282858 401952 436655 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (1.97%) |
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 53396 282858 370875 390951 391644 396825 397560 401952 402009 405411 407656 409904 412790 416453 420106 428860 430142 436588 436655 445472 446126 453032 453218 455605 456091 460097 460440 467146 478484 480654 483349 483983 496626 503460 508181 524476 533022 537048 540245 543446 548697 549483 550456 550626 554485 557311 565955 571067 585897 593261 594805 596308 609761 617360 622815 630205 631547 633940 642689 644180 649565 664119 668496 670067 674357 674970 683715 685180 701733 702498 711566 714523 715687 722195 724538 728810 729737 729948 731327 732976 735013 735709 747102 750447 751240 757444 759796 760527 763870 764326 772896 773993 775026 780092 780906 784595 787230 792585 793814 795905 796001 796234 797143 797434 801279 803318 803352 805155 807214 807738 809755 811005 811530 812829 818065 820877 824744 824764 825261 826204 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot brunette"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot черноволосая"
]
|
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.