Query Metrics
7
Database Queries
7
Different statements
137.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.08 ms (83.28%) |
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 34452 66574 72889 94879 209171 233748 373842 382236 383707 385953 389181 391890 396517 397413 408998 410413 412177 415896 421593 427362 427949 429040 429144 429588 429649 434952 438877 442626 443847 456816 457740 460824 462585 465673 468899 475338 478265 478464 484051 487102 489173 492109 493141 497119 523282 527234 528943 540136 545121 551185 555092 558113 559219 572427 572862 573915 577346 577455 577620 578490 580736 580864 580884 584710 591134 597079 601031 614094 616347 621174 624874 633112 637469 644462 660146 663241 663438 663474 665364 669201 680959 680974 684574 691267 692333 693356 696310 705791 714032 714655 722536 722670 744294 745999 746164 755411 768451 770667 770929 773822 775492 776954 785382 785559 786588 793811 797775 798579 809057 809481 812129 817805 818742 818983 819374 828095 828133 828175 828315 828373 ] |
||||||||||||||||||||||||||||||
|
12.05 ms (8.80%) |
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 714655 663241 665364 684574 692333 693356 696310 680974 722670 555092 809057 812129 768451 770667 644462 410413 66574 465673 580736 680959 705791 577346 776954 744294 755411 785382 412177 385953 578490 382236 389181 34452 396517 427949 438877 828133 828095 540136 94879 209171 558113 429649 383707 818742 442626 456816 577455 624874 443847 475338 408998 460824 415896 818983 817805 457740 573915 559219 660146 663438 669201 722536 545121 614094 601031 621174 770929 797775 798579 793811 809481 72889 523282 373842 429040 493141 487102 572427 572862 580864 551185 663474 591134 597079 775492 745999 773822 633112 785559 478464 233748 429588 468899 462585 434952 478265 584710 637469 497119 580884 616347 421593 786588 714032 429144 819374 828315 528943 746164 489173 484051 397413 577620 427362 492109 828373 828175 691267 391890 527234 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.75%) |
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 34452 66574 72889 94879 209171 233748 373842 382236 383707 385953 389181 391890 396517 397413 408998 410413 412177 415896 421593 427362 427949 429040 429144 429588 429649 434952 438877 442626 443847 456816 457740 460824 462585 465673 468899 475338 478265 478464 484051 487102 489173 492109 493141 497119 523282 527234 528943 540136 545121 551185 555092 558113 559219 572427 572862 573915 577346 577455 577620 578490 580736 580864 580884 584710 591134 597079 601031 614094 616347 621174 624874 633112 637469 644462 660146 663241 663438 663474 665364 669201 680959 680974 684574 691267 692333 693356 696310 705791 714032 714655 722536 722670 744294 745999 746164 755411 768451 770667 770929 773822 775492 776954 785382 785559 786588 793811 797775 798579 809057 809481 812129 817805 818742 818983 819374 828095 828133 828175 828315 828373 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde public masturbations"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая на masturbations улиц"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая на masturbations улиц"
]
|
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.