Query Metrics
7
Database Queries
7
Different statements
181.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.99 ms (86.18%) |
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 103649 159380 175985 197609 229389 384511 387394 387492 388127 388990 391535 391817 392721 397591 398125 398237 398789 399545 401648 408776 411533 412137 412677 414092 415356 415864 417601 417682 420799 424242 424337 424519 426090 426725 426731 428927 431718 436450 438181 438621 438641 441347 443502 444081 444930 446077 446419 448585 448925 449668 451334 451717 452848 454570 457017 457567 458627 459028 460056 460083 460352 462131 464737 468266 469395 471009 471028 471052 471128 472067 472749 473095 477228 480853 483352 484962 485873 487646 488260 490587 492091 492661 493016 498267 498378 498541 500743 510547 510942 513161 513835 514239 518508 522316 524836 543187 543743 544887 548095 550466 564502 573174 573493 577920 579236 580226 582044 582745 584278 589040 591428 592656 598318 633475 739408 760656 787069 789209 790268 808446 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (8.51%) |
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 510547 543743 573493 548095 448585 459028 472067 414092 493016 384511 197609 415356 457567 460083 790268 159380 229389 391817 424242 401648 589040 591428 464737 471128 444930 103649 417601 424337 438181 490587 446419 513835 488260 550466 543187 582745 808446 412677 448925 175985 388990 436450 451334 469395 471052 415864 438621 443502 449668 452848 454570 438641 498378 492661 510942 492091 513161 514239 398789 573174 462131 484962 483352 522316 388127 398125 398237 412137 417682 487646 468266 471009 477228 498267 518508 471028 584278 564502 580226 760656 787069 739408 789209 399545 408776 441347 451717 387492 391535 411533 428927 457017 458627 431718 392721 426731 473095 424519 460352 485873 387394 420799 446077 498541 524836 397591 444081 480853 460056 472749 500743 579236 544887 577920 582044 592656 598318 633475 426725 426090 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.60%) |
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 103649 159380 175985 197609 229389 384511 387394 387492 388127 388990 391535 391817 392721 397591 398125 398237 398789 399545 401648 408776 411533 412137 412677 414092 415356 415864 417601 417682 420799 424242 424337 424519 426090 426725 426731 428927 431718 436450 438181 438621 438641 441347 443502 444081 444930 446077 446419 448585 448925 449668 451334 451717 452848 454570 457017 457567 458627 459028 460056 460083 460352 462131 464737 468266 469395 471009 471028 471052 471128 472067 472749 473095 477228 480853 483352 484962 485873 487646 488260 490587 492091 492661 493016 498267 498378 498541 500743 510547 510942 513161 513835 514239 518508 522316 524836 543187 543743 544887 548095 550466 564502 573174 573493 577920 579236 580226 582044 582745 584278 589040 591428 592656 598318 633475 739408 760656 787069 789209 790268 808446 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam girl"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер девушк"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
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.