Query Metrics
7
Database Queries
7
Different statements
175.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.17 ms (85.17%) |
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 47606 50215 229345 274758 313286 314133 318463 326115 358778 383418 384033 384298 384566 386719 386974 387938 388935 390747 392024 392031 392984 393524 393700 393727 395459 395724 397456 397911 398003 398462 399023 399267 401059 402032 405966 407538 407561 407707 408425 409882 411406 411941 413516 416335 417362 418334 420253 423637 423919 424414 424483 424562 425395 425684 425875 426000 428022 431152 432086 443834 444327 447456 451872 452145 454857 455045 455325 459192 459831 461785 462508 462961 465214 466052 467370 469862 470673 473510 474807 477959 477992 482547 483242 483609 484140 484374 489577 489822 492361 493096 496108 502193 502289 508120 509498 510636 516783 546660 552423 558432 559520 563058 570672 571600 571637 573231 603159 607125 727111 743968 757519 761555 768226 772440 773198 775600 777128 781999 786880 826739 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (9.39%) |
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 743968 772440 786880 757519 768226 727111 773198 777128 50215 418334 423637 392984 398003 459831 384033 383418 387938 314133 425684 393727 393524 395724 313286 326115 405966 407707 420253 417362 411941 432086 477959 447456 469862 462961 493096 516783 496108 502289 571600 571637 563058 546660 570672 607125 781999 397911 408425 423919 455045 477992 384566 407561 431152 462508 392024 392031 424414 425395 426000 443834 395459 399267 411406 467370 470673 424483 484140 508120 483609 489822 510636 483242 484374 489577 474807 502193 454857 416335 459192 761555 603159 428022 401059 47606 473510 509498 466052 452145 444327 425875 390747 388935 492361 573231 398462 826739 775600 386974 402032 386719 274758 399023 558432 318463 384298 358778 397456 409882 482547 451872 465214 461785 455325 552423 559520 393700 407538 413516 424562 229345 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.46%) |
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 47606 50215 229345 274758 313286 314133 318463 326115 358778 383418 384033 384298 384566 386719 386974 387938 388935 390747 392024 392031 392984 393524 393700 393727 395459 395724 397456 397911 398003 398462 399023 399267 401059 402032 405966 407538 407561 407707 408425 409882 411406 411941 413516 416335 417362 418334 420253 423637 423919 424414 424483 424562 425395 425684 425875 426000 428022 431152 432086 443834 444327 447456 451872 452145 454857 455045 455325 459192 459831 461785 462508 462961 465214 466052 467370 469862 470673 473510 474807 477959 477992 482547 483242 483609 484140 484374 489577 489822 492361 493096 496108 502193 502289 508120 509498 510636 516783 546660 552423 558432 559520 563058 570672 571600 571637 573231 603159 607125 727111 743968 757519 761555 768226 772440 773198 775600 777128 781999 786880 826739 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"видео ролики куни"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"виде ролик куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.