Query Metrics
7
Database Queries
7
Different statements
140.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.77 ms (84.38%) |
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 398004 420495 425562 429135 429497 432399 432548 433441 433590 433662 434610 435754 437323 437634 438031 438324 441353 441907 442442 442447 443038 447848 448227 449133 449164 450372 450585 452347 453600 454476 460570 461828 461895 463537 463590 463599 463602 463618 464190 464245 464822 466773 470119 471762 473557 476067 476477 479281 483036 484111 488067 490243 491331 494943 499953 501133 501383 502211 505422 505803 507249 507914 509997 514449 514658 516124 517908 519275 520787 524049 524071 525982 526779 543437 548599 548871 552591 554963 558918 564379 566811 571972 574141 576474 577924 579584 579664 584466 587533 589014 601164 602262 604531 606010 608413 609617 612426 614088 616581 617197 619538 624390 625266 661555 661990 696556 698312 703268 711274 713998 731064 736291 740694 750069 756601 765243 784511 787780 792365 805680 ] |
||||||||||||||||||||||||||||||
|
12.85 ms (9.13%) |
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 437323 429497 442447 450585 452347 449133 463537 470119 471762 514658 517908 524071 526779 490243 566811 576474 548871 579584 571972 661555 696556 661990 713998 558918 584466 601164 604531 606010 612426 617197 619538 608413 609617 616581 805680 740694 765243 784511 731064 750069 756601 736291 602262 703268 787780 792365 432399 432548 438324 464190 441907 425562 438031 442442 448227 450372 476477 420495 429135 434610 466773 461895 473557 479281 524049 483036 505422 499953 525982 494943 507914 698312 624390 509997 441353 433441 443038 437634 454476 476067 491331 463590 520787 502211 507249 461828 463602 464245 543437 564379 574141 548599 552591 577924 711274 554963 579664 614088 587533 589014 449164 433590 433662 447848 463618 435754 463599 464822 516124 501383 501133 484111 505803 514449 453600 488067 625266 460570 519275 398004 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.57%) |
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 398004 420495 425562 429135 429497 432399 432548 433441 433590 433662 434610 435754 437323 437634 438031 438324 441353 441907 442442 442447 443038 447848 448227 449133 449164 450372 450585 452347 453600 454476 460570 461828 461895 463537 463590 463599 463602 463618 464190 464245 464822 466773 470119 471762 473557 476067 476477 479281 483036 484111 488067 490243 491331 494943 499953 501133 501383 502211 505422 505803 507249 507914 509997 514449 514658 516124 517908 519275 520787 524049 524071 525982 526779 543437 548599 548871 552591 554963 558918 564379 566811 571972 574141 576474 577924 579584 579664 584466 587533 589014 601164 602262 604531 606010 608413 609617 612426 614088 616581 617197 619538 624390 625266 661555 661990 696556 698312 703268 711274 713998 731064 736291 740694 750069 756601 765243 784511 787780 792365 805680 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister fuck"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister секс"
]
|
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.