Query Metrics
7
Database Queries
7
Different statements
171.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.39 ms (85.90%) |
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 12203 119671 387391 388812 392393 393641 397639 418028 423893 427363 429216 433086 440263 446425 448053 448072 451943 452682 455855 457645 457726 465449 469935 472481 473851 475354 480290 482207 487713 493584 496307 504118 508622 510040 511497 516776 521849 522266 523979 529383 538856 540170 543943 548675 549518 550019 565455 570764 572545 573948 584691 589300 592395 599798 603307 603697 604637 610817 612431 612909 614327 622127 623659 630279 644847 646763 649082 653377 654208 665180 667232 668479 674663 682908 686021 686076 691851 693160 710323 711205 711905 712830 712929 716202 721954 722190 722212 729601 741295 746329 752158 755974 757345 757548 760823 761560 764001 767479 770271 770633 781809 786330 788156 789213 789655 801728 806243 807023 809481 814937 815963 817224 817410 818422 819490 822027 823269 823295 823791 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (7.93%) |
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 457645 667232 397639 457726 475354 548675 573948 592395 469935 387391 392393 508622 388812 823295 823791 822027 819490 823269 818422 510040 523979 538856 496307 543943 572545 573937 584691 668479 691851 722212 712830 654208 686021 693160 712929 716202 722190 565455 610817 623659 603307 604637 612909 630279 786330 789213 789655 729601 788156 760823 741295 757548 614327 710323 721954 119671 472481 493584 529383 807023 423893 451943 487713 549518 711205 646763 682908 711905 589300 599798 806243 746329 764001 781809 622127 686076 649082 550019 770633 757345 809481 418028 427363 433086 815963 814937 448072 521849 516776 653377 674663 612431 752158 770271 755974 761560 465449 511497 429216 448053 452682 665180 767479 801728 446425 504118 644847 455855 473851 570764 603697 522266 480290 393641 12203 440263 482207 540170 817224 817410 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на pussy улиц лиза"
]
|
||||||||||||||||||||||||||||||
|
2.41 ms (1.40%) |
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 12203 119671 387391 388812 392393 393641 397639 418028 423893 427363 429216 433086 440263 446425 448053 448072 451943 452682 455855 457645 457726 465449 469935 472481 473851 475354 480290 482207 487713 493584 496307 504118 508622 510040 511497 516776 521849 522266 523979 529383 538856 540170 543943 548675 549518 550019 565455 570764 572545 573948 584691 589300 592395 599798 603307 603697 604637 610817 612431 612909 614327 622127 623659 630279 644847 646763 649082 653377 654208 665180 667232 668479 674663 682908 686021 686076 691851 693160 710323 711205 711905 712830 712929 716202 721954 722190 722212 729601 741295 746329 752158 755974 757345 757548 760823 761560 764001 767479 770271 770633 781809 786330 788156 789213 789655 801728 806243 807023 809481 814937 815963 817224 817410 818422 819490 822027 823269 823295 823791 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на pussy улиц лиза"
]
|
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.