SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026469 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026469 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492632,415800,311989,142575,198381,1047428,681600,203416,871699,434229,709441,103385,699738,22594,334599,220712,388173,702376,463397,203734,46712,8343,1510,487704,245499,78577,128735,812286,836880,665771,160572,603895,202668,689288,623740,98991,222115,880424,297801,574034,697744,471052,74394,635261,243003,90070,1026087,372342,62038,795224,441319,410114,1022630,308193,930212,1014077,471112,504475,84787,601861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]