Author(s): Tarik Ozkul, Mohammed A. Tuffaha and Lamees Elhiny
Page: [89 - 98] Pages: 10
* (Excluding Mailing and Handling)
Background: Power consumption has become one of the most serious obstacles ahead of performance increase. Due to increased power consumption, increasing number of transistors does not seem to be viable anymore. We are being forced to consider other ways of increasing performance without increasing power consumption. To fınd solution to the problem, the power consumption issue is being looked at more and more carefully at architectural level.
Methods: Recent publications and patent databases are reviewed to find extraordinary and innovative architectural techniques developed for reducing power consumption and increasing performance.
Results: In most of the cases the focus was specifically on memory area because of the studies that indicated that memory is the biggest power consumer in a typical processor system. The focus of the most methods was also on the cache memory part of the processor system since cache memory is a part that is used with every instruction execution. Any reduction in power cost of the cache memory results in sizable power reduction. Among the methods suggested were techniques of linking cache memory cells to reduce number of operations, reducing size of the cache memory by using multiple small cache memories activated one at a time.
Conclusion: Based on the study it can be concluded that future innovative developments to reduce power consumption should concentrate on: a) Main memory part: to reduce the power consumption of main memory by turning on/off unused blocks of memory without effecting performance, b) Cache memory part: use of cache memory efficiently without decreasing performance, c) Efficient multiprocessing architectures. By integrating above mentioned methods to multiprocessors it may be possible to reduce the power consumption further.
Keywords: Instruction Set Architecture (ISA), power, Register File (RF), Register lock, multiprocessing, linked cache, one bit tagged cache, code compression, shared resources.
1 x Application (58.56%) | 128ms |
1 x Booting (41.44%) | 90.44ms |
Backtrace |
|
INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('59850559','',1,1744718544,1744718544)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1744718544
Backtrace |
|
INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('59850559','/article/68593',1,1744718544,1744718544)
Backtrace |
|
(select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_corporate WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_token WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_trail WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_corporate WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_token WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59850559 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59850559) limit 1
Bindings |
|
Backtrace |
|
SELECT at.type_name, p.copyright, p.publisher_location,m.month,y.year,
a.publish_on, a.nid article_nid,a.article_id, a.pmid, a.issue_id, a.title, a.abstract,a.podcast,a.altmetric_score,a.altmetric_url,a.kudos_url, a.page_count, a.first_page, a.elocator,
a.last_page, i.publication_date, a.file_name,
a.file_path, a.doi, a.is_epub,a.epub_type, a.volume_id, a.is_uploaded, a.editor_choice, a.is_epub, j.image_file_name,
a.article_no, a.art_type AS article_type, a.supplementary_filename,a.html_filename,a.prc_filename,a.epub_filename, a.graph_abs_lg_filename, a.graph_abs_sm_filename, a.oa_image_lg_filename, a.oa_image_sm_filename, j.journal_banner,a.animated_abstract,a.erratum_in,a.erratum_for,
(CASE WHEN a.issue_id =0 THEN j.epub_price ELSE j.price END) AS sell_price, j.epub_price, j.nid AS jour_nid, j.title AS journal_title, j.issn, j.eissn,j.journal_id, j.subtitle AS jour_subtitle,
v.volume_id,v.volume_name AS volume, v.year_id, i.title AS issue, i.month_id ,i.type issue_type, j.subtitle,j.formerly_title, ac.subtitle AS epub_title,a.crossmark_enabled,a.text_mining_urls,a.license_urls,a.created, a.receivedate, a.revisedate, a.acceptdate,js.js_title
FROM article a
LEFT JOIN article_section ac ON a.is_epub = ac.art_sec_id
LEFT JOIN journal_section js ON a.js_id = js.js_id
LEFT JOIN article_type at ON a.art_type = at.art_type_id
LEFT JOIN issue i ON a.issue_id = i.issue_id
LEFT JOIN month m ON m.id = i.month_id
LEFT JOIN volume v ON v.volume_id = a.volume_id
INNER JOIN year y ON y.id = v.year_id
INNER JOIN journal j ON j.journal_id = a.journal_id
INNER JOIN publisher p ON p.publisher_id = j.publisher_id
WHERE a.article_id=68593
Backtrace |
|
select * from `journal` where `journal_id` = 99 limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword,
j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=99) and sj.journal_id!=99 group by `j`.`nid`) as `aggregate_table`
Backtrace |
|
select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword,
j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=99) and sj.journal_id!=99 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
Backtrace |
|
select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id,
v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id
FROM subject_journal
WHERE journal_id=99) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
Backtrace |
|
select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id,
v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id
FROM subject_journal
WHERE journal_id=99) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
Backtrace |
|
select * from `keywords` where `article_id` = '68593'
Bindings |
|
Backtrace |
|
select * from `article_citation` where `article_id` = '68593'
Bindings |
|
Backtrace |
|
select CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors,
CONCAT(au.last_name, IFNULL(CONCAT(' ', au.initials), ''), ' ', au.first_name) AS authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (GROUP_CONCAT(TRIM(BOTH ', ' FROM
CONCAT(ifnull(concat(af.institution,','),''), ifnull(concat(af.department,','),''), ifnull(concat(af.address,','),''), ifnull(concat(af.city,','),''), ifnull(concat(af.country,','),''), ifnull(concat(af.postal_code,','),''), ifnull(concat(af.phone,','),''), ifnull(concat(af.fax,','),'')))
SEPARATOR '|')) as `author_affiliation`, (GROUP_CONCAT(TRIM(BOTH ', ' FROM
CONCAT(ifnull(concat(af.web_view,','),'')))
SEPARATOR '|')) as `web_view` from `author` as `au` left join `author_affiliation` as `af` on `au`.`author_id` = `af`.`author_id` where `au`.`article_id` = '68593' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
Bindings |
|
Backtrace |
|
select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
Bindings |
|
Backtrace |
|
select `subtitle` from `journal` where `continues_publication_journal` = 1
Bindings |
|
Backtrace |
|
Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j
join volume v on j.journal_id = v.journal_id
join issue i on v.volume_id = i.volume_id
join article a on a.issue_id = i.issue_id
join year y on v.year_id = y.id
where j.journal_id = 99 and i.is_uploaded = 1
order by v.volume_name+0 desc, i.title+0 desc limit 1
Backtrace |
|
select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id,
a.issue_id,a.title,first_page, last_page,
page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name,
a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 99 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
Backtrace |
|
select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id,
a.issue_id,a.title,first_page, last_page,
page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name,
a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 99 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
Backtrace |
|
select pdf, html, epub, prc from `article_metrics` where `article_id` = 68593 limit 1
Bindings |
|
Backtrace |
|
select * from content_by_diseases
where content_id = 68593 and content_type = 'article' order by status desc limit 1
Backtrace |
|
select * from `node_meta` where `nid` = 132830 limit 1
Bindings |
|
Backtrace |
|
select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
Bindings |
|
Backtrace |
|
select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CSENG' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
Bindings |
|
Backtrace |
|
select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '68593' and content_type = 'a'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)
Backtrace |
|
select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '6945' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)
Backtrace |
|
select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '1842' and content_type = 'v'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)
Backtrace |
|
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN 111 THEN true ELSE false END as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1842) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
false as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1842) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
false as terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1842)
Backtrace |
|
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN 111 THEN true ELSE false END as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6945) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
false as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6945) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
false as terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6945)
Backtrace |
|
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN 111 THEN true ELSE false END as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 68593) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
false as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 68593) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
false as terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59850559 and j.to_ip >=59850559 )) and ((j.from_date <= 1744718544 and j.to_date >= 1744718544 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 68593)
Backtrace |
|
select * from `article` where `first_page` < '89' and is_uploaded = 1 and issue_id = 6945 order by cast(first_page as SIGNED) desc limit 1
Bindings |
|
Backtrace |
|
select * from `article` where `last_page` > '98' and is_uploaded = 1 and issue_id = 6945 order by cast(first_page as SIGNED) asc limit 1
Bindings |
|
Backtrace |
|
select `language_id` from `multilanguage` where `short_code` = 'en'
Bindings |
|
Backtrace |
|
select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
Bindings |
|
Backtrace |
|
select `id` from `multilanguage_article` where `article_id` = 68593 limit 1
Bindings |
|
Backtrace |
|
select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 99 and `b`.`banner_from_date` <= 1744718544 and `b`.`banner_to_date` >= 1744718544 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `uc_cart_products` where cart_id='fdcdf52df1f72236e177a6a5ffd41aae'
Backtrace |
|
200
[]
[]
0 of 0array:17 [▼ "x-https" => array:1 [▶ 0 => "1" ] "host" => array:1 [▶ 0 => "beta.benthamscience.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IitCaktaVTYrZXMvdFlXdkc1Qjg4SlE9PSIsInZhbHVlIjoidmFMWldNbVRXMHhMM3g4bFd5VmNqQUJjRFd3TWhnUkNNVUcvTlJZU1hSN2pmVGpndEtXWTB3OG9vWDcwWG9MZHYrTkJzSXJzZE9XS0hIRk5iQVZNdkJLaHpOREFKa1puVG16WGVOM0t3Sk1zWEV6MTVTa0JPRWRyb1VYdUIvcU0iLCJtYWMiOiI3ZjE3ZTI1OTRmZjc3M2NmN2NmOTExMTE1YmZkZjM4YjQyZTQ5YjJhYWRmYTdiZDE0YWVkZTMzZDc1NzFjODU1IiwidGFnIjoiIn0%3D; eurekaselectnew_session=eyJpdiI6IjhmNXJ0MktZMytLMEtRa3Nqb25MZUE9PSIsInZhbHVlIjoiUHFySzlLZE05T3Y5MVFUSitnZTRTTWRsMXFCM1NjR3plQlRvTE9XaW1HQ0R5VGp4SXNvOGdsSnBzNUZyUUpBVVNTWnkvNXd5NWdJZFMyNHZhT2hUYXZVbFZjbUFoYlVoWitMLytpTUc4LzhvaUsyZnB6UHoyK2dIelBFVEs3YWUiLCJtYWMiOiJjNzZmM2UxYjI3Y2NhOTI0NjM1OTYzM2I0MmVmYTE0OWM1MjM2ZjMzMzM3YTExNThkZjE4NjYzNjkxYmJlOWQ5IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IitCaktaVTYrZXMvdFlXdkc1Qjg4SlE9PSIsInZhbHVlIjoidmFMWldNbVRXMHhMM3g4bFd5VmNqQUJjRFd3TWhnUkNNVUcvTlJZU1hSN2pmVGpndEtXWTB3OG9vWDcwWG9MZHYrTkJzS ▶" ] "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" ] ]
0 of 0array:2 [▼ "XSRF-TOKEN" => "4CeX1g5MoxAkI7Z0VBk6WOoO7wzcq3BsbRCkLdoY" "eurekaselectnew_session" => "ZWSfyuXmJHPAgKjrPaE4EbjOp41nyeTpZ36RN3uw" ]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Tue, 15 Apr 2025 12:02:24 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Inl4VGpCNW04Kzhzd3ZPeENOWjRLYlE9PSIsInZhbHVlIjoiM2lXb3VDMWNVMzBVK3hCbFg3ME5JdENsZ0V5Qlh4QVYrQitpb1ExcCtPYUxsT2dwNXoxQ0lBNDBKL2ZYRXQ0R3VObHBWM2xkcXFmNFJxMzBabkxhTCtuUENkZkhpWmg0RzlQYmFxMlRvNGtySzBjZWRPbVNMUmZxL1N1VkJmYkoiLCJtYWMiOiI4YzA5MGRjNzU3YWVjYTBiNDQ2YTNlYjE5MTMwZWZiM2ZmZjliMDY5ZWJjMWU2ZjNkOTc1ZjcyMDgxNDQ5MTNhIiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 00:02:24 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6Inl4VGpCNW04Kzhzd3ZPeENOWjRLYlE9PSIsInZhbHVlIjoiM2lXb3VDMWNVMzBVK3hCbFg3ME5JdENsZ0V5Qlh4QVYrQitpb1ExcCtPYUxsT2dwNXoxQ0lBNDBKL2ZYRXQ0R3VObHBWM ▶" 1 => "eurekaselectnew_session=eyJpdiI6Im84WWNCeHU4Vmp2SGRRMG5reWZZYXc9PSIsInZhbHVlIjoidjNQekJNYU94QklZOXB6aU1TakhNZVJPM09QaHp2NFRSTW1WWm9GVUFkSGJhZkg3d3lyZHR6Z3lFam5LZVlvTmlNWitUWHNybVBPYk5UaDN3ekIyei9IZEk5bzVVRW5UMjArOGd0ZEN5ZjJsSDQ4Z2R6WGE5dzhxdHFnYUV4SloiLCJtYWMiOiI1YWEyZjUyZjNjNDNiNWM0MWExNDIyYTY5MjVmYWJjZjgwYWNiMGQ1ZTI2OTJiZGRlMjE3ZmM0Yjc2ZTFiZjVjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6Im84WWNCeHU4Vmp2SGRRMG5reWZZYXc9PSIsInZhbHVlIjoidjNQekJNYU94QklZOXB6aU1TakhNZVJPM09QaHp2NFRSTW1WWm9GVUFkSGJhZkg3d3lyZHR6Z3lFam5L ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Inl4VGpCNW04Kzhzd3ZPeENOWjRLYlE9PSIsInZhbHVlIjoiM2lXb3VDMWNVMzBVK3hCbFg3ME5JdENsZ0V5Qlh4QVYrQitpb1ExcCtPYUxsT2dwNXoxQ0lBNDBKL2ZYRXQ0R3VObHBWM2xkcXFmNFJxMzBabkxhTCtuUENkZkhpWmg0RzlQYmFxMlRvNGtySzBjZWRPbVNMUmZxL1N1VkJmYkoiLCJtYWMiOiI4YzA5MGRjNzU3YWVjYTBiNDQ2YTNlYjE5MTMwZWZiM2ZmZjliMDY5ZWJjMWU2ZjNkOTc1ZjcyMDgxNDQ5MTNhIiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 00:02:24 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Inl4VGpCNW04Kzhzd3ZPeENOWjRLYlE9PSIsInZhbHVlIjoiM2lXb3VDMWNVMzBVK3hCbFg3ME5JdENsZ0V5Qlh4QVYrQitpb1ExcCtPYUxsT2dwNXoxQ0lBNDBKL2ZYRXQ0R3VObHBWM ▶" 1 => "eurekaselectnew_session=eyJpdiI6Im84WWNCeHU4Vmp2SGRRMG5reWZZYXc9PSIsInZhbHVlIjoidjNQekJNYU94QklZOXB6aU1TakhNZVJPM09QaHp2NFRSTW1WWm9GVUFkSGJhZkg3d3lyZHR6Z3lFam5LZVlvTmlNWitUWHNybVBPYk5UaDN3ekIyei9IZEk5bzVVRW5UMjArOGd0ZEN5ZjJsSDQ4Z2R6WGE5dzhxdHFnYUV4SloiLCJtYWMiOiI1YWEyZjUyZjNjNDNiNWM0MWExNDIyYTY5MjVmYWJjZjgwYWNiMGQ1ZTI2OTJiZGRlMjE3ZmM0Yjc2ZTFiZjVjIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6Im84WWNCeHU4Vmp2SGRRMG5reWZZYXc9PSIsInZhbHVlIjoidjNQekJNYU94QklZOXB6aU1TakhNZVJPM09QaHp2NFRSTW1WWm9GVUFkSGJhZkg3d3lyZHR6Z3lFam5L ▶" ] ]
0 of 0array:5 [▼ "_token" => "4CeX1g5MoxAkI7Z0VBk6WOoO7wzcq3BsbRCkLdoY" "uc_cart_id" => "fdcdf52df1f72236e177a6a5ffd41aae" "_previous" => array:1 [▶ "url" => "https://beta.benthamscience.com/article/68593" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]