Query Metrics
7
Database Queries
7
Different statements
226.36 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.50 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.75 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в душе минет"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.45 ms |
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 603121 653273 383069 786136 722368 386787 466016 441762 758386 770065 809676 436675 247545 436452 477964 731257 367863 467847 22861 34563 451661 571298 780072 733958 509471 721859 425577 732755 457030 544589 795109 809809 544168 799523 393188 609505 726767 729412 24243 635355 769059 551973 419013 427021 514282 793989 779274 762854 779930 474994 802368 454442 470721 677913 575766 650221 606195 778948 793933 784786 745360 754843 521663 501342 719807 396893 535580 791981 383359 396816 531995 680675 547621 634341 387883 457994 797263 764946 23687 791308 781004 391581 755935 418434 447642 197358 33689 409085 774468 526995 533731 557031 701910 685637 190773 725922 685450 660867 782918 778183 805624 803262 475589 384169 528215 457686 575108 800095 764453 768110 764292 388050 778011 593168 516382 394773 395887 576035 651852 474199 ] |
||||||||||||||||||||||||||||||
| 4 | 2.48 ms |
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 22861 23687 24243 33689 34563 190773 197358 247545 367863 383069 383359 384169 386787 387883 388050 391581 393188 394773 395887 396816 396893 409085 418434 419013 425577 427021 436452 436675 441762 447642 451661 454442 457030 457686 457994 466016 467847 470721 474199 474994 475589 477964 501342 509471 514282 516382 521663 526995 528215 531995 533731 535580 544168 544589 547621 551973 557031 571298 575108 575766 576035 593168 603121 606195 609505 634341 635355 650221 651852 653273 660867 677913 680675 685450 685637 701910 719807 721859 722368 725922 726767 729412 731257 732755 733958 745360 754843 755935 758386 762854 764292 764453 764946 768110 769059 770065 774468 778011 778183 778948 779274 779930 780072 781004 782918 784786 786136 791308 791981 793933 793989 795109 797263 799523 800095 802368 803262 805624 809676 809809 ] |
||||||||||||||||||||||||||||||
| 5 | 202.30 ms |
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 22861 23687 24243 33689 34563 190773 197358 247545 367863 383069 383359 384169 386787 387883 388050 391581 393188 394773 395887 396816 396893 409085 418434 419013 425577 427021 436452 436675 441762 447642 451661 454442 457030 457686 457994 466016 467847 470721 474199 474994 475589 477964 501342 509471 514282 516382 521663 526995 528215 531995 533731 535580 544168 544589 547621 551973 557031 571298 575108 575766 576035 593168 603121 606195 609505 634341 635355 650221 651852 653273 660867 677913 680675 685450 685637 701910 719807 721859 722368 725922 726767 729412 731257 732755 733958 745360 754843 755935 758386 762854 764292 764453 764946 768110 769059 770065 774468 778011 778183 778948 779274 779930 780072 781004 782918 784786 786136 791308 791981 793933 793989 795109 797263 799523 800095 802368 803262 805624 809676 809809 ] |
||||||||||||||||||||||||||||||
| 6 | 1.89 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван минет оральн секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.98 ms |
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.