Query Metrics
7
Database Queries
7
Different statements
122.64 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.52 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.12 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute girls masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.02 ms |
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 479212 515767 449099 669936 780704 434336 424770 512189 688374 670197 594007 523974 481598 500398 545729 582438 450268 589400 451696 430366 478514 483737 480207 607903 497690 533917 532370 551273 616315 789002 420654 516693 502503 400948 751242 770382 515571 560841 624502 632288 584474 628069 439301 513500 540996 438768 528592 495163 426592 423982 609083 788525 641986 601491 481801 592495 444367 459821 420559 595871 603523 525738 550618 458488 585826 593975 551973 576951 601677 532152 556861 519563 585885 675007 602268 456518 521002 505905 515545 510769 514574 616539 526912 628363 464062 ] |
||||||||||||||||||||||||||||||
| 4 | 2.48 ms |
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 400948 420559 420654 423982 424770 426592 430366 434336 438768 439301 444367 449099 450268 451696 456518 458488 459821 464062 478514 479212 480207 481598 481801 483737 495163 497690 500398 502503 505905 510769 512189 513500 514574 515545 515571 515767 516693 519563 521002 523974 525738 526912 528592 532152 532370 533917 540996 545729 550618 551273 551973 556861 560841 576951 582438 584474 585826 585885 589400 592495 593975 594007 595871 601491 601677 602268 603523 607903 609083 616315 616539 624502 628069 628363 632288 641986 669936 670197 675007 688374 751242 770382 780704 788525 789002 ] |
||||||||||||||||||||||||||||||
| 5 | 100.51 ms |
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 400948 420559 420654 423982 424770 426592 430366 434336 438768 439301 444367 449099 450268 451696 456518 458488 459821 464062 478514 479212 480207 481598 481801 483737 495163 497690 500398 502503 505905 510769 512189 513500 514574 515545 515571 515767 516693 519563 521002 523974 525738 526912 528592 532152 532370 533917 540996 545729 550618 551273 551973 556861 560841 576951 582438 584474 585826 585885 589400 592495 593975 594007 595871 601491 601677 602268 603523 607903 609083 616315 616539 624502 628069 628363 632288 641986 669936 670197 675007 688374 751242 770382 780704 788525 789002 ] |
||||||||||||||||||||||||||||||
| 6 | 1.46 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.53 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute девушк мастурбац"
]
|
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.