Query Metrics
7
Database Queries
7
Different statements
150.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.80 ms (84.80%) |
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 33686 53510 123199 157617 166116 185044 185834 209171 251363 282430 325863 365938 370875 381769 381917 382371 384181 384935 385220 385412 385758 386371 386576 386846 387346 387470 388020 388543 390255 390634 390702 390892 392423 393526 394713 395891 396024 396171 396371 397092 397381 397908 398126 398461 400468 401468 401492 402090 402926 403216 404019 406636 407682 408299 408420 409103 411923 411925 414933 416346 417452 428659 428663 430392 431228 431672 433558 433997 447113 447683 448631 450390 452526 453105 455954 458118 458660 458742 460127 464744 465753 467917 470451 474376 475286 481297 481309 490944 493126 500472 503121 504948 505660 507856 509916 512647 519576 537457 539058 543819 552213 555076 555984 557981 562306 563048 571631 573663 573961 573972 576323 660272 664317 677903 695113 710054 746304 750061 756499 767957 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (7.61%) |
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 555984 470451 390634 503121 450390 452526 573961 431228 398461 447683 660272 576323 756499 393526 431672 400468 433558 433997 388543 397908 401492 458660 493126 386846 386576 385412 166116 390255 417452 428663 411923 458118 563048 390892 458742 481309 402926 507856 365938 33686 388020 384935 385220 397092 664317 677903 710054 746304 385758 390702 402090 404019 409103 573972 573663 481297 401468 408299 539058 505660 53510 209171 382371 767957 396024 504948 537457 464744 403216 467917 519576 386371 157617 448631 571631 750061 474376 396371 408420 460127 394713 428659 500472 123199 455954 384181 398126 447113 465753 325863 512647 509916 381769 387346 695113 370875 414933 475286 416346 282430 251363 397381 557981 407682 430392 411925 543819 562306 552213 555076 453105 395891 490944 185044 185834 392423 381917 387470 396171 406636 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (2.98%) |
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 33686 53510 123199 157617 166116 185044 185834 209171 251363 282430 325863 365938 370875 381769 381917 382371 384181 384935 385220 385412 385758 386371 386576 386846 387346 387470 388020 388543 390255 390634 390702 390892 392423 393526 394713 395891 396024 396171 396371 397092 397381 397908 398126 398461 400468 401468 401492 402090 402926 403216 404019 406636 407682 408299 408420 409103 411923 411925 414933 416346 417452 428659 428663 430392 431228 431672 433558 433997 447113 447683 448631 450390 452526 453105 455954 458118 458660 458742 460127 464744 465753 467917 470451 474376 475286 481297 481309 490944 493126 500472 503121 504948 505660 507856 509916 512647 519576 537457 539058 543819 552213 555076 555984 557981 562306 563048 571631 573663 573961 573972 576323 660272 664317 677903 695113 710054 746304 750061 756499 767957 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кунилингус-лижет-пизду-с-разговорами мамо4"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс куннилингус оральн секс разговор мамо4"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс куннилингус оральн секс разговор мамо4"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.