SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568694 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568694 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924397,185751,29649,649816,1029990,746755,321767,224402,519451,707061,313265,1038282,924383,1014890,753048,295764,122659,429315,534083,979554,723536,755117,209801,328418,504659,805470,1010085,104576,662600,268446,958439,857599,162937,1036504,910805,1012034,805747,442921,537878,33944,156817,195709,435229,369058,841678,656713,906226,258186,326540,490255,863630,292134,265079,803729,726889,341492,928515,183321,203527,910919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]