Forums / Developer / please help me find file with sql query

please help me find file with sql query

Next topic

Author	Message
Dmitry Kruglov	Thursday 14 May 2009 9:27:32 am in this system current search work: select ... from ... where [namefield] = 'text' I want to make such a request: select ... from ... where [namefield] like '%text%' in which a file is changed? thank you.

Author

Message

Thursday 14 May 2009 9:27:32 am

in this system current search work:
select ... from ... where [namefield] = 'text'
I want to make such a request:
select ... from ... where [namefield] like '%text%'

in which a file is changed?

thank you.

eZ debug

Timing:

Jan 31 2025 06:25:43

Script start

Timing:

Jan 31 2025 06:25:43

Module start 'content'

Timing:

Jan 31 2025 06:25:43

Module end 'content'

Timing:

Jan 31 2025 06:25:43

Script end

Main resources:

Total runtime

0.0207 sec

Peak memory usage

2,048.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0062	588.0469	180.8281
Module start 'content'	0.0062	0.0067	768.8750	88.7891
Module end 'content'	0.0129	0.0077	857.6641	66.7031
Script end	0.0206		924.3672

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0062

588.0469

180.8281

Module start 'content'

0.0062

0.0067

768.8750

88.7891

Module end 'content'

0.0129

0.0077

857.6641

66.7031

Script end

0.0206

924.3672

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0020	9.8000	12	0.0002
Check MTime	0.0009	4.4613	12	0.0001
Mysql Total
Database connection	0.0016	7.9496	1	0.0016
Mysqli_queries	0.0024	11.6826	4	0.0006
Looping result	0.0000	0.0531	2	0.0000
Template Total	0.0073	35.4	1	0.0073
Template load	0.0008	3.9754	1	0.0008
Template processing	0.0065	31.4060	1	0.0065
Override
Cache load	0.0005	2.5083	1	0.0005
General
dbfile	0.0039	19.0355	10	0.0004
String conversion	0.0000	0.0185	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0020

9.8000

0.0002

Check MTime

0.0009

4.4613

0.0001

Mysql Total

Database connection

0.0016

7.9496

0.0016

Mysqli_queries

0.0024

11.6826

0.0006

Looping result

0.0000

0.0531

0.0000

Template Total

0.0073

35.4

0.0073

Template load

0.0008

3.9754

0.0008

Template processing

0.0065

31.4060

0.0065

Override

Cache load

0.0005

2.5083

0.0005

General

dbfile

0.0039

19.0355

0.0004

String conversion

0.0000

0.0185

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs