Query Metrics
7
Database Queries
7
Different statements
167.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.71 ms (86.64%) |
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 21397 32485 261656 340242 397508 398465 399022 405584 413507 418403 422075 423796 424535 424541 425249 427429 434359 443852 455770 457349 458396 458952 460063 460435 461117 462815 470131 472075 474908 475371 476535 476595 476634 481561 485748 486506 486570 486988 492271 498078 498703 499968 501621 504603 505423 507433 508219 510100 510179 510316 510723 513411 514266 516943 520799 521884 524387 528021 546750 551166 553949 557421 558966 559277 559480 560387 562445 564096 564139 567231 574236 580704 590406 591385 593212 594911 598884 599761 601991 609596 619724 619806 623355 627986 634016 639218 644885 649723 657834 663335 667436 667449 668022 672402 673092 682502 690439 695961 704487 706260 721249 721908 729564 730419 746224 749151 760206 762019 762632 762984 767801 772789 799424 799518 802262 817622 817685 818729 820484 821558 ] |
||||||||||||||||||||||||||||||
|
12.01 ms (7.19%) |
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 553949 682502 557421 397508 507433 486570 461117 457349 485748 462815 551166 418403 475371 474908 472075 558966 663335 521884 486988 510723 690439 398465 528021 639218 481561 609596 598884 514266 667436 623355 799424 423796 510179 405584 799518 458952 760206 817685 619806 772789 729564 821558 820484 443852 470131 460435 562445 564139 590406 476535 510316 32485 593212 546750 476634 508219 580704 721249 762984 455770 520799 510100 504603 762632 425249 498703 559277 706260 649723 657834 668022 802262 762019 767801 704487 501621 619724 634016 817622 695961 672402 594911 749151 564096 492271 340242 458396 560387 434359 627986 486506 574236 721908 673092 498078 818729 591385 516943 746224 424535 413507 21397 427429 601991 460063 599761 399022 424541 730419 567231 261656 667449 644885 513411 499968 524387 422075 476595 505423 559480 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.81%) |
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 21397 32485 261656 340242 397508 398465 399022 405584 413507 418403 422075 423796 424535 424541 425249 427429 434359 443852 455770 457349 458396 458952 460063 460435 461117 462815 470131 472075 474908 475371 476535 476595 476634 481561 485748 486506 486570 486988 492271 498078 498703 499968 501621 504603 505423 507433 508219 510100 510179 510316 510723 513411 514266 516943 520799 521884 524387 528021 546750 551166 553949 557421 558966 559277 559480 560387 562445 564096 564139 567231 574236 580704 590406 591385 593212 594911 598884 599761 601991 609596 619724 619806 623355 627986 634016 639218 644885 649723 657834 663335 667436 667449 668022 672402 673092 682502 690439 695961 704487 706260 721249 721908 729564 730419 746224 749151 760206 762019 762632 762984 767801 772789 799424 799518 802262 817622 817685 818729 820484 821558 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car teens blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин teens минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вмашин teens минет оральн секс"
]
|
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.