Query Metrics
7
Database Queries
7
Different statements
176.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.92 ms (87.09%) |
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 6640 6669 6864 226028 314552 387074 392986 400436 416772 439855 439930 441016 443590 451565 453037 457585 457701 459437 463862 465850 468385 469351 469609 472343 473088 474272 476744 478572 485320 488717 493231 494058 509825 516024 516131 530306 531929 533767 534560 537393 541568 542173 543720 559214 559324 562265 563989 565110 565119 566687 566695 568251 569225 570087 570491 573871 575170 584710 610034 610559 620051 621438 626154 628656 630279 631187 632557 633238 649133 659009 659033 663769 672145 676127 686152 690153 693051 693356 694288 699385 699621 705710 706930 710400 711902 712001 719057 720332 720444 720445 722190 723549 725112 727796 728297 735130 752658 760904 761152 761155 761193 766696 767159 770532 773907 775203 775497 784816 790846 792246 794331 794791 805241 805642 815071 816602 817496 819119 823351 828184 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (7.51%) |
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 620051 794791 775497 387074 465850 473088 468385 469609 565110 570491 565119 562265 570087 573871 621438 626154 400436 472343 509825 693356 728297 760904 752658 543720 725112 463862 476744 699621 474272 451565 459437 6864 761152 710400 314552 723549 816602 819119 815071 537393 542173 659009 693051 720444 672145 686152 706930 720445 722190 568251 633238 630279 631187 792246 773907 735130 761155 761193 770532 794331 6640 530306 563989 676127 694288 628656 610034 784816 805241 766696 727796 767159 699385 775203 790846 416772 559214 575170 663769 610559 439930 441016 488717 690153 453037 469351 566695 533767 494058 443590 541568 457585 817496 828184 485320 566687 705710 457701 439855 392986 559324 516024 584710 226028 478572 493231 720332 569225 516131 534560 649133 659033 719057 632557 711902 712001 805642 6669 823351 531929 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.58%) |
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 6640 6669 6864 226028 314552 387074 392986 400436 416772 439855 439930 441016 443590 451565 453037 457585 457701 459437 463862 465850 468385 469351 469609 472343 473088 474272 476744 478572 485320 488717 493231 494058 509825 516024 516131 530306 531929 533767 534560 537393 541568 542173 543720 559214 559324 562265 563989 565110 565119 566687 566695 568251 569225 570087 570491 573871 575170 584710 610034 610559 620051 621438 626154 628656 630279 631187 632557 633238 649133 659009 659033 663769 672145 676127 686152 690153 693051 693356 694288 699385 699621 705710 706930 710400 711902 712001 719057 720332 720444 720445 722190 723549 725112 727796 728297 735130 752658 760904 761152 761155 761193 766696 767159 770532 773907 775203 775497 784816 790846 792246 794331 794791 805241 805642 815071 816602 817496 819119 823351 828184 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на teen улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на teen улиц анал"
]
|
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.