Query Metrics
7
Database Queries
7
Different statements
180.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.68 ms (84.17%) |
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 20190 210072 390466 401032 403641 405178 409828 419773 451531 452956 453848 466552 470631 477478 500348 514718 527792 534151 537590 543590 545076 545387 549856 550347 551032 551038 551239 551992 558714 558843 561430 567134 569202 574247 576359 579193 581676 582143 582430 583894 583985 589684 590188 591192 597225 597228 597254 597269 598106 598939 600366 601994 603172 603181 603242 603263 604844 604890 606499 607108 610847 614186 618563 630234 630857 631199 632712 633776 634812 636316 636579 638633 640083 641928 648204 650808 651062 651855 651856 653943 670040 670965 673357 676887 680202 681867 682508 684117 696998 697025 699694 709407 711891 716577 716870 717793 718970 720050 724179 731814 748242 748244 752155 756386 770205 775741 775834 775848 775862 775971 775988 784111 792356 795139 798411 805275 807958 808511 808730 815112 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (9.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 711891 603242 610847 638633 607108 603172 641928 775971 775988 808511 808730 798411 795139 724179 731814 603263 792356 210072 561430 20190 606499 598106 756386 567134 500348 545076 390466 717793 807958 452956 537590 583894 684117 718970 648204 709407 558714 597225 634812 597228 604890 632712 770205 748244 466552 514718 582143 582430 716870 545387 550347 631199 775741 748242 752155 470631 527792 636579 405178 453848 477478 579193 676887 618563 598939 636316 640083 401032 419773 403641 775848 409828 451531 551032 551038 597254 589684 815112 534151 543590 551239 569202 549856 551992 581676 583985 574247 650808 651062 670040 680202 682508 699694 651855 651856 653943 670965 696998 716577 673357 681867 697025 720050 558843 576359 600366 601994 590188 604844 630857 591192 597269 614186 633776 603181 630234 775834 784111 805275 775862 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.83%) |
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 20190 210072 390466 401032 403641 405178 409828 419773 451531 452956 453848 466552 470631 477478 500348 514718 527792 534151 537590 543590 545076 545387 549856 550347 551032 551038 551239 551992 558714 558843 561430 567134 569202 574247 576359 579193 581676 582143 582430 583894 583985 589684 590188 591192 597225 597228 597254 597269 598106 598939 600366 601994 603172 603181 603242 603263 604844 604890 606499 607108 610847 614186 618563 630234 630857 631199 632712 633776 634812 636316 636579 638633 640083 641928 648204 650808 651062 651855 651856 653943 670040 670965 673357 676887 680202 681867 682508 684117 696998 697025 699694 709407 711891 716577 716870 717793 718970 720050 724179 731814 748242 748244 752155 756386 770205 775741 775834 775848 775862 775971 775988 784111 792356 795139 798411 805275 807958 808511 808730 815112 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang big tits"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang большие сиськ"
]
|
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.