Query Metrics
7
Database Queries
7
Different statements
185.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.42 ms (86.92%) |
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 176298 370928 393082 409053 418383 418778 421831 421880 422134 422202 422278 422283 424914 426525 429461 432876 433291 437305 437599 439611 439671 442408 442661 443809 445884 448458 448558 451520 452336 453184 454044 454220 454868 455859 455965 456934 457191 457207 457575 458012 458018 459407 460143 460704 460725 460865 462350 463208 463691 464805 465240 465362 465373 465545 466274 466711 466775 468999 470898 472650 472656 473118 474097 474790 474891 474897 475311 476289 477794 477870 477950 486112 490769 493155 493158 496101 502211 507381 507749 508678 513063 513425 514883 515705 516832 521490 522931 525087 526394 532056 549644 554403 558639 562178 566859 573519 580363 588559 606644 627870 668459 697909 716566 744184 753205 753764 761230 766903 778994 784085 796449 798581 799131 801542 801933 807352 808017 808416 809354 813916 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (8.28%) |
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 452336 454868 459407 473118 409053 457191 474891 477870 445884 466775 476289 477950 418383 470898 442408 466274 486112 522931 514883 521490 475311 753205 627870 457575 370928 496101 422202 429461 439671 463208 455859 474097 507381 558639 562178 573519 422283 433291 443809 421880 439611 474897 421831 448558 465362 465373 424914 437599 451520 460725 462350 493155 493158 508678 525087 490769 507749 513425 515705 813916 454220 458012 393082 472656 526394 580363 697909 453184 801933 801542 422134 422278 426525 442661 432876 418778 437305 455965 463691 465240 448458 454044 464805 458018 460143 502211 513063 516832 532056 460865 466711 472650 549644 554403 566859 668459 606644 588559 778994 798581 807352 796449 809354 744184 784085 808017 808416 761230 753764 766903 716566 799131 460704 465545 477794 176298 456934 457207 468999 474790 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.33%) |
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 176298 370928 393082 409053 418383 418778 421831 421880 422134 422202 422278 422283 424914 426525 429461 432876 433291 437305 437599 439611 439671 442408 442661 443809 445884 448458 448558 451520 452336 453184 454044 454220 454868 455859 455965 456934 457191 457207 457575 458012 458018 459407 460143 460704 460725 460865 462350 463208 463691 464805 465240 465362 465373 465545 466274 466711 466775 468999 470898 472650 472656 473118 474097 474790 474891 474897 475311 476289 477794 477870 477950 486112 490769 493155 493158 496101 502211 507381 507749 508678 513063 513425 514883 515705 516832 521490 522931 525087 526394 532056 549644 554403 558639 562178 566859 573519 580363 588559 606644 627870 668459 697909 716566 744184 753205 753764 761230 766903 778994 784085 796449 798581 799131 801542 801933 807352 808017 808416 809354 813916 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mom boy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск mom парен"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск mom парен"
]
|
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.