block
template
block_id
widget
menu_id
filterService
countries
years
categories
items
count
category
creditors
content
obLevel
__env
app
errors
domain
publicKey
mappers
inline
language
apiJsUrl
hasAction
backgroundMode
select * from `structure_pages` where `structure_pages`.`id` = 188 limit 1
select * from `structure_pages_lang` where `structure_pages_lang`.`page_id` in (188)
select usefull_information.*, usefull_information_lang.title AS title, usefull_information_categories.alias AS category_alias, ( SELECT GROUP_CONCAT(country.code ORDER BY `rank` DESC) FROM country LEFT JOIN usefull_information_vs_country ON country.id = usefull_information_vs_country.country_id WHERE usefull_information_vs_country.usefull_information_id = usefull_information.id AND country.is_active ) AS codes from `usefull_information` left join `usefull_information_lang` on `usefull_information_lang`.`usefull_information_id` = `usefull_information`.`id` left join `usefull_information_categories` on `usefull_information`.`category_id` = `usefull_information_categories`.`id` left join `usefull_information_categories_lang` on `usefull_information_categories`.`id` = `usefull_information_categories_lang`.`category_id` left join `usefull_information_vs_country` on `usefull_information`.`id` = `usefull_information_vs_country`.`usefull_information_id` where `usefull_information_lang`.`locale` = 'am' and `usefull_information_categories_lang`.`locale` = 'am' and `usefull_information`.`is_active` = 1 and `usefull_information`.`published_from` <= 1736305433 and `usefull_information`.`published_to` >= 1736305433 and `usefull_information`.`content_langs` like '%am%' and `usefull_information_vs_country`.`country_id` = 7 and FROM_UNIXTIME(published_from, '%Y') = 2023 order by `usefull_information`.`published_from` desc limit 8 offset 0
select * from `structure_pages` where `structure_pages`.`id` = 364 limit 1
select * from `structure_pages_lang` where `structure_pages_lang`.`page_id` in (364)
select * from `structure_pages` where `structure_pages`.`id` = 365 limit 1
select * from `structure_pages_lang` where `structure_pages_lang`.`page_id` in (365)
select usefull_information_categories.*, (SELECT CONCAT(title, '****', usefull_information_categories.alias) FROM usefull_information_categories_lang WHERE usefull_information_categories_lang.category_id = usefull_information_categories.id AND locale = 'am' ) AS lang_data from `usefull_information_categories` right join `usefull_information` on `usefull_information`.`category_id` = `usefull_information_categories`.`id` left join `usefull_information_vs_country` on `usefull_information`.`id` = `usefull_information_vs_country`.`usefull_information_id` where `usefull_information_categories`.`is_active` = 1 and `usefull_information`.`is_active` = 1 and `usefull_information`.`published_from` <= 1736305433 and `usefull_information`.`published_to` >= 1736305433 and `usefull_information`.`content_langs` like '%am%' and `usefull_information_vs_country`.`country_id` = 7 and (published_from IS NOT NULL AND FROM_UNIXTIME(published_from, '%Y') = 2023) group by `usefull_information_categories`.`id` order by `usefull_information_categories`.`rank` desc
select usefull_information.*, usefull_information_lang.title AS title, usefull_information_categories.alias AS category_alias, ( SELECT GROUP_CONCAT(country.code ORDER BY `rank` DESC) FROM country LEFT JOIN usefull_information_vs_country ON country.id = usefull_information_vs_country.country_id WHERE usefull_information_vs_country.usefull_information_id = usefull_information.id AND country.is_active ) AS codes from `usefull_information` left join `usefull_information_lang` on `usefull_information_lang`.`usefull_information_id` = `usefull_information`.`id` left join `usefull_information_categories` on `usefull_information`.`category_id` = `usefull_information_categories`.`id` left join `usefull_information_categories_lang` on `usefull_information_categories`.`id` = `usefull_information_categories_lang`.`category_id` left join `usefull_information_vs_country` on `usefull_information`.`id` = `usefull_information_vs_country`.`usefull_information_id` where `usefull_information_lang`.`locale` = 'am' and `usefull_information_categories_lang`.`locale` = 'am' and `usefull_information`.`is_active` = 1 and `usefull_information`.`published_from` <= 1736305433 and `usefull_information`.`published_to` >= 1736305433 and `usefull_information`.`content_langs` like '%am%' and `usefull_information_vs_country`.`country_id` = 7 and FROM_UNIXTIME(published_from, '%Y') = 2023
select * from `creditor` where `category_id` = 12 and `is_active` = 1 order by `rank` desc
select * from `creditor_lang` where `creditor_lang`.`creditor_id` in (129, 130, 131, 132, 133, 134, 187, 207, 217, 218)
select * from `structure_domains` where `structure_domains`.`id` = 12 limit 1
select * from `structure_domains_lang` where `structure_domains_lang`.`domain_id` in (12)
200
[]
0 of 0 array:17 [▶ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "eu4business.am" ] "content-length" => array:1 [▶ 0 => "" ] "content-type" => array:1 [▶ 0 => "" ] ]
0 of 0 array:41 [▶ "USER" => "eu4business" "HOME" => "/var/www/eu4business" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_HOST" => "eu4business.am" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "prod.eu4business.eu" "SERVER_PORT" => "443" "SERVER_ADDR" => "95.216.25.132" "REMOTE_PORT" => "52785" "REMOTE_ADDR" => "18.221.253.15" "SERVER_SOFTWARE" => "nginx/1.10.3" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/var/www/eu4business/country.eu4business.eu/app/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/useful-materials/year-2023" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "SCRIPT_FILENAME" => "/var/www/eu4business/country.eu4business.eu/app/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1736305432.9137 "REQUEST_TIME" => 1736305432 ]
0 of 0 array:5 [▶ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 08 Jan 2025 03:03:53 GMT" ] "set-cookie" => array:1 [▶ 0 => "covid_19_eu4b_session=eyJpdiI6ImZUcWRNY1BRV0ZDa0JJVk1zT0t6d3c9PSIsInZhbHVlIjoiNDkzOHo4UVJWXC9vQ01iaTBvWTQ2cXN1TWxTNlZCb0ExMitUNkFMTVwvemdlaENXSzMzc0R3TzR3N2VjbjdtXC91WEx4czY2R1dSUWpEVGx3QWZwYlBIcFM2eDFrYm94SnlVMUFvWWJhWjFydWI0UG85cFJXUmZ3cDU4VUdDMWR1a3ciLCJtYWMiOiI5NTNjNmNiOTJlNTYzYjVkYTk4YzIyM2E3YThhNDFhN2Y3NTViNTgwYzIwY2U4OTc4MzYzMzRkNmQ1NjlhNzFmIn0%3D; expires=Wed, 21-Apr-2027 11:03:53 GMT; Max-Age=72000000; path=/; httponly ◀covid_19_eu4b_session=eyJpdiI6ImZUcWRNY1BRV0ZDa0JJVk1zT0t6d3c9PSIsInZhbHVlIjoiNDkzOHo4UVJWXC9vQ01iaTBvWTQ2cXN1TWxTNlZCb0ExMitUNkFMTVwvemdlaENXSzMzc0R3TzR3N2Vjbj ▶" ] "Set-Cookie" => array:1 [▶ 0 => "covid_19_eu4b_session=eyJpdiI6ImZUcWRNY1BRV0ZDa0JJVk1zT0t6d3c9PSIsInZhbHVlIjoiNDkzOHo4UVJWXC9vQ01iaTBvWTQ2cXN1TWxTNlZCb0ExMitUNkFMTVwvemdlaENXSzMzc0R3TzR3N2VjbjdtXC91WEx4czY2R1dSUWpEVGx3QWZwYlBIcFM2eDFrYm94SnlVMUFvWWJhWjFydWI0UG85cFJXUmZ3cDU4VUdDMWR1a3ciLCJtYWMiOiI5NTNjNmNiOTJlNTYzYjVkYTk4YzIyM2E3YThhNDFhN2Y3NTViNTgwYzIwY2U4OTc4MzYzMzRkNmQ1NjlhNzFmIn0%3D; expires=Wed, 21-Apr-2027 11:03:53 GMT; path=/; httponly ◀covid_19_eu4b_session=eyJpdiI6ImZUcWRNY1BRV0ZDa0JJVk1zT0t6d3c9PSIsInZhbHVlIjoiNDkzOHo4UVJWXC9vQ01iaTBvWTQ2cXN1TWxTNlZCb0ExMitUNkFMTVwvemdlaENXSzMzc0R3TzR3N2Vjbj ▶" ] ]
0 of 0 array:4 [▶ "_token" => "FNpLY0IXJZaz57Mx6ROCKQBTnG7OC597IHiv7nFN" "_previous" => array:1 [▶ "url" => "https://eu4business.am/useful-materials/year-2023" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]