SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345712 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345712 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710531,774244,523183,783795,778157,445055,512241,256982,637993,641282,408370,913898,875913,883640,941513,601174,57820,126593,370132,198356,382362,166424,992870,565238,148474,372771,95496,176766,288343,284433,434088,200985,619717,500355,757262,714607,1038910,477991,38920,259860,469658,267122,200263,373497,468820,14231,1010337,10879,48513,280196,607585,480637,847685,734479,122738,363878,219645,854667,583896,436617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]