SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507628 LIMIT 1 [ RunTime:0.002127s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507628 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596105,793243,704449,177048,91384,116117,682359,897961,343814,408265,1013231,737065,393997,801,103726,516489,790414,410321,232056,310536,591221,415415,845489,113565,89011,899615,111458,871592,335672,86135,747180,683986,503226,763734,229820,818149,684754,1032510,848288,506007,19338,871600,55071,114153,390327,18373,866275,915270,156260,231026,466259,396182,817403,1036703,896401,756591,967190,347998,13854,747166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001230s ]