SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396824 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396824 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597708,453033,8699,167940,839452,504519,489600,723638,1047867,170272,408900,947978,1010712,386259,580462,224121,674061,870273,1018333,319780,21488,871632,1018140,259747,214201,328658,419160,1037810,762733,686046,324355,478750,428859,226469,242405,19345,618206,647651,233456,776064,451004,885553,620198,47240,17874,358616,344722,434717,870093,360376,498667,846681,330461,867844,217688,987552,705065,403184,492376,271090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]