SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 798618 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 798618 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155478,678524,964984,725528,199811,1026985,23676,512354,43431,410190,152803,950961,23527,647395,185569,811612,123719,630185,737443,878831,647522,5635,419422,110734,854787,336208,54342,993254,473218,536928,790249,528639,760372,196553,121595,917278,772326,1007241,629975,501752,770657,142381,1041254,865945,733990,446118,258768,1023682,95922,562562,981275,504229,492763,736659,471982,97931,172755,776332,909377,679234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 798618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 798618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]