SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501225 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501225 [ RunTime:0.002828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930301,297557,647192,1035142,615958,836533,512247,582968,1031206,405606,520105,1016274,997613,122317,696615,23527,1022119,632439,884805,901610,249728,519173,299289,777069,791220,35641,39425,609675,316981,187107,51202,943029,625942,322224,939126,335371,538192,618230,59889,657792,135778,67435,213968,613750,139710,710303,147182,261262,825739,184197,984126,501059,295400,608673,691808,619176,854721,35604,639298,31440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001038s ]