SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506096 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506096 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246861,751870,925277,46509,322718,36742,959827,352553,430694,854951,135104,43387,334432,651736,303251,972109,272286,17618,486967,361488,308295,478957,990163,878949,161098,133263,739476,608699,178078,58953,437447,859979,905373,323418,2366,768859,686834,62595,514011,674545,571691,423383,364981,640888,394235,614744,286958,798441,167831,138420,614350,334926,469883,101480,959766,620724,220195,878123,498278,169363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]