Query Metrics
7
Database Queries
7
Different statements
176.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.16 ms (87.40%) |
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 6591 20190 43271 95873 96946 97763 109313 130089 193390 322815 388411 389790 392111 397232 397899 400942 405074 420174 424841 440045 441232 442986 446695 452813 457776 460292 464951 486243 509014 514594 516332 520753 522882 530289 531137 531420 533363 534544 534551 544748 562588 563265 566079 571136 577435 583711 592027 597018 599861 599964 600359 601584 611307 613032 615915 619407 629409 632650 632671 639759 641052 641303 643103 645861 648819 662069 674492 680215 686615 690827 690875 692804 692806 694142 695188 695241 695620 697261 698409 699757 703097 703523 708462 717615 719004 719026 720582 721113 733071 738821 738824 738830 739558 740832 757372 762268 770402 770909 775054 775810 788783 788969 796297 803906 803910 804504 805563 808101 814386 814646 815467 815927 816484 817080 817192 817860 818404 818852 827484 827829 ] |
||||||||||||||||||||||||||||||
|
12.76 ms (7.23%) |
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 817192 530289 562588 695188 699757 680215 695620 695241 641052 775054 762268 740832 770909 803906 803910 389790 400942 827484 531420 619407 424841 817860 95873 814646 816484 583711 686615 703097 692804 597018 641303 788783 632650 738830 514594 566079 577435 643103 397232 814386 534544 690875 720582 694142 757372 808101 733071 739558 738821 738824 698409 796297 20190 446695 531137 534551 719026 648819 775810 804504 708462 533363 322815 442986 440045 457776 96946 97763 692806 719004 388411 109313 130089 392111 6591 420174 460292 43271 441232 509014 464951 592027 599861 601584 599964 639759 452813 615915 520753 645861 632671 611307 405074 818852 818404 770402 193390 815927 827829 788969 805563 397899 516332 817080 815467 486243 522882 544748 563265 690827 721113 697261 662069 674492 703523 717615 571136 600359 613032 629409 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.56%) |
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 6591 20190 43271 95873 96946 97763 109313 130089 193390 322815 388411 389790 392111 397232 397899 400942 405074 420174 424841 440045 441232 442986 446695 452813 457776 460292 464951 486243 509014 514594 516332 520753 522882 530289 531137 531420 533363 534544 534551 544748 562588 563265 566079 571136 577435 583711 592027 597018 599861 599964 600359 601584 611307 613032 615915 619407 629409 632650 632671 639759 641052 641303 643103 645861 648819 662069 674492 680215 686615 690827 690875 692804 692806 694142 695188 695241 695620 697261 698409 699757 703097 703523 708462 717615 719004 719026 720582 721113 733071 738821 738824 738830 739558 740832 757372 762268 770402 770909 775054 775810 788783 788969 796297 803906 803910 804504 805563 808101 814386 814646 815467 815927 816484 817080 817192 817860 818404 818852 827484 827829 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double анал"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double анал"
]
|
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.