SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541615 LIMIT 1 [ RunTime:0.001460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541615 [ RunTime:0.005694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259804,198371,901451,111206,467047,344862,199126,430638,216096,880787,445769,795394,510485,412493,584550,644672,160982,53622,247596,228670,561406,558372,138691,707109,80634,937278,832179,272066,833116,228087,792500,451766,300889,478901,323480,505082,948607,222471,262184,1033560,675041,762178,710423,60877,56581,63073,419266,392263,908069,103611,995982,893243,556488,616389,768020,583374,769947,545116,699242,859832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003250s ]