SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481057 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481057 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55405,111023,458778,581610,686117,365410,178850,332571,613562,336561,938992,772577,309946,997785,855881,425781,495869,90282,165214,224388,753930,483984,19813,598109,807651,397625,619316,697242,323277,468538,173068,517885,582526,849440,395588,236129,580616,138106,377680,357862,628549,703470,1046268,729578,544285,833694,12868,919653,897750,822885,505825,1011664,424778,270565,1002209,651687,123614,994396,479583,616642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001867s ]