Query Metrics
7
Database Queries
7
Different statements
153.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.70 ms (80.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 390360 391923 392015 398099 400483 410346 410962 411344 413388 414125 414271 414306 415329 423663 424001 424574 426511 429596 429881 429905 430353 435530 443240 444524 444548 448082 448464 449024 451042 452274 452640 452876 452953 458829 460016 464659 465143 467882 468148 468219 468665 470191 470453 470470 477417 480454 480478 480676 483735 483745 486761 486775 490731 493122 497692 500339 504509 505725 508895 511274 512933 513220 522174 530110 530942 531880 541832 547452 558261 562784 573175 576503 576916 585251 586002 600348 604404 605742 609885 614968 623193 626588 630083 660365 660373 660399 660410 665957 668677 672950 707556 711629 718678 718785 728146 731783 737578 738814 739946 749255 751615 752613 752668 752704 758789 759948 760319 765497 765634 765699 778172 796319 796644 802114 805146 805366 809371 816382 823589 827484 ] |
||||||||||||||||||||||||||||||
|
19.78 ms (12.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 778172 758789 796644 739946 737578 749255 752613 809371 468148 513220 718785 609885 760319 752704 497692 530110 508895 718678 586002 444548 483745 410962 483735 576916 738814 614968 424574 765497 765634 398099 414306 460016 480478 470191 480676 458829 490731 504509 452953 493122 827484 449024 452274 511274 512933 522174 468219 751615 392015 429881 452876 470453 391923 444524 477417 530942 531880 562784 547452 707556 711629 660373 672950 600348 623193 805366 759948 802114 400483 415329 448082 465143 500339 668677 660365 765699 728146 573175 660410 805146 480454 486761 816382 823589 731783 435530 423663 429596 468665 464659 470470 558261 604404 585251 410346 429905 424001 443240 411344 541832 451042 576503 505725 796319 390360 452640 605742 630083 752668 414271 413388 448464 486775 660399 665957 626588 467882 430353 414125 426511 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.21%) |
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 390360 391923 392015 398099 400483 410346 410962 411344 413388 414125 414271 414306 415329 423663 424001 424574 426511 429596 429881 429905 430353 435530 443240 444524 444548 448082 448464 449024 451042 452274 452640 452876 452953 458829 460016 464659 465143 467882 468148 468219 468665 470191 470453 470470 477417 480454 480478 480676 483735 483745 486761 486775 490731 493122 497692 500339 504509 505725 508895 511274 512933 513220 522174 530110 530942 531880 541832 547452 558261 562784 573175 576503 576916 585251 586002 600348 604404 605742 609885 614968 623193 626588 630083 660365 660373 660399 660410 665957 668677 672950 707556 711629 718678 718785 728146 731783 737578 738814 739946 749255 751615 752613 752668 752704 758789 759948 760319 765497 765634 765699 778172 796319 796644 802114 805146 805366 809371 816382 823589 827484 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal mature"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд анал mature"
]
|
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.