SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501954 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501954 [ RunTime:0.004555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812383,102990,493275,322682,217768,259261,15437,675880,206468,842393,460893,707989,609856,228233,489668,187813,878509,763973,420311,958665,94141,752282,565342,389102,93660,714628,380766,924374,88252,559201,700788,865117,534733,149426,803077,260517,525258,648933,770898,1019614,105471,933483,562470,62323,645826,36454,631695,184984,163618,638034,578919,456201,1014121,490399,280629,629114,977133,549148,135466,492053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]