SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 716923 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 716923 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582271,288568,183090,1041180,229780,1040373,526722,29684,968471,369214,667593,867187,876422,415356,963440,857652,501473,547904,407034,601249,437856,974449,237999,770259,954782,517038,324987,361417,532433,349415,986250,289527,286131,710667,168637,560860,580412,622858,308061,629378,305162,129690,452082,645222,322303,376083,991315,187181,706529,222952,1006789,1018571,671944,563830,562613,347833,747522,968398,596345,595439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 716923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 716923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]