SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414686 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414686 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663957,265265,864514,37715,94379,355658,1000999,337480,456444,51088,189592,108885,249451,531957,523363,1021236,843384,97294,944010,900667,382258,820122,934860,554669,739166,1043333,575303,865017,683345,107251,115767,633965,76092,607452,948925,962399,730422,491604,65045,599366,290580,56005,40326,634568,322201,537111,245677,916944,787455,62545,137888,414023,515818,173998,514465,459916,575201,64613,169541,25612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]