SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481504 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481504 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874913,1039371,714153,531634,645460,362973,714657,35453,810223,108264,148528,225617,463775,963563,816749,563194,454694,614307,960384,1008345,149969,27623,552192,394905,998562,299030,307728,798798,739266,915382,960919,102351,109385,901974,97453,439818,203763,134649,495813,820154,647585,947375,600486,249229,998705,571271,1013906,521728,451864,494544,343910,549206,848501,186208,684902,873662,840965,537306,952471,399057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]