Query Metrics
7
Database Queries
7
Different statements
168.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.77 ms (82.25%) |
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 326305 386845 397322 398253 400114 402242 402931 403424 407871 410590 411033 411809 414194 415292 426001 428593 430815 434767 447134 447567 447634 447912 447998 448002 452634 452654 452683 453047 453373 453485 453663 453785 455897 456469 456558 456696 457146 457879 458136 458196 458443 458609 460330 461396 461741 461939 463376 463934 464231 464700 465315 465392 465522 465550 466061 466679 466690 468102 468109 468338 468349 468359 468366 468430 469311 470129 471992 473231 473486 474567 476142 478413 479369 482193 483901 484717 485136 488294 489312 489846 491584 493591 493614 493616 493658 493758 497453 497635 499884 500815 508184 509600 509725 511431 511481 511867 512948 513469 515693 518454 519102 521245 521834 521851 528501 532764 533661 533733 534609 537436 537958 538255 540548 549126 552614 656117 733841 748980 755338 785201 ] |
||||||||||||||||||||||||||||||
|
18.36 ms (10.88%) |
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 411809 447998 448002 452654 453373 453785 460330 464231 466061 468102 468430 469311 476142 483901 484717 488294 453663 458609 461741 461939 463376 463934 465315 474567 489312 493616 493658 447912 452634 455897 456696 457879 458196 465392 468349 470129 478413 485136 489846 491584 493591 493758 497453 497635 518454 519102 521245 528501 532764 509600 509725 512948 513469 515693 533733 537958 499884 500815 511867 521851 533661 534609 538255 540548 508184 511431 511481 521834 537436 464700 465522 466679 468359 468366 482193 493614 549126 552614 656117 785201 733841 748980 755338 326305 397322 400114 402242 402931 407871 410590 414194 430815 434767 453047 453485 466690 468338 471992 473231 473486 411033 447634 452683 458443 461396 468109 479369 386845 398253 403424 415292 426001 428593 447134 447567 456469 456558 457146 458136 465550 ] |
||||||||||||||||||||||||||||||
|
4.37 ms (2.59%) |
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 326305 386845 397322 398253 400114 402242 402931 403424 407871 410590 411033 411809 414194 415292 426001 428593 430815 434767 447134 447567 447634 447912 447998 448002 452634 452654 452683 453047 453373 453485 453663 453785 455897 456469 456558 456696 457146 457879 458136 458196 458443 458609 460330 461396 461741 461939 463376 463934 464231 464700 465315 465392 465522 465550 466061 466679 466690 468102 468109 468338 468349 468359 468366 468430 469311 470129 471992 473231 473486 474567 476142 478413 479369 482193 483901 484717 485136 488294 489312 489846 491584 493591 493614 493616 493658 493758 497453 497635 499884 500815 508184 509600 509725 511431 511481 511867 512948 513469 515693 518454 519102 521245 521834 521851 528501 532764 533661 533733 534609 537436 537958 538255 540548 549126 552614 656117 733841 748980 755338 785201 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal white"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал white"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал white"
]
|
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.