SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502440 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502440 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648356,740166,819142,538848,855146,122444,369941,280391,228985,468485,661907,712878,708750,483570,398958,807727,183949,149352,1030679,643336,498436,308567,816523,455117,760607,156676,566772,474389,103558,706333,312248,321793,878679,439473,533224,127585,957594,1015486,881352,551864,6145,282820,764099,718260,670014,898959,895228,223866,374529,431347,386889,180869,558907,618443,962296,500455,381488,717788,374207,135650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]