SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487196 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487196 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939824,113316,374722,630921,265986,133726,940122,64192,551174,901322,442346,813745,7034,467824,249041,1001159,751919,443166,45008,964913,725792,1035854,499183,549950,587066,882965,1032297,85356,962096,738316,665274,187723,990263,382587,366165,302823,586098,660406,778895,742027,235978,206426,552463,514868,1007664,120398,305207,943095,831094,190401,520226,864638,506213,29716,487930,671818,280793,862824,328406,432801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001098s ]