SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397616 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397616 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26480,532973,383751,521694,539315,804642,628809,916727,511277,1037473,336977,807828,426302,995437,732833,566573,82539,659787,134007,110222,414701,138212,834673,525035,71251,470858,111330,34291,1044784,178950,548922,176460,989423,158657,329402,800905,186685,677144,906202,119451,200022,55917,689697,694996,111208,207527,847154,902184,888247,433700,872277,250350,655287,741481,868975,634433,205899,2034,875844,98303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]