Query Metrics
7
Database Queries
7
Different statements
166.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.44 ms (83.54%) |
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 13767 17037 24289 145502 172220 185435 212024 233532 366283 382154 383244 384801 387182 395714 398325 401007 401584 404237 427425 430566 439560 441181 452445 454226 458257 458744 459120 460529 461188 464780 464936 465876 468475 468641 470387 470424 473550 474076 475607 476028 476339 476966 477382 477981 482328 484874 485958 490806 490915 490946 502681 507127 510750 514785 516473 516736 518840 520033 521366 521876 523785 526480 527737 538191 538432 538996 542953 544570 547277 550219 552193 552229 554265 559383 560400 562961 563217 565994 566892 569847 570006 570276 570526 571881 572124 572171 572364 572423 572442 573004 573850 575070 575796 580772 653229 657279 663459 665507 665840 665876 696082 710605 712337 712674 718560 721329 721792 726476 726492 726841 737169 738070 742892 744887 747568 756021 769755 794679 803217 823388 ] |
||||||||||||||||||||||||||||||
|
17.55 ms (10.52%) |
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 726476 726492 744887 769755 738070 742892 747568 756021 726841 737169 712337 712674 721792 794679 803217 366283 383244 401584 404237 464780 473550 17037 398325 461188 482328 233532 441181 458744 465876 470387 477382 502681 521876 485958 527737 520033 526480 538191 538432 514785 521366 382154 452445 468641 464936 470424 550219 563217 560400 562961 145502 384801 395714 401007 454226 439560 474076 476339 476028 477981 510750 490915 516473 490946 518840 212024 185435 172220 24289 13767 387182 430566 427425 823388 459120 475607 476966 490806 458257 468475 460529 484874 538996 507127 516736 523785 559383 565994 570526 572124 572442 575796 542953 547277 554265 569847 570006 572171 572423 573004 573850 580772 544570 552193 552229 566892 570276 571881 572364 575070 657279 663459 665840 665876 721329 653229 665507 696082 710605 718560 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.53%) |
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 13767 17037 24289 145502 172220 185435 212024 233532 366283 382154 383244 384801 387182 395714 398325 401007 401584 404237 427425 430566 439560 441181 452445 454226 458257 458744 459120 460529 461188 464780 464936 465876 468475 468641 470387 470424 473550 474076 475607 476028 476339 476966 477382 477981 482328 484874 485958 490806 490915 490946 502681 507127 510750 514785 516473 516736 518840 520033 521366 521876 523785 526480 527737 538191 538432 538996 542953 544570 547277 550219 552193 552229 554265 559383 560400 562961 563217 565994 566892 569847 570006 570276 570526 571881 572124 572171 572364 572423 572442 573004 573850 575070 575796 580772 653229 657279 663459 665507 665840 665876 696082 710605 712337 712674 718560 721329 721792 726476 726492 726841 737169 738070 742892 744887 747568 756021 769755 794679 803217 823388 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing boy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing парен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing парен"
]
|
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.