SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59683 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59683 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196005,31646,860681,131264,891317,692452,540118,647447,505970,37084,590764,28913,21501,131346,612041,120277,968262,528804,494729,527144,771547,380432,435536,1048157,101270,226509,594344,202273,132986,79932,272690,16715,831338,144560,457301,322513,1018549,342359,410611,508448,276836,615456,997618,404206,735392,391182,256519,386269,637651,132681,492693,525524,570630,120792,595302,831067,923832,682479,514963,870074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001408s ]