Latest from the word of retail experience and its eco-system.

BENCHMARKS

Loading Time: Base Classes	0.0105
Controller Execution Time ( Search / Index )	0.3292
Total Execution Time	0.3403

GET DATA

No GET data exists

MEMORY USAGE

3,763,304 bytes

POST DATA

No POST data exists

URI STRING

search/lP/page-115

CLASS/METHOD

search/index

DATABASE: ez_retail_news (Search:$db) QUERIES: 21 (0.2950 seconds) (Hide)

0.0002	select count(id) as total from ( select id from tbl_news where (header LIKE '%lP%' OR kicker LIKE '%lP%' OR body LIKE '%lP%' OR keyword LIKE '%lP%') and status = 1 UNION select id from tbl_viewpoints where (header LIKE '%lP%' OR kicker LIKE '%lP%' OR body LIKE '%lP%' OR keyword LIKE '%lP%') and status = 1 UNION select id from tbl_video where (header LIKE '%lP%' OR description LIKE '%lP%') and status = 1 UNION select id from tbl_picture_story where (header LIKE '%lP%' OR kicker LIKE '%lP%' OR body LIKE '%lP%' OR keyword LIKE '%lP%') and status = 1 ) as tmp
0.2937	select tmp.*, tbl_news_author.name as author_name, tbl_news_author.slug as author_slug, IF(header LIKE '%lP%', 1, 5) as hpri, IF(kicker LIKE '%lP%', 2, 5) as kpri, tbl_news_category.name as category_name, tbl_news_category.slug as category_slug from ( select 'news' as section, id, header, slug, kicker, image, date_published, date(indate) as indate, old_section, old_id, author_id, category_id from tbl_news where (header LIKE '%lP%' OR kicker LIKE '%lP%' OR body LIKE '%lP%' OR keyword LIKE '%lP%') and status = 1 UNION select 'viewpoints' as section, id, header, slug, kicker, image, date_published, date(indate) as indate, old_section, old_id, author_id, category_id from tbl_viewpoints where (header LIKE '%lP%' OR kicker LIKE '%lP%' OR body LIKE '%lP%' OR keyword LIKE '%lP%') and status = 1 UNION select 'video' as section, id, header, slug, description as kicker, youtube_id as image, date_published, date(indate) as indate, '' as old_id, '' as old_section, '' as author_id, category_id from tbl_video where (header LIKE '%lP%' OR description LIKE '%lP%') and status = 1 UNION select 'picture_story' as section, id, header, slug, kicker, '' as image, date_published, date(indate) as indate, old_section, old_id, author_id, category_id from tbl_picture_story where (header LIKE '%lP%' OR kicker LIKE '%lP%' OR body LIKE '%lP%' OR keyword LIKE '%lP%') and status = 1 ) as tmp LEFT JOIN tbl_news_author ON tmp.author_id = tbl_news_author.id LEFT JOIN tbl_news_category ON tmp.category_id = tbl_news_category.id order by hpri, date_published desc, kpri limit 1710, 15
0.0001	SELECT `title`, `description`, `keywords` FROM `tbl_seo_keyward_update` WHERE `section` = 'search' AND `category` = 'lP'
0.0001	SELECT * FROM `tbl_news_subcategory` WHERE `tbl_news_categoryID` = 2 AND `status` = 1
0.0000	SELECT * FROM `tbl_news_subcategory` WHERE `tbl_news_categoryID` = 3 AND `status` = 1
0.0001	SELECT * FROM `tbl_news_subcategory` WHERE `tbl_news_categoryID` = 5 AND `status` = 1
0.0001	SELECT * FROM `tbl_news_subcategory` WHERE `tbl_news_categoryID` = 4 AND `status` = 1
0.0001	SELECT * FROM `resource_category` WHERE `status` = 1 ORDER BY `category` ASC
0.0001	SELECT * FROM `homepage_menu` WHERE `section` = 'news' AND `status` = 1
0.0001	SELECT * FROM `tbl_news` WHERE id=0
0.0000	SELECT * FROM `homepage_menu` WHERE `section` = 'project' AND `status` = 1
0.0000	SELECT * FROM `tbl_news` WHERE id=0
0.0000	SELECT * FROM `homepage_menu` WHERE `section` = 'product' AND `status` = 1
0.0000	SELECT * FROM `homepage_menu` WHERE `section` = 'viewpoint' AND `status` = 1
0.0001	SELECT * FROM `tbl_viewpoints` WHERE id=0
0.0001	SELECT * FROM `tbl_cart` WHERE `session_id` IS NULL
0.0001	SELECT `resource_category`.`resource_categoryID`, `resource_category`.`slug`, `resource_category`.`category` FROM `resource_category` WHERE `status` = '1' ORDER BY `resource_category`.`category` ASC
0.0001	SELECT DISTINCT `tbl_resource`.`resource_city` FROM `tbl_resource`
0.0001	SELECT * FROM `job_details` WHERE `job_details`.`active` = 1 AND `job_details`.`job_category` = 'jobs' ORDER BY `job_details`.`job_detailsID` DESC LIMIT 5
0.0001	SELECT * FROM `job_details` LEFT JOIN `company_details` ON `job_details`.`company_detailsID` = `company_details`.`company_detailsID` WHERE `job_details`.`active` = 1 AND `job_details`.`job_category` = 'careers' ORDER BY `job_details`.`job_detailsID` DESC LIMIT 5
0.0000	SELECT `poll`.`poll_id`, `poll`.`poll_title` FROM `poll` WHERE `status` = 1

HTTP HEADERS (Show)

SESSION DATA (Show)

__ci_last_regenerate	1776949765
subscribe_popup	1

CONFIG VARIABLES (Show)

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION
SERVER_PORT	443
SERVER_NAME	www.retail4growth.com
REMOTE_ADDR	216.73.217.112
SERVER_SOFTWARE	nginx/1.10.3
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR
HTTP_DNT

base_url	https://www.retail4growth.com/
index_page
uri_protocol	REQUEST_URI
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
composer_autoload
permitted_uri_chars	a-z 0-9~%.:_\-!+
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	0
log_path
log_file_extension
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key
sess_driver	files
sess_cookie_name	ci_session
sess_expiration	7200
sess_save_path	/tmp
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
standardize_newlines
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
crumb_divider	»
tag_open	<div class="breadcrumb xlarge">
tag_close	</div>
crumb_open
crumb_last_open
crumb_close

Results For "lP"

2581 News Found

Select Citywalk plans to add space & host more brands by next year

Mother’s Recipe launches instant Poha mix

Bisleri goes local with regional language labels

Insync: On crafting shopfits for the connected store

Flying Machine revamps its store design

Wipro Lighting collaborates with Cisco on Smart Lighting Solutions

The visual narrative

Malhar Plast launches new range of sleek LGPs for signages

Arttdinox: Inside vs Outside

Emotion – The Future of Competitive Advantage

Tesor: An eclectic home decor destination

Creating an icon of recognition

Breaking the clutter at GT!

Godrej Nature’s Basket unveils new flagship at Worli, Mumbai

Packaged Food: Luring The Indian Palate