Query Metrics
7
Database Queries
7
Different statements
465.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
236.84 ms (50.87%) |
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 478660 465981 801901 403052 679091 513311 489584 462295 453355 457554 460299 573794 559251 475342 455212 471481 494349 489650 721336 666513 391206 395876 518716 564786 686089 789419 456642 461478 398171 462029 458238 543841 445035 466666 521964 561829 686868 462521 569567 445909 463737 490786 722154 596438 778923 727294 612482 442521 478497 490736 525917 699459 526917 565367 417880 498924 585436 594868 475010 438373 466594 477449 496047 510851 560911 399194 567666 549479 472801 461575 510796 4429 570447 401454 407222 499157 489148 548761 146855 626209 406017 753678 586817 431490 508739 598994 506463 557185 790498 803854 388290 460649 576082 560145 597048 438398 442979 471474 463945 488995 469655 522559 460872 565920 542072 449499 411635 460852 463530 464893 494413 571067 575777 588962 414023 434277 456949 471129 455425 420440 ] |
||||||||||||||||||||||||||||||
|
218.67 ms (46.96%) |
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 4429 146855 388290 391206 395876 398171 399194 401454 403052 406017 407222 411635 414023 417880 420440 431490 434277 438373 438398 442521 442979 445035 445909 449499 453355 455212 455425 456642 456949 457554 458238 460299 460649 460852 460872 461478 461575 462029 462295 462521 463530 463737 463945 464893 465981 466594 466666 469655 471129 471474 471481 472801 475010 475342 477449 478497 478660 488995 489148 489584 489650 490736 490786 494349 494413 496047 498924 499157 506463 508739 510796 510851 513311 518716 521964 522559 525917 526917 542072 543841 548761 549479 557185 559251 560145 560911 561829 564786 565367 565920 567666 569567 570447 571067 573794 575777 576082 585436 586817 588962 594868 596438 597048 598994 612482 626209 666513 679091 686089 686868 699459 721336 722154 727294 753678 778923 789419 790498 801901 803854 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (0.66%) |
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 4429 146855 388290 391206 395876 398171 399194 401454 403052 406017 407222 411635 414023 417880 420440 431490 434277 438373 438398 442521 442979 445035 445909 449499 453355 455212 455425 456642 456949 457554 458238 460299 460649 460852 460872 461478 461575 462029 462295 462521 463530 463737 463945 464893 465981 466594 466666 469655 471129 471474 471481 472801 475010 475342 477449 478497 478660 488995 489148 489584 489650 490736 490786 494349 494413 496047 498924 499157 506463 508739 510796 510851 513311 518716 521964 522559 525917 526917 542072 543841 548761 549479 557185 559251 560145 560911 561829 564786 565367 565920 567666 569567 570447 571067 573794 575777 576082 585436 586817 588962 594868 596438 597048 598994 612482 626209 666513 679091 686089 686868 699459 721336 722154 727294 753678 778923 789419 790498 801901 803854 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful girl blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.