Query Metrics
7
Database Queries
7
Different statements
158.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.74 ms (82.41%) |
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 96524 96623 130468 182749 192691 198857 324183 341691 387544 390538 393326 395646 396030 398317 400940 404800 404804 407290 409615 410940 420562 436690 453352 454984 456430 467581 468622 470541 472431 480452 489280 490304 502489 530295 530497 531256 533743 535466 537206 537776 537887 542877 544749 544751 564554 565250 565255 583507 604420 605337 609906 612976 620471 621066 632593 633179 633602 634480 635835 639254 644310 647875 647898 650373 650762 652850 654097 666886 670997 674507 681515 683564 683584 684048 685775 686183 688660 692096 692261 695096 695923 699667 699719 702164 702342 708444 713113 714552 715790 718159 722607 723094 730329 733843 733883 734412 738121 738556 740269 744390 745924 750719 766704 767036 775883 775893 775919 777876 782439 792583 796430 796652 801942 805228 811425 811941 814888 817139 817624 822304 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (10.43%) |
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 666886 605337 639254 811425 801942 644310 714552 715790 775893 792583 404804 407290 395646 398317 390538 409615 198857 130468 192691 817139 692261 685775 612976 620471 782439 796430 734412 767036 738556 744390 777876 490304 537206 468622 565250 565255 650762 702164 453352 400940 410940 670997 688660 683564 695096 722607 683584 699667 621066 730329 775919 420562 502489 583507 647898 609906 454984 467581 489280 632593 436690 531256 542877 708444 647875 733883 733843 393326 341691 182749 817624 822304 530295 544751 564554 650373 654097 681515 695923 713113 652850 686183 692096 718159 544749 633179 635835 633602 775883 805228 796652 766704 750719 738121 740269 745924 604420 634480 699719 702342 723094 811941 324183 96623 396030 96524 387544 404800 814888 456430 480452 470541 530497 537776 533743 537887 535466 472431 674507 684048 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (2.12%) |
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 96524 96623 130468 182749 192691 198857 324183 341691 387544 390538 393326 395646 396030 398317 400940 404800 404804 407290 409615 410940 420562 436690 453352 454984 456430 467581 468622 470541 472431 480452 489280 490304 502489 530295 530497 531256 533743 535466 537206 537776 537887 542877 544749 544751 564554 565250 565255 583507 604420 605337 609906 612976 620471 621066 632593 633179 633602 634480 635835 639254 644310 647875 647898 650373 650762 652850 654097 666886 670997 674507 681515 683564 683584 684048 685775 686183 688660 692096 692261 695096 695923 699667 699719 702164 702342 708444 713113 714552 715790 718159 722607 723094 730329 733843 733883 734412 738121 738556 740269 744390 745924 750719 766704 767036 775883 775893 775919 777876 782439 792583 796430 796652 801942 805228 811425 811941 814888 817139 817624 822304 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen double penetration"
]
|
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.