SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415549 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415549 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507588,694077,530227,12955,779202,1039988,639491,943719,684131,66681,296486,610219,691924,605061,781593,192362,55980,942736,859450,5896,958312,470737,737388,909464,347450,357229,706564,758768,14865,197607,722697,391521,48371,669034,893270,500916,322140,728974,949399,473736,560373,708963,487663,845164,113647,773956,145069,906566,149140,566243,182945,396785,544772,390779,940081,620674,229692,496704,360724,511489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415549 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415549 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000872s ]