Query Metrics
7
Database Queries
7
Different statements
416.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.53 ms (50.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая минет оральн секс домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
184.97 ms (44.37%) |
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 151113 391122 392581 394045 396825 398655 401803 420808 421831 426808 426810 426908 427064 435537 435549 436093 438858 439687 446234 446813 449702 450522 455539 456313 459085 466396 469149 470391 472095 472786 478776 479368 480866 482949 485088 489813 496236 498867 498882 500824 503460 504748 508921 509860 511841 513441 521731 523444 524044 524690 524708 524775 525567 533453 533828 535576 536431 552906 558262 559717 561291 581135 590615 595056 598964 601654 612037 612485 613870 624756 642608 647183 648096 652750 677618 684093 689232 693158 701232 704019 705749 709935 726343 727608 727960 728810 729999 733252 733803 736120 739541 739780 742297 742718 742820 750037 754943 755044 763244 767814 771626 775846 778797 779211 779502 779970 780454 781561 783558 789153 791562 811244 811338 814035 818060 825306 825455 825968 826536 ] |
||||||||||||||||||||||||||||||
|
10.80 ms (2.59%) |
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 736120 479368 739541 783558 396825 420808 779502 456313 472786 450522 825455 726343 709935 598964 704019 394045 509860 825968 624756 482949 652750 775846 392581 472095 729999 498882 559717 498867 742718 763244 536431 523444 561291 438858 391122 779211 791562 742820 754943 755044 780454 781561 825306 521731 648096 612037 435537 779970 733803 489813 504748 426908 480866 511841 446813 469149 581135 590615 496236 524708 436093 767814 739780 742297 727960 826536 459085 601654 466396 449702 427064 426808 524044 733252 421831 524690 398655 426810 524775 818060 533828 508921 693158 595056 455539 478776 485088 525567 814035 789153 811244 811338 778797 435549 446234 825755 689232 401803 470391 151113 503460 500824 513441 535576 533453 558262 684093 705749 647183 677618 552906 642608 613870 612485 727608 728810 701232 771626 439687 750037 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (0.85%) |
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 151113 391122 392581 394045 396825 398655 401803 420808 421831 426808 426810 426908 427064 435537 435549 436093 438858 439687 446234 446813 449702 450522 455539 456313 459085 466396 469149 470391 472095 472786 478776 479368 480866 482949 485088 489813 496236 498867 498882 500824 503460 504748 508921 509860 511841 513441 521731 523444 524044 524690 524708 524775 525567 533453 533828 535576 536431 552906 558262 559717 561291 581135 590615 595056 598964 601654 612037 612485 613870 624756 642608 647183 648096 652750 677618 684093 689232 693158 701232 704019 705749 709935 726343 727608 727960 728810 729999 733252 733803 736120 739541 739780 742297 742718 742820 750037 754943 755044 763244 767814 771626 775846 778797 779211 779502 779970 780454 781561 783558 789153 791562 811244 811338 814035 818060 825306 825455 825968 826536 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая минет оральн секс домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette blowjob homemade"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.36%) |
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.