SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481084 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481084 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298614,80546,18473,835289,465252,955682,585304,178646,748631,192691,944676,816105,891600,971147,403288,847367,433589,644778,794405,314208,330878,236465,627811,388403,929693,1021329,795501,69114,292032,906488,305654,762024,527947,99311,854903,455464,872835,406041,706334,1270,936823,975475,628331,994994,914321,974599,149104,853292,533806,543784,432426,664308,486805,751763,487580,146292,18018,456345,571843,859752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]