SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035101 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035101 [ RunTime:0.003244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936503,289982,426145,722105,527068,554914,234554,447557,157611,795401,878313,796276,862177,30754,26148,149001,592961,67602,2722,774662,434947,968222,308456,550630,552774,987620,922708,463689,873883,843391,787214,671535,401196,305046,713120,767281,305445,969238,93818,1026351,148473,820654,742919,651766,927141,752133,722450,30629,368109,714764,880510,583856,302633,854571,865956,955212,339384,864734,790706,930387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]