Query Metrics
7
Database Queries
7
Different statements
184.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.08 ms (86.42%) |
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 4321 17180 38909 39114 351182 354774 384889 385745 386304 393751 395686 396412 399306 401985 404059 404366 404950 405100 407851 411433 417476 422997 423205 423412 426406 433694 442370 445601 445933 447448 456414 456484 462803 463766 466395 467197 468771 470324 470359 471703 472471 472962 473291 475588 476944 478853 479324 479560 480420 482126 485573 486909 489130 489785 491670 496356 497671 503953 510022 513789 515301 519227 523903 526503 527421 534111 537638 549575 557747 558335 558417 561929 565542 566348 569660 570061 571268 575819 580237 581660 581706 584537 591600 594944 594947 599586 605009 607542 614566 620327 620801 628363 645871 646244 652593 670341 677040 683579 699416 702006 705462 706253 710604 711327 713335 714640 721338 721364 721551 727049 731091 738870 745761 759965 761135 764202 777191 797578 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (7.76%) |
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 706253 38909 351182 17180 354774 468771 565542 628363 423205 385745 386304 393751 395686 401985 404366 433694 422997 426406 442370 417476 445933 456484 470359 456414 476944 575819 549575 558417 566348 580237 584537 721551 558335 561929 569660 570061 581660 581706 591600 620801 404059 463766 479560 411433 423412 472962 480420 404950 405100 462803 478853 466395 470324 472471 447448 475588 526503 486909 491670 489130 496356 503953 510022 523903 497671 519227 527421 599586 384889 39114 4321 396412 399306 407851 445601 479324 473291 482126 485573 513789 534111 515301 537638 467197 471703 489785 571268 645871 702006 711327 713335 721338 721364 646244 670341 699416 652593 677040 683579 705462 710604 714640 556306 557747 573272 607542 620327 594944 594947 614566 605009 777191 731091 759965 797578 745761 727049 738870 761135 764202 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.85%) |
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 4321 17180 38909 39114 351182 354774 384889 385745 386304 393751 395686 396412 399306 401985 404059 404366 404950 405100 407851 411433 417476 422997 423205 423412 426406 433694 442370 445601 445933 447448 456414 456484 462803 463766 466395 467197 468771 470324 470359 471703 472471 472962 473291 475588 476944 478853 479324 479560 480420 482126 485573 486909 489130 489785 491670 496356 497671 503953 510022 513789 515301 519227 523903 526503 527421 534111 537638 549575 557747 558335 558417 561929 565542 566348 569660 570061 571268 575819 580237 581660 581706 584537 591600 594944 594947 599586 605009 607542 614566 620327 620801 628363 645871 646244 652593 670341 677040 683579 699416 702006 705462 706253 710604 711327 713335 714640 721338 721364 721551 727049 731091 738870 745761 759965 761135 764202 777191 797578 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин cock"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man cock"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.