SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442315 LIMIT 1 [ RunTime:0.002556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442315 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948165,621505,554520,992908,428303,877729,303780,841347,243422,559738,825389,908355,862480,855233,575728,849608,669100,347229,421661,688538,936751,484077,62177,614702,550165,1036039,710501,609514,321981,1022386,913502,268196,132380,746222,52244,299092,847187,191287,359263,882008,468018,647313,783592,864893,66145,356669,676255,23071,183118,726972,1025148,64513,101794,94700,657799,142096,606393,942540,152022,517696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]