SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034914 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034914 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454622,360375,858540,310835,787778,402831,339949,952099,903476,389996,471487,175946,87371,493995,864555,787102,60603,442095,504110,937239,206709,593416,201347,730749,710339,677363,569250,154848,1042403,652249,701063,135724,863045,876854,28498,647152,880095,1013818,937725,42418,307036,626820,740634,888507,131684,167168,919383,491650,678994,720259,945223,773936,820483,774713,620358,672968,957568,734375,428405,80750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]