Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "amateur older"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'amateur older' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  488920
  721090
  476268
  419552
  476264
  470771
  472122
  398201
  450400
  464296
  589670
  800563
  748662
  436693
  479967
  453740
  486507
  385171
  672766
  790986
  400438
  423754
  476703
  583595
  727747
  472700
  525898
  540343
  567194
  571799
  587434
  463169
  420431
  524176
  503955
  435236
  516455
  572195
  787309
  800373
  438619
  484462
  525717
  670040
  721538
  535422
  545530
  518085
  507362
  544067
  564701
  567187
  558983
  623501
  421991
  517831
  470359
  476278
  444267
  516922
  522441
  562109
  670041
  467452
  492239
  618718
  497337
  565710
  588071
  426908
  522986
  484556
  677108
  449868
  389519
  472918
  466007
  466176
  625770
  455151
  396168
  598592
  564786
  527608
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (488920, 721090, 476268, 419552, 476264, 470771, 472122, 398201, 450400, 464296, 589670, 800563, 748662, 436693, 479967, 453740, 486507, 385171, 672766, 790986, 400438, 423754, 476703, 583595, 727747, 472700, 525898, 540343, 567194, 571799, 587434, 463169, 420431, 524176, 503955, 435236, 516455, 572195, 787309, 800373, 438619, 484462, 525717, 670040, 721538, 535422, 545530, 518085, 507362, 544067, 564701, 567187, 558983, 623501, 421991, 517831, 470359, 476278, 444267, 516922, 522441, 562109, 670041, 467452, 492239, 618718, 497337, 565710, 588071, 426908, 522986, 484556, 677108, 449868, 389519, 472918, 466007, 466176, 625770, 455151, 396168, 598592, 564786, 527608);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  385171
  389519
  396168
  398201
  400438
  419552
  420431
  421991
  423754
  426908
  435236
  436693
  438619
  444267
  449868
  450400
  453740
  455151
  463169
  464296
  466007
  466176
  467452
  470359
  470771
  472122
  472700
  472918
  476264
  476268
  476278
  476703
  479967
  484462
  484556
  486507
  488920
  492239
  497337
  503955
  507362
  516455
  516922
  517831
  518085
  522441
  522986
  524176
  525717
  525898
  527608
  535422
  540343
  544067
  545530
  558983
  562109
  564701
  564786
  565710
  567187
  567194
  571799
  572195
  583595
  587434
  588071
  589670
  598592
  618718
  623501
  625770
  670040
  670041
  672766
  677108
  721090
  721538
  727747
  748662
  787309
  790986
  800373
  800563
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (385171, 389519, 396168, 398201, 400438, 419552, 420431, 421991, 423754, 426908, 435236, 436693, 438619, 444267, 449868, 450400, 453740, 455151, 463169, 464296, 466007, 466176, 467452, 470359, 470771, 472122, 472700, 472918, 476264, 476268, 476278, 476703, 479967, 484462, 484556, 486507, 488920, 492239, 497337, 503955, 507362, 516455, 516922, 517831, 518085, 522441, 522986, 524176, 525717, 525898, 527608, 535422, 540343, 544067, 545530, 558983, 562109, 564701, 564786, 565710, 567187, 567194, 571799, 572195, 583595, 587434, 588071, 589670, 598592, 618718, 623501, 625770, 670040, 670041, 672766, 677108, 721090, 721538, 727747, 748662, 787309, 790986, 800373, 800563);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  385171
  389519
  396168
  398201
  400438
  419552
  420431
  421991
  423754
  426908
  435236
  436693
  438619
  444267
  449868
  450400
  453740
  455151
  463169
  464296
  466007
  466176
  467452
  470359
  470771
  472122
  472700
  472918
  476264
  476268
  476278
  476703
  479967
  484462
  484556
  486507
  488920
  492239
  497337
  503955
  507362
  516455
  516922
  517831
  518085
  522441
  522986
  524176
  525717
  525898
  527608
  535422
  540343
  544067
  545530
  558983
  562109
  564701
  564786
  565710
  567187
  567194
  571799
  572195
  583595
  587434
  588071
  589670
  598592
  618718
  623501
  625770
  670040
  670041
  672766
  677108
  721090
  721538
  727747
  748662
  787309
  790986
  800373
  800563
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (385171, 389519, 396168, 398201, 400438, 419552, 420431, 421991, 423754, 426908, 435236, 436693, 438619, 444267, 449868, 450400, 453740, 455151, 463169, 464296, 466007, 466176, 467452, 470359, 470771, 472122, 472700, 472918, 476264, 476268, 476278, 476703, 479967, 484462, 484556, 486507, 488920, 492239, 497337, 503955, 507362, 516455, 516922, 517831, 518085, 522441, 522986, 524176, 525717, 525898, 527608, 535422, 540343, 544067, 545530, 558983, 562109, 564701, 564786, 565710, 567187, 567194, 571799, 572195, 583595, 587434, 588071, 589670, 598592, 618718, 623501, 625770, 670040, 670041, 672766, 677108, 721090, 721538, 727747, 748662, 787309, 790986, 800373, 800563);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "любительск older"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'любительск older';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "любительск older"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'любительск older';