SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194002 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194002 [ RunTime:0.001366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257075,41302,741540,576948,631458,402635,338162,839979,358346,288699,733413,971021,260978,151823,676105,744125,229982,410637,903192,367431,244988,622860,940402,17683,14154,83314,22394,469982,925703,251583,119557,502855,303581,888601,603976,145394,638040,301950,789823,1034072,984004,576541,97935,121885,945793,1043235,560136,219218,78955,800921,992760,213037,111593,831584,172560,199013,436887,6312,910281,906352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001044s ]