Query Metrics
7
Database Queries
7
Different statements
143.85 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.84 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.06 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife big cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.69 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 647468 666670 685329 716861 718872 646610 663202 693618 707076 711076 716807 625319 807019 787546 808248 734792 740707 740726 742841 748917 813452 742108 744348 750092 756513 738320 738571 748450 724339 728832 748112 764395 637798 641038 700717 789633 812017 393987 504334 536508 531975 649092 691173 721678 707519 726756 734015 738944 826029 385187 823969 533424 653339 732184 629599 745318 755113 147173 534925 461835 654167 716584 718341 661913 600954 622962 725709 797876 730970 750747 735854 732570 770521 731381 763314 635351 714173 779238 458983 538670 463386 826654 673246 691046 736062 759194 634331 78536 391749 563764 584227 693759 717119 718346 723087 648906 755120 759562 733532 753642 733082 744686 572223 659479 662441 630666 547951 416422 469967 654600 730975 518401 501011 394012 826682 816116 823264 817933 512750 483421 ] |
||||||||||||||||||||||||||||||
| 4 | 3.04 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 78536 147173 385187 391749 393987 394012 416422 458983 461835 463386 469967 483421 501011 504334 512750 518401 531975 533424 534925 536508 538670 547951 563764 572223 584227 600954 622962 625319 629599 630666 634331 635351 637798 641038 646610 647468 648906 649092 653339 654167 654600 659479 661913 662441 663202 666670 673246 685329 691046 691173 693618 693759 700717 707076 707519 711076 714173 716584 716807 716861 717119 718341 718346 718872 721678 723087 724339 725709 726756 728832 730970 730975 731381 732184 732570 733082 733532 734015 734792 735854 736062 738320 738571 738944 740707 740726 742108 742841 744348 744686 745318 748112 748450 748917 750092 750747 753642 755113 755120 756513 759194 759562 763314 764395 770521 779238 787546 789633 797876 807019 808248 812017 813452 816116 817933 823264 823969 826654 826682 ] |
||||||||||||||||||||||||||||||
| 5 | 121.63 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 78536 147173 385187 391749 393987 394012 416422 458983 461835 463386 469967 483421 501011 504334 512750 518401 531975 533424 534925 536508 538670 547951 563764 572223 584227 600954 622962 625319 629599 630666 634331 635351 637798 641038 646610 647468 648906 649092 653339 654167 654600 659479 661913 662441 663202 666670 673246 685329 691046 691173 693618 693759 700717 707076 707519 711076 714173 716584 716807 716861 717119 718341 718346 718872 721678 723087 724339 725709 726756 728832 730970 730975 731381 732184 732570 733082 733532 734015 734792 735854 736062 738320 738571 738944 740707 740726 742108 742841 744348 744686 745318 748112 748450 748917 750092 750747 753642 755113 755120 756513 759194 759562 763314 764395 770521 779238 787546 789633 797876 807019 808248 812017 813452 816116 817933 823264 823969 826654 826682 ] |
||||||||||||||||||||||||||||||
| 6 | 1.83 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен большие cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен большие cock"
]
|
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.