SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415348 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415348 [ RunTime:0.008478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62279,491710,443561,791146,640511,199090,11164,504863,667598,106825,1020359,400126,471412,916816,156704,709229,955420,165869,433016,675353,1040563,968615,243726,816293,357793,968747,123030,934265,822833,629919,173206,445359,274174,287205,756470,260080,720910,208601,430853,731582,575263,729125,477542,1031699,207254,530636,42865,379614,437419,803251,544733,33279,110639,994387,716209,189004,874401,458372,120110,274180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003815s ]