Query Metrics
7
Database Queries
7
Different statements
190.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.19 ms (85.06%) |
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 234200 383660 386568 395625 395895 401362 407208 408413 409252 409640 412378 421695 422925 427187 428424 430342 443581 446937 447483 452063 452068 452446 457387 458462 459248 459803 460954 463726 465186 465856 466027 466831 468011 468379 468594 468945 469574 470703 475585 476228 476931 479197 481323 481684 483571 486027 486301 486883 487198 488877 489623 490448 491271 492592 494397 495678 495719 496715 497766 498852 499823 499849 502736 503887 503901 504352 506737 509434 512785 513139 519241 519386 519928 520172 520660 521092 521230 522472 523573 527869 528884 536647 542241 543114 543442 543708 547900 548230 548297 551249 555341 555790 556841 557022 558841 560086 560088 560958 562714 563212 566385 569666 573311 573406 573763 576703 581380 583835 589775 590355 591288 591795 592660 593405 596234 597094 620108 682537 731371 742280 ] |
||||||||||||||||||||||||||||||
|
18.64 ms (9.77%) |
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 560088 590355 492592 495678 457387 470703 497766 463726 573406 543442 555790 620108 519928 491271 494397 521092 506737 486883 428424 521230 519386 547900 562714 589775 509434 409640 504352 408413 487198 513139 469574 566385 551249 581380 593405 597094 742280 409252 421695 465856 475585 527869 452063 476931 468945 486027 468011 468379 556841 443581 489623 573311 401362 446937 386568 452446 523573 536647 459248 479197 583835 596234 548230 234200 481323 563212 591288 502736 499849 466831 466027 447483 476228 495719 512785 407208 548297 560086 499823 490448 498852 558841 560958 503901 452068 520172 592660 520660 569666 483571 481684 543114 682537 519241 412378 465186 458462 427187 528884 486301 383660 496715 488877 430342 395895 460954 468594 543708 555341 542241 557022 395625 522472 576703 731371 422925 459803 573763 591795 503887 ] |
||||||||||||||||||||||||||||||
|
3.46 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 234200 383660 386568 395625 395895 401362 407208 408413 409252 409640 412378 421695 422925 427187 428424 430342 443581 446937 447483 452063 452068 452446 457387 458462 459248 459803 460954 463726 465186 465856 466027 466831 468011 468379 468594 468945 469574 470703 475585 476228 476931 479197 481323 481684 483571 486027 486301 486883 487198 488877 489623 490448 491271 492592 494397 495678 495719 496715 497766 498852 499823 499849 502736 503887 503901 504352 506737 509434 512785 513139 519241 519386 519928 520172 520660 521092 521230 522472 523573 527869 528884 536647 542241 543114 543442 543708 547900 548230 548297 551249 555341 555790 556841 557022 558841 560086 560088 560958 562714 563212 566385 569666 573311 573406 573763 576703 581380 583835 589775 590355 591288 591795 592660 593405 596234 597094 620108 682537 731371 742280 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатый минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"волосатый минет"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.77%) |
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.