SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367534 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367534 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038412,989698,633864,492300,336762,608742,222405,426651,340590,926009,27152,576147,357008,632552,357500,855790,501202,632410,364665,604253,594926,932228,760557,859524,732483,503431,542107,714724,454692,654878,563070,805738,688506,542496,984818,345397,497350,688400,573389,532,458711,1017487,132258,43302,185921,476818,952692,123459,859279,504515,129920,487795,457787,661383,291291,545233,159648,55270,224389,964478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]