Query Metrics
7
Database Queries
7
Different statements
210.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.64 ms (86.42%) |
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 391926 391944 391984 392004 392019 403439 414103 419819 420174 428250 432613 432673 434346 440995 441733 442157 442986 443106 445651 446799 452810 452876 455015 455087 455914 455918 461606 468219 469250 471074 475426 476163 476663 477143 477502 477525 479474 480263 483684 483731 483762 485468 487273 510815 511274 511855 512353 512928 513967 514254 515969 517804 518187 521800 533644 536466 545445 547452 547470 547489 549815 552800 555258 556879 556881 561034 561036 590803 593292 596684 618256 639071 641807 656626 656904 660359 670368 672927 683083 700975 711629 713885 716965 717514 717523 728072 733582 735195 739125 742281 749242 749254 749259 751546 751567 752609 752644 752767 756752 757427 758778 765712 765817 770263 780642 782806 785856 786876 786881 786906 788569 791550 792594 795406 796057 800031 807565 807590 811125 828614 ] |
||||||||||||||||||||||||||||||
|
19.72 ms (9.38%) |
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 547470 547489 549815 556881 545445 547452 561036 656626 656904 672927 700975 711629 713885 717523 660359 552800 555258 641807 590803 785856 786906 788569 733582 751567 770263 800031 807565 807590 811125 749259 752609 751546 756752 735195 752644 752767 758778 765712 765817 716965 717514 786876 792594 403439 452876 419819 446799 487273 517804 521800 515969 536466 510815 512928 683083 593292 440995 828614 392019 391944 414103 443106 432613 442157 420174 428250 432673 441733 455914 471074 475426 477143 483731 445651 461606 477502 485468 455087 455918 469250 476663 477525 512353 511274 514254 533644 511855 513967 518187 468219 476163 479474 483684 483762 561034 670368 556879 596684 639071 782806 780642 795406 791550 796057 739125 742281 728072 749242 757427 749254 618256 786881 391984 434346 442986 391926 392004 452810 455015 480263 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.41%) |
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 391926 391944 391984 392004 392019 403439 414103 419819 420174 428250 432613 432673 434346 440995 441733 442157 442986 443106 445651 446799 452810 452876 455015 455087 455914 455918 461606 468219 469250 471074 475426 476163 476663 477143 477502 477525 479474 480263 483684 483731 483762 485468 487273 510815 511274 511855 512353 512928 513967 514254 515969 517804 518187 521800 533644 536466 545445 547452 547470 547489 549815 552800 555258 556879 556881 561034 561036 590803 593292 596684 618256 639071 641807 656626 656904 660359 670368 672927 683083 700975 711629 713885 716965 717514 717523 728072 733582 735195 739125 742281 749242 749254 749259 751546 751567 752609 752644 752767 756752 757427 758778 765712 765817 770263 780642 782806 785856 786876 786881 786906 788569 791550 792594 795406 796057 800031 807565 807590 811125 828614 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting amateur milf"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг любительск milf"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг любительск milf"
]
|
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.