SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983910 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983910 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425949,96829,355160,857436,770077,524594,1038554,557484,439252,513637,113772,1015657,126788,899518,442965,62288,657383,297497,459177,601682,724719,961750,267939,218775,846318,120977,758980,888167,153189,291581,320541,330250,835516,51317,940722,259070,938996,8873,787675,3,118311,3326,987183,729099,24479,880672,961972,310801,704144,63059,114830,724584,645883,441622,947342,392478,14101,708124,803766,354158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000957s ]