SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254871 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254871 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498245,482950,811375,318539,577979,389506,815189,41044,664149,275368,121346,26179,618962,662076,284580,490483,1024538,845174,416084,1044756,787005,727267,568692,833249,216688,829626,290758,932211,1008776,418084,277252,707609,743808,572793,796292,602485,372196,634917,487434,756250,801776,248059,1035760,748221,182276,796130,996728,280164,467896,155030,598901,422571,650602,759630,31916,326628,492262,968304,1007889,439384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001083s ]